vm_cluster_patch_history_entries

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

Overview

Name	vm_cluster_patch_history_entries
Type	Resource
Id	oci.database.vm_cluster_patch_history_entries

Fields

The following fields are returned by SELECT queries:

get

The patch history details for the specified patch history entry.

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch history entry.
action	string	The action being performed or was completed. (APPLY, PRECHECK)
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)
patchId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch.
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 record of a patch action on a specified target.

Name	Datatype	Description
id	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch history entry.
action	string	The action being performed or was completed. (APPLY, PRECHECK)
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)
patchId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the patch.
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	vmClusterId, patchHistoryEntryId, region		Gets the patch history details for the specified patch history entry.<br />
list	select	vmClusterId, region	limit, page	Gets the history of the patch actions performed on the specified VM cluster in an Exadata Cloud@Customer 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
patchHistoryEntryId	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)
vmClusterId	string	The VM cluster [OCID](/Content/General/Concepts/identifiers.htm).
limit	integer	The maximum number of items to return per page.
page	string	The pagination token to continue listing from.

SELECT examples

get

Gets the patch history details for the specified patch history entry.<br />

SELECT
id,
action,
lifecycleDetails,
lifecycleState,
patchId,
timeEnded,
timeStarted
FROM oci.database.vm_cluster_patch_history_entries
WHERE vmClusterId = '{{ vmClusterId }}' -- required
AND patchHistoryEntryId = '{{ patchHistoryEntryId }}' -- required
AND region = '{{ region }}' -- required
;

list

Gets the history of the patch actions performed on the specified VM cluster in an Exadata Cloud@Customer system.<br />

SELECT
id,
action,
lifecycleDetails,
lifecycleState,
patchId,
timeEnded,
timeStarted
FROM oci.database.vm_cluster_patch_history_entries
WHERE vmClusterId = '{{ vmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;