Skip to main content

log_saved_searches

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

Overview​

Namelog_saved_searches
TypeResource
Idoci.logging.log_saved_searches

Fields​

The following fields are returned by SELECT queries:

Successfully retrieved LogSavedSearch.

NameDatatypeDescription
idstringThe OCID of the resource.
namestringThe user-friendly display name. This must be unique within the enclosing resource, and it's changeable. Avoid entering confidential information.
compartmentIdstringThe OCID of the compartment that the resource belongs to.
definedTagsobjectDefined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: {"Operations": {"CostCenter": "42"}}
descriptionstringDescription for this resource.
freeformTagsobjectFree-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"}
lifecycleStatestringThe state of the LogSavedSearch (CREATING, ACTIVE, UPDATING, INACTIVE, DELETING, FAILED) (x-obmcs-top-level-enum: #/definitions/LogSavedSearchLifecycleState)
querystringThe search query that is saved.
timeCreatedstring (date-time)Time the resource was created.
timeLastModifiedstring (date-time)Time the resource was last modified.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectlogSavedSearchId, regionopc-request-idRetrieves a LogSavedSearch.
listselectcompartmentId, regionlogSavedSearchId, name, page, limit, sortBy, sortOrder, opc-request-idLists LogSavedSearches for this compartment.<br />
createinsertregion, compartmentId, name, queryopc-retry-token, opc-request-idCreates a new LogSavedSearch.<br />
updateupdatelogSavedSearchId, regionif-match, opc-request-idUpdates an existing LogSavedSearch.<br />
deletedeletelogSavedSearchId, regionif-match, opc-request-idDeletes the specified LogSavedSearch.
change_compartmentexeclogSavedSearchId, region, compartmentIdopc-retry-token, if-match, opc-request-idMoves a saved search into a different compartment within the same tenancy. For information about moving<br />resources between compartments, see [Moving Resources to a Different Compartment](/iaas/Content/Identity/Tasks/managingcompartments.htm#moveRes).<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.

NameDatatypeDescription
compartmentIdstringCompartment OCID to list resources in. See compartmentIdInSubtree for nested compartments traversal.
logSavedSearchIdstringOCID of the logSavedSearch.
regionstringOCI 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)
if-matchstringFor optimistic concurrency control. In the PUT or DELETE call for a resource, set the if-match parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value.
limitintegerWhen setting the page limit, specifies the maximum number of unfiltered records that can be fetched from the data store in one request. Filtering happens after the records are retrieved. Subsequent pages might include results that match the query criteria.
logSavedSearchIdstringOCID of the LogSavedSearch.
namestringResource name.
opc-request-idstringUnique Oracle-assigned identifier for the request. If you need to contact Oracle about a particular request, please provide the request ID.
opc-retry-tokenstringA token that uniquely identifies a request so it can be retried in case of a timeout or server error, without risk of executing that same action again. Retry tokens expire after 24 hours, but can be invalidated before then due to conflicting operations (e.g., if a resource has been deleted and purged from the system, then a retry of the original creation request may be rejected).
pagestringFor list pagination. The value of the opc-next-page or opc-previous-page response header from the previous "List" call. For important details about how pagination works, see [List Pagination](/iaas/Content/API/Concepts/usingapi.htm#nine).
sortBystringThe field to sort by (one column only). Default sort order is ascending exception of timeCreated and timeLastModified columns (descending).
sortOrderstringThe sort order to use, whether 'asc' or 'desc'.

SELECT examples​

Retrieves a LogSavedSearch.

SELECT
id,
name,
compartmentId,
definedTags,
description,
freeformTags,
lifecycleState,
query,
timeCreated,
timeLastModified
FROM oci.logging.log_saved_searches
WHERE logSavedSearchId = '{{ logSavedSearchId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

INSERT examples​

Creates a new LogSavedSearch.<br />

INSERT INTO oci.logging.log_saved_searches (
compartmentId,
definedTags,
description,
freeformTags,
name,
query,
region,
opc-retry-token,
opc-request-id
)
SELECT
'{{ compartmentId }}' /* required */,
'{{ definedTags }}',
'{{ description }}',
'{{ freeformTags }}',
'{{ name }}' /* required */,
'{{ query }}' /* required */,
'{{ region }}',
'{{ opc-retry-token }}',
'{{ opc-request-id }}'
RETURNING
id,
name,
compartmentId,
definedTags,
description,
freeformTags,
lifecycleState,
query,
timeCreated,
timeLastModified
;

UPDATE examples​

Updates an existing LogSavedSearch.<br />

UPDATE oci.logging.log_saved_searches
SET
definedTags = '{{ definedTags }}',
description = '{{ description }}',
freeformTags = '{{ freeformTags }}',
name = '{{ name }}',
query = '{{ query }}'
WHERE
logSavedSearchId = '{{ logSavedSearchId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match}}'
AND opc-request-id = '{{ opc-request-id}}'
RETURNING
id,
name,
compartmentId,
definedTags,
description,
freeformTags,
lifecycleState,
query,
timeCreated,
timeLastModified;

DELETE examples​

Deletes the specified LogSavedSearch.

DELETE FROM oci.logging.log_saved_searches
WHERE logSavedSearchId = '{{ logSavedSearchId }}' --required
AND region = '{{ region }}' --required
AND if-match = '{{ if-match }}'
AND opc-request-id = '{{ opc-request-id }}'
;

Lifecycle Methods​

Moves a saved search into a different compartment within the same tenancy. For information about moving<br />resources between compartments, see [Moving Resources to a Different Compartment](/iaas/Content/Identity/Tasks/managingcompartments.htm#moveRes).<br />

EXEC oci.logging.log_saved_searches.change_compartment
@logSavedSearchId='{{ logSavedSearchId }}' --required,
@region='{{ region }}' --required,
@opc-retry-token='{{ opc-retry-token }}',
@if-match='{{ if-match }}',
@opc-request-id='{{ opc-request-id }}'
@@json=
'{
"compartmentId": "{{ compartmentId }}"
}'
;