Get an Overview of the Windows Operating Systems Used in Your Environment
IT environments are becoming more diverse every day with a wide variety of Windows operating systems. Due to legacy applications and Windows EOL, the amount of Windows operating types can easily grow. With this chart report, you can have a quick overview of the number of times specific Windows operating systems 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.
Windows Operating Systems Chart Query
Select Top 1000000 tsysOS.OSname, Count(tblAssets.AssetID) As Total From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1 Group By tsysOS.OSname Order By Total Desc