I need to create dashboard in azure for my backup alerts .I want to use kql query to pull the alert how can I do this

Kumari, Nidhi (Cognizant) 0 Reputation points
2023-04-17T03:39:57.9066667+00:00

I need to create dashboard in azure for my backup alerts .I want to use kql query to pull the alert how can I do this. Can anyone give me some idea.

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,148 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SadiqhAhmed-MSFT 39,321 Reputation points Microsoft Employee
    2023-04-17T10:41:25.5933333+00:00

    Hi @Kumari, Nidhi (Cognizant) Thank you for reaching out to us on Microsoft Q&A community platform. Happy to help! For creating dashboard for Azure backup alerts, you can use an Azure Resource Graph query. For example: Like this,

    alertsmanagementresources | where type == "microsoft.alertsmanagement/alerts" | project propertiesList = parse_json(properties) | extend  alertStartTime = propertiesList.essentials.startDateTime, monitorService = propertiesList.essentials.monitorService, targetResourceType = propertiesList.essentials.targetResourceType, affectedDatasourceId = propertiesList.context.sourceId, affectedDatasourceType = propertiesList.context.sourceType, description = propertiesList.essentials.description, state = propertiesList.essentials.alertState | where alertStartTime >= ago(7d) | where targetResourceType == "microsoft.recoveryservices/vaults"

    If the response helped, do "Accept Answer" and up-vote it

    0 comments No comments