Showing results for 
Show  only  | Search instead for 
Did you mean: 
Lansweeper Alumni
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,