Showing results for 
Show  only  | Search instead for 
Did you mean: 
Lansweeper Alumni
The report below gives back a count of OS language versions

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 tblLanguages.Language,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblLanguages On tblOperatingsystem.OSLanguage =
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblState.Statename = 'Active' And (tsysAssetTypes.AssetTypename =
'Windows' Or tsysAssetTypes.AssetTypename = 'Windows CE')
Group By tblLanguages.Language
Order By Total Desc

New to Lansweeper?

Try Lansweeper For Free

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

Try Now