Assets: Software licensekey summary (Built-in)

[Daniel_B]

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