KQL Search

Query Details

HomeAI ToolsDevice Query

Signature Version Pie

Query

//Creates a PIE chart showing the threat protection signature versions.

ProtectionStatus
| project DeviceName, ThreatStatus, TenantId, ProtectionStatus, SignatureVersion, ScanDate, ProtectionStatusDetails
| summarize sig_count=count() by SignatureVersion
| render piechart by sig_count

Explanation

This query creates a pie chart that displays the different versions of threat protection signatures. It retrieves information about the device name, threat status, tenant ID, protection status, signature version, scan date, and protection status details. It then summarizes the count of each signature version and renders it as a pie chart.

Details

Rod Trent profile picture

Rod Trent

Released: September 15, 2021

Tables

ProtectionStatus

Keywords

DeviceName,ThreatStatus,TenantId,ProtectionStatus,SignatureVersion,ScanDate,ProtectionStatusDetails

Operators

projectsummarizerender

Actions