Reading Time: 3 minutes
Follow by Email

As you may know, recently I have been doing a lot more with Azure Log Analytics, Azure Monitor and Azure Dashboards.  You can see my previous blog posts at One thing I have wanted to do is to see all active Azure Monitor alerts on one of my Dashboards. After having a play with Azure Workbooks (which are still in preview at the time of writing) I was able to create a workbook that will list out all my active alerts and then allow me to pin that part of the workbook to an Azure Dashboard.

If you are unfamiliar with Azure Workbooks you can read more about them at

Ok enough, let’s get to it.

First, in Azure go to Azure Monitor. In here you will find Workbooks on the left. Click it.

Click on the blue + New button at the top and then in the next blade click on Add query.

This new blade is where you configure the query to bring back active alerts. Below you will find a list of what to change and what to change it to.

  • Data source = Alerts
  • Resource type = Subscriptions
  • Subscriptions = Select all the subscriptions you want to monitor
  • Results = Alerts
  • Severity  = All or any severity you care about 0-4
  • Condition = Fired
  • Alert State  = New
  • Visualization = Grid

Now click on Column Settings. In here select the columns you do not want to be in your view and under Column render select Hidden. Below is the list of columns I use.

  • Name
  • Severity
  • Condition
  • Target Resource
  • Target Subscription
  • Target Resource Group
  • Modified

Fell free to choose whatever you need. Then click Apply.

You can also set both Severity and Condition to Icon and you will get some nice graphics too.

Once you have finished with the column settings click on Save and Close.

You should now have something like in the image below.

Now click on the Save icon.

In here enter a name like Active Alerts then just select your subscription and resource group and location. Then click Save.

Time to Pin!

Now that you have something you are happy with it’s time to pin it to a dashboard. Luckily its really easy to do that. You may have noticed that at the top of this edit query window is a pin icon. Click it.

Note: This will pin to the last active dashboard. Unfortunately, you are not able to pick which dashboard at the moment. Hopefully, it will change.

Just click Pin All.

At the top of your browser window will be a purple bar. Click the button and you will be redirected to your dashboard and the newly pinned item.

Here you can resize it and move it around.

And there you have it. All you active Azure alerts on a nice dashboard.

I hope you found this helpful. If you have any questions or comments please leave them below or reach out via social media.

Follow by Email

Pixel Robots.

I’m Richard Hooper aka Pixel Robots. I started this blog in 2016 for a couple reasons. The first reason was basically just a place for me to store my step by step guides, troubleshooting guides and just plain ideas about being a sysadmin. The second reason was to share what I have learned and found out with other people like me. Hopefully, you can find something useful on the site.


Owain · June 7, 2020 at 1:23 pm

Hi, l don’t have an option to select Alerts as a data source for the workbook, has something changed recently and this has been removed?

    Pixel Robots. · June 7, 2020 at 1:44 pm

    Hello, It looks like you must use Azure Resource Graph now instead.

    You can use the below query to get the basic information.

    | where properties.essentials.alertState == “New”
    | where properties.essentials.monitorCondition == “Fired”
    | project name, properties.essentials.severity, properties.essentials.monitorCondition, properties.essentials.targetResource, properties.essentials.targetResourceName, properties.essentials.targetResourceGroup, properties.essentials.lastModifiedDateTime

    Hope it helps.

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *