KQL Search

Query Details

HomeAI ToolsDevice Query

Active EOS Software

Query

# End of Support software used 
----
### Defender For Endpoint
```
DeviceTvmSoftwareInventory
| where EndOfSupportStatus == "EOS Version" or EndOfSupportStatus == 
"EOS Software"
| summarize TotalDevices = count(), EOS_Devices = make_set(DeviceName) 
by SoftwareName, SoftwareVersion
| sort by TotalDevices

```

Explanation

This query is looking at the software inventory for Defender For Endpoint and identifying the number of devices that are using software versions that have reached their end of support. It then groups the devices by the software name and version and sorts them based on the total number of devices.

Details

Bert-Jan Pals profile picture

Bert-Jan Pals

Released: February 14, 2023

Tables

DeviceTvmSoftwareInventory

Keywords

DeviceTvmSoftwareInventory,EndOfSupportStatus,EOSVersion,EOSSoftware,TotalDevices,EOS_Devices,SoftwareName,SoftwareVersion

Operators

where==orsummarizecount()make_set()bysort by

Actions