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 https://pixelrobots.co.uk/?s=Azure+Log+analytics. 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 https://docs.microsoft.com/en-us/azure/azure-monitor/app/usage-workbooks
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.
- Target Resource
- Target Subscription
- Target Resource Group
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.