Use Resource Graph to identify what resources are configured for alerts and notifications?

Question

Is there a way to use Resource Graph query to retrieve what alerts are configured for resources, and who the alert notification would get sent to? Not looking to retrieve the actual alerts. There are several resource groups for which we want to retrieve this. Thanks for any insights

Accepted Answer

@feelsLikeHome2020 Welcome to Microsoft Q & A Community Forum. I understand that you are trying to retrieve the list of alerts that are configured on the resources along with the actionGroups.

Here is a sample kusto query that will retreive the requested results.

Resources  
| where type=='microsoft.insights/metricalerts'  
| project name , type , resourceGroup , actionGroups = properties.actions ,scopes = properties.scopes  
| mv-expand actionGroups   
| extend actionGroupId = tostring(actionGroups.actionGroupId)  
| join kind=inner (  
  Resources | where type == 'microsoft.insights/actiongroups'  
  | project actionGroupId= tostring(id), name, type , properties  
) on actionGroupId  
| project-away actionGroups  , actionGroupId1 , name1 , type1

This query projects below information

name : Name of the metric alert
type : specifies the type of alert
resourceGroup : resourceGroup of the alert where it exists
scopes : list of resources where the alert is configured
actionGroupId : Id of the action group that is linked to alert
properties : contains the collections of notifications preferences.

Share via

Use Resource Graph to identify what resources are configured for alerts and notifications?

0 additional answers

Your answer