CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more


Windows Operating Systems Chart

Chart Operating System

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.
To use this in a chart widget, prefix the report name with “Chart:” and select it in the chart report widget found on a dashboard.
Operating systems chart

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




Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.