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