Windows Uptime Chart

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