Detect the amount of ASR events that have been triggered for each device
ASR Rules Triggered By Device
Query
DeviceEvents
| where ActionType startswith "Asr"
| summarize count() by DeviceName
| sort by count_About this query
Detect the amount of ASR events that have been triggered for each device
Query Information
Description
This query gives an overview of the amount of ASR triggers for each device. A high amount of triggers can indicate that suspicious activities are performed on a device. Both audited and blocked events are listed.
References
Defender XDR
Sentinel
DeviceEvents
| where ActionType startswith "Asr"
| summarize count() by DeviceName
| sort by count_
Explanation
This query is designed to analyze security events related to Attack Surface Reduction (ASR) on devices within a network. Here's a simple breakdown of what the query does:
-
Data Source: It looks at a dataset called
DeviceEvents, which contains records of various events that occur on devices. -
Filter: The query filters these events to only include those where the
ActionTypestarts with "Asr". This means it focuses specifically on events related to ASR, which are security measures intended to reduce the attack surface of a device. -
Count Events: For each device, it counts the number of ASR-related events that have occurred. This count includes both events that were merely audited (logged for review) and those that were blocked (prevented from executing).
-
Summarize by Device: It groups the results by
DeviceName, so you can see how many ASR events each device has experienced. -
Sort Results: Finally, it sorts the devices by the number of ASR events in descending order, so you can quickly identify which devices have the highest number of ASR triggers.
In summary, this query helps identify devices with potentially suspicious activities by showing how many ASR events have been triggered on each device. A high number of triggers might suggest that a device is experiencing unusual or potentially harmful activities.
Details

Bert-Jan Pals
Released: October 20, 2024
Tables
Keywords
Operators