→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now