Queries for the DeviceTvmSoftwareInventory table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Unsupported software titles

List software titles which are not supported anymore.

DeviceTvmSoftwareInventory
| where EndOfSupportStatus == 'EOS Software'
| summarize dcount(DeviceId) by SoftwareName