Windows Uptime Chart

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 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 /
24))
Order By DaysSinceLastReboot desc

Run This Report in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting