Forum Discussion

Nexact's avatar
Nexact
Copper Contributor
Feb 22, 2022
Solved

Is there any tables that contains the list of analytics rules ?

Hello!

 

I'm currently trying to build a dashboard that gives more information about all the analytics rules and I can't find any tables that contain this information.

 

Is it available somewhere or do I need to pull it via the API ?

 

Thanks, 

  • GaryBushey's avatar
    GaryBushey
    Feb 22, 2022

    Nexact There is no table that stores the information but you can get the data by making the following REST API call:

     

    https://management.azure.com/subscriptions/<subscription>/resourceGroups/<resourcegroup>/providers/Microsoft.OperationalInsights/workspaces/<workspace>/providers/Microsoft.SecurityInsights/alertrules?api-version=2021-10-01-preview

     

     

  • Clive_Watson's avatar
    Clive_Watson
    Bronze Contributor
    Feb 22, 2022
    There are Workbooks that do this you can look at, try the "Analytics Efficiency" one - it uses the Rest api
  • GaryBushey's avatar
    GaryBushey
    Bronze Contributor
    Feb 22, 2022

    Nexact There is no table that stores the information but you can get the data by making the following REST API call:

     

    https://management.azure.com/subscriptions/<subscription>/resourceGroups/<resourcegroup>/providers/Microsoft.OperationalInsights/workspaces/<workspace>/providers/Microsoft.SecurityInsights/alertrules?api-version=2021-10-01-preview

     

     

Resources