maintenance_run_histories
Creates, updates, deletes, gets or lists a maintenance_run_histories resource.
Overview​
| Name | maintenance_run_histories |
| Type | Resource |
| Id | oci.database.maintenance_run_histories |
Fields​
The following fields are returned by SELECT queries:
- get
Information about the specified maintenance run history.
| Name | Datatype | Description |
|---|---|---|
id | string | The OCID of the maintenance run history. |
dbServersHistoryDetails | array | List of database server history details. |
granularMaintenanceHistory | array | The list of granular maintenance history details. |
maintenanceRunDetails | object | Details of a maintenance run. |
systemTags | object | System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | maintenanceRunHistoryId, region | Gets information about the specified maintenance run history. |
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 |
|---|---|---|
maintenanceRunHistoryId | string | The maintenance run history OCID. |
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) |
SELECT examples​
- get
Gets information about the specified maintenance run history.
SELECT
id,
dbServersHistoryDetails,
granularMaintenanceHistory,
maintenanceRunDetails,
systemTags
FROM oci.database.maintenance_run_histories
WHERE maintenanceRunHistoryId = '{{ maintenanceRunHistoryId }}' -- required
AND region = '{{ region }}' -- required
;