Query Details

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:

  1. Data Source: It looks at a dataset called DeviceEvents, which contains records of various events that occur on devices.

  2. Filter: The query filters these events to only include those where the ActionType starts 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.

  3. 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).

  4. Summarize by Device: It groups the results by DeviceName, so you can see how many ASR events each device has experienced.

  5. 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 profile picture

Bert-Jan Pals

Released: October 20, 2024

Tables

DeviceEvents

Keywords

DeviceEvents

Operators

|wherestartswithsummarizecountbysort

Actions

GitHub