Azure Workbook to show the resource health of Azure Services

Question

We are planning to create an Azure Monitor Workbook with a Resource Picker, where users can choose a resource group and we should the health/availability of all the resources within the resource group. The resources can be APIM, ServiceBus, KeyVault, Storage, AppServices, KeyVault etc.

Is there an option to pull the live/historical availability of all the resources within the resource group?

Thanks

Kumar

Answer 1

Yes, you can pull live/historical availability of resources within a resource group using Azure Monitor Workbooks with Metrics and Logs queries, and visualize the data using various visualization options.

For example, to fetch the availability for App Services, use a Kusto query like this:

AppMetrics
| where ResourceGroup == '{ResourceGroup}'
| where MetricName == 'Availability'
| summarize avg(Availability) by Resource

Answer 2

Yes, you can use Azure Monitor to pull live/historical availability data of all resources within a resource group. Here are the general steps to achieve this:

1. Create an Azure Monitor Workbook and add a Resource Picker control to allow users to select the resource group.
2. Use the Resource Group filter to filter the results based on the selected resource group.
3. Use the Azure Monitor REST API to query for the availability/health data for each resource type within the resource group.
4. Use the results to populate the Workbook with the desired visualizations and metrics.

Here are some examples of how to use the Azure Monitor REST API to get availability data:

• For App Services: you can use the Microsoft.Web/sites/availabilityResults REST API to get the availability data for an App Service. You can filter the results based on the resource group and time range.
• For Service Bus: you can use the Microsoft.ServiceBus/namespaces/messagingAvailability REST API to get the messaging availability data for a Service Bus namespace. You can filter the results based on the resource group and time range.
• For Storage: you can use the Microsoft.Storage/storageAccounts/blobServices/containers REST API to get the availability data for a storage account. You can filter the results based on the resource group and time range.

You can find more information about the Azure Monitor REST API and the available resources and metrics on the Azure Monitor documentation.

Please mark my answer if it helped :-)

Answer 3

You can use the template Resource Picker under Azure Monitor/ Workbooks and edit it to add service health information.

Answer 4

The Other option is to check out this workbook from our MVP https://www.cloudsma.com/2020/10/ultimate-azure-inventory-dashboard/