KQL Search

Query Details

Workspaces90days Retention

Query

//Run the following in Azure Resource Graph Explorer to show all existing Workspaces set to 90 days retention

resources
| where type == "microsoft.operationalinsights/workspaces"
| where properties['retentionInDays'] == 90

Explanation

This query is used to find all the existing workspaces in Azure that have a retention period of 90 days.