Old name: License: Software licensekey summary (Built-in)
The report below lists all software serial numbers with the number of assets using each license (note: license key and software installation data are not related)
The report will only list assets that meet all of the following criteria:
- The assets states are set to "active".
- The assets have been successfully scanned at least once.
- The assets are Windows computers.
- There is licensed software information available.
Select Top 1000000 tblSerialnumber.Product,
Count(tblSerialnumber.SerialID) As Total
From tblAssets
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename = 'Active'
Group By tblSerialnumber.Product
Order By Total Desc,
tblSerialnumber.Product
