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.
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