Query Details

Microsoft Defender XDR - Threat Protection Reporting

MDXDR Threat Protection Report

Query

AlertInfo
| extend Techniques = parse_json(AttackTechniques)
| mv-expand Techniques
| extend Technique = tostring(Techniques)
| summarize count() by Technique, bin(Timestamp, 1d)
| render timechart

About this query

Microsoft Defender XDR - Threat Protection Reporting

Query Information

Description

Microsoft anounced that they will be retiring the Threat Protection report page - https://security.microsoft.com/mde-reports/threatProtection (accessed through Reports > Endpoints > Threat protection). Instead, they recommend the utilization of Advanced hunting queries and Alert queue filter in Defender XDR.

Use the below KQL queries to retrieve the information previously shown on the Threat Protection report.

References

Microsoft Defender XDR

Alert Techniques

Alert Categories

AlertInfo
| summarize AlertCount=count() by Category , bin(Timestamp,1d)
| render timechart 

Detection sources

AlertInfo
| summarize AlertCount=count() by DetectionSource, bin(Timestamp, 1d)
| render timechart

Severity levels

AlertInfo
| summarize Total=count() by Severity, bin(Timestamp,1d)
| render timechart

Explanation

The query is retrieving information previously shown on the Threat Protection report page in Microsoft Defender XDR. It includes queries for alert techniques, alert categories, detection sources, and severity levels. The results are visualized in timecharts.

Details

Alex Verboon profile picture

Alex Verboon

Released: January 9, 2024

Tables

AlertInfo

Keywords

AlertInfoTechniquesAttackTechniquesTimestampCategoryDetectionSourceSeverityTotal

Operators

extendparse_jsonmv-expandsummarizecountbybinrender

Actions

GitHub