KQL Search

Query Details

HomeAI ToolsDevice Query

Pivot Device Vulnerabilities

Query

# List all the vulnerabilities each device has in a pivot table

## Query Information

#### Description
This query returns a row for each device with the amount of Critical, High, Medium and Low Vulnerabilities that device has.  

## Defender For Endpoint
```
DeviceTvmSoftwareVulnerabilities
| project DeviceName, VulnerabilitySeverityLevel
| evaluate pivot(VulnerabilitySeverityLevel): (DeviceName: string,Critical: long, High: long, Medium: long, Low: long)
| sort by Critical, High, Medium, Low
```

Explanation

The query lists all the vulnerabilities for each device in a pivot table. It shows the number of Critical, High, Medium, and Low vulnerabilities for each device. The results are sorted by the severity levels of the vulnerabilities.

Details

Bert-Jan Pals profile picture

Bert-Jan Pals

Released: February 14, 2023

Tables

DeviceTvmSoftwareVulnerabilities

Keywords

DeviceTvmSoftwareVulnerabilities,DeviceName,VulnerabilitySeverityLevel,Critical,High,Medium,Low

Operators

projectevaluatepivotsort

Actions