Skip to main content

saved_searches

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

Overview

Namesaved_searches
TypeResource
Idazure.log_analytics.saved_searches

Fields

The following fields are returned by SELECT queries:

OK response definition.

NameDatatypeDescription
etagstringThe ETag of the saved search. To override an existing saved search, use "*" or specify the current Etag
propertiesobjectThe properties of the saved search.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, workspaceName, savedSearchIdGets the specified saved search for a given workspace.
list_by_workspaceselectresourceGroupName, workspaceName, subscriptionIdGets the saved searches for a given Log Analytics Workspace
create_or_updateinsertsubscriptionId, resourceGroupName, workspaceName, savedSearchId, data__propertiesCreates or updates a saved search for a given workspace.
deletedeletesubscriptionId, resourceGroupName, workspaceName, savedSearchIdDeletes the specified saved search in a given workspace.

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
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
savedSearchIdstringThe id of the saved search.
subscriptionIdstringThe ID of the target subscription.
workspaceNamestringThe name of the workspace.

SELECT examples

Gets the specified saved search for a given workspace.

SELECT
etag,
properties
FROM azure.log_analytics.saved_searches
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
AND savedSearchId = '{{ savedSearchId }}' -- required
;

INSERT examples

Creates or updates a saved search for a given workspace.

INSERT INTO azure.log_analytics.saved_searches (
data__etag,
data__properties,
subscriptionId,
resourceGroupName,
workspaceName,
savedSearchId
)
SELECT
'{{ etag }}',
'{{ properties }}' /* required */,
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ workspaceName }}',
'{{ savedSearchId }}'
RETURNING
etag,
properties
;

DELETE examples

Deletes the specified saved search in a given workspace.

DELETE FROM azure.log_analytics.saved_searches
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND workspaceName = '{{ workspaceName }}' --required
AND savedSearchId = '{{ savedSearchId }}' --required
;