Get all active alerts in a resource group

GetAllActiveAlertsInResourceGroup.kql

alertsmanagementresources
| where properties.essentials.targetResourceGroup =~ 'your_resource_group_name'
| where properties.essentials.monitorCondition =~ 'Fired'
| extend severity = tostring(properties.essentials.severity),
    alertCondition = tostring(properties.essentials.monitorCondition),
    userResponse = tostring(properties.essentials.alertState),
    targetResource = tostring(properties.essentials.targetResource),
    fireTime = todatetime(properties.essentials.startDateTime)
| order by fireTime desc 
| project name, severity, alertCondition, userResponse, targetResource, fireTime, properties