How to use Azure Workbook for publishing alerts in Azure Dashboard

 Introduction

It allows users to create customizable interactive reports and can query data from multiple sources within Azure. It has ability to pin the generated report in Azure dashboard which we can be share it with your team and can be monitored at any time.

As mentioned in previous blog, i will be demonstrating how to use workbook to change the UI of Alerts dashboard and other visualizations & filters.

I'm going to Apply the Day wise filter and change the Color scheme which can be useful for monitoring the alerts.

1.    Add the TimeRange parameter from the Azure Monitor Workbook

2.    Type TimeRange as the title and select the Time Range Picker from the drop down list as highlighted below and select some time range values and save it.

Once done, it will be looks like the below window

3.    Next, add the query and select

4. Select the Data Source, Subscriptions and Copy the alerts query which we created from the previous blog.

5. Add the TimeFired and EventOccured as filter in the query section and run the query

| where TimeFired {TimeRange}

| where EventOccured {TimeRange}

 

6.    Now, change the visualizations based on the status like Active should be in "Red" and Resolved should show as "Green"

Click on the Column Settings and Select Status Column -> Change the Column renderer to Thresholds type -> Change Threshold settings to Colors and change the colors you wanted.

 

Now pin the tiles(Pin All) from the workbook menu item to the dashboard.

Hope this would help you to do more on Azure workbooks and Resource graphs.