The report below gives back a list of the number of Windows computers per OS.
The report will only list assets that meet all of the following criteria:
- The computer's state is set to "active".
- The computer has been successfully scanned at least once.
- The asset is a Windows computer.
Select Top 1000000 Coalesce(tsysOS.OSname, 'Unknown') As OS,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblState.Statename = 'Active' And tsysAssetTypes.AssetTypename = 'Windows'
Group By Coalesce(tsysOS.OSname, 'Unknown')
Order By Total Desc
