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

TRY NOW

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

Show

Hide

NO CREDIT CARD REQUIRED

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

Explore all our features, free for 14 days.