Edit

Share via

Queries for the DeviceTvmSoftwareInventory table

  • Article

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.

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