Skip to content

Instantly share code, notes, and snippets.

@gocha
Last active January 20, 2020 09:31
Show Gist options
  • Save gocha/83799efc5a53d5f32ce0d56d36c92d04 to your computer and use it in GitHub Desktop.
Save gocha/83799efc5a53d5f32ce0d56d36c92d04 to your computer and use it in GitHub Desktop.
Azure Resource Graph: Querying alert logs like Azure Monitor
AlertsManagementResources
| where type =~ 'microsoft.alertsmanagement/alerts'
| where properties.essentials.startDateTime >= datetime('2020-01-01T00:00:00+0900') and properties.essentials.startDateTime <= datetime('2020-01-20T00:00:00+0900')
| order by todatetime(properties.essentials.lastModifiedDateTime) desc
| project name, properties.essentials.severity, properties.essentials.targetResourceGroup, properties.essentials.targetResourceName, properties.essentials.targetResourceType, properties.essentials.signalType, properties.essentials.startDateTime, properties.essentials.description
| limit 50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment