Forum Discussion

dentom's avatar
dentom
Copper Contributor
Apr 01, 2022

Looking for a Query that shows stats of Azure monitor

Hello,

 

Does someone know the query to retrieve the different alerts like shown in the picture here below?

 

 

azure monitor
  • shijain13's avatar
    shijain13
    Icon for Microsoft rankMicrosoft
    Apr 14, 2022

    dentom  You can also use readily available workbook for Alerts under Azure Monitor
    Portal -> Monitor -> Workbooks -> Search Alert 

  • ItayElbaz's avatar
    ItayElbaz
    Icon for Microsoft rankMicrosoft
    Apr 04, 2022

    Hi dentom,

    In order to retrieve all the alerts in this page we are querying ARG.

    If I understand currently you are referring to how we are getting the count of the alerts by severity. For that we are using ARG Facets options:

    https://docs.microsoft.com/en-us/rest/api/azureresourcegraph/resourcegraph(2021-03-01)/resources/resources#facetrequest

     

    The facets will return the summarize count by the given expression for all the results (even when using pagination it will take into account the full available results and not only current page).

     

     

     

    • Clive_Watson's avatar
      Clive_Watson
      Bronze Contributor
      Apr 04, 2022

      dentom 

       

      ARG example:

      alertsmanagementresources
| project name, subscriptionId, Severity_ = tostring(properties.context.SeverityDescription), TimeGenerated_ = todatetime(properties.essentials.startDateTime), properties
| where TimeGenerated_ > ago(30d) // and subscriptionId == '< insert your ID here>'
| where isnotempty(Severity_)
| summarize  count() by Severity_, subscriptionId

       

       

Resources