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


Windows Uptime Chart

Chart Operating System

Get an Overview of Windows Uptimes

Lansweeper is able to provide you with data on how long devices have been online for or also known as their uptime. Uptime data can help to find problematic devices that no have been online for a long time and might be missing out on updates since updates require a system restart. You can read more about using this data in the Pro Tips blog post.
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.
Windows uptime chart

Windows Uptime Chart Query

Select Top 1000000 Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
24)) DaysSinceLastReboot,
Count(tblAssets.AssetID) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1 and tblAssets.Uptime is not null
Group By Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
Order By DaysSinceLastReboot desc




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

Explore all our features, free for 14 days.