Get an Overview of the Windows Languages Used in Your Environment
With this chart report, you can have a quick overview of the number of times specific Windows OS Languages are used. This can be used on your dashboard so you always have the information available at a glance. You can use this report in the dashboard chart report widget to display get the chart displayed below.
Click to Open - Windows Language Summary Chart Query
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 = tblLanguages.LanguageCode Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1 Group By tblLanguages.Language Order By Total Desc