db_system_os_patch_history_entries

Creates, updates, deletes, gets or lists a db_system_os_patch_history_entries resource.

Overview

Name	db_system_os_patch_history_entries
Type	Resource
Id	oci.database.db_system_os_patch_history_entries

Fields

The following fields are returned by SELECT queries:

get

The OS patch operation details were retrieved.

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the OS patch history entry.
action	string	The action being performed or was completed. (PRECHECK, APPLY)
dbSystemId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the DB system.
lifecycleDetails	string	A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
lifecycleState	string	The current state of the action. (IN_PROGRESS, SUCCEEDED, FAILED)
osPatchDetails	object	Results of OS patch details for a DB System.
timeEnded	string (date-time)	The date and time when the patch action completed
timeStarted	string (date-time)	The date and time when the patch action started.

list

The OS patch history for the specified DB system was retrieved.

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the OS patch history entry.
action	string	The action being performed or was completed. (PRECHECK, APPLY)
dbSystemId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the DB system.
lifecycleDetails	string	A descriptive text associated with the lifecycleState. Typically contains additional displayable text.
lifecycleState	string	The current state of the action. (IN_PROGRESS, SUCCEEDED, FAILED)
osPatchDetails	object	Results of OS patch details for a DB System.
timeEnded	string (date-time)	The date and time when the patch action completed
timeStarted	string (date-time)	The date and time when the patch action started.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	dbSystemId, osPatchHistoryEntryId, region	opc-request-id	Gets the details of the specified OS patch action for the specified DB system.<br />
list	select	dbSystemId, region	limit, page, sortOrder, sortBy, lifecycleState, action, opc-request-id	Gets the history of the OS patch actions performed on the specified DB system.<br />

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
dbSystemId	string	The DB system [OCID](/Content/General/Concepts/identifiers.htm).
osPatchHistoryEntryId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch history entry.
region	string	OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
action	string	A filter to return only OS patch history entries that match the specified OS patch action.
lifecycleState	string	A filter to return only OS patch history entries that match the given lifecycle state exactly.
limit	integer	The maximum number of items to return per page.
opc-request-id	string	Unique identifier for the request.
page	string	The pagination token to continue listing from.
sortBy	string	The field to sort by. You can provide one sort order (sortOrder). Default order for TIMESTARTED is descending.
sortOrder	string	The sort order to use, either ascending (ASC) or descending (DESC).

SELECT examples

get

Gets the details of the specified OS patch action for the specified DB system.<br />

SELECT
id,
action,
dbSystemId,
lifecycleDetails,
lifecycleState,
osPatchDetails,
timeEnded,
timeStarted
FROM oci.database.db_system_os_patch_history_entries
WHERE dbSystemId = '{{ dbSystemId }}' -- required
AND osPatchHistoryEntryId = '{{ osPatchHistoryEntryId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

list

Gets the history of the OS patch actions performed on the specified DB system.<br />

SELECT
id,
action,
dbSystemId,
lifecycleDetails,
lifecycleState,
osPatchDetails,
timeEnded,
timeStarted
FROM oci.database.db_system_os_patch_history_entries
WHERE dbSystemId = '{{ dbSystemId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND sortOrder = '{{ sortOrder }}'
AND sortBy = '{{ sortBy }}'
AND lifecycleState = '{{ lifecycleState }}'
AND action = '{{ action }}'
AND opc-request-id = '{{ opc-request-id }}'
;