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'] == 90Explanation
This query is used to find all the existing workspaces in Azure that have a retention period of 90 days.
Details

Rod Trent
Released: July 7, 2023
Tables
microsoft.operationalinsights/workspaces
Keywords
ResourcesMicrosoft.OperationalInsights/WorkspacesPropertiesRetentionInDays
Operators
wheretype==properties['retentionInDays']