→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎02-17-2016 01:03 AM
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
24))) + ' d ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %
24))) + ' hrs ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /
60))) + ' mins ' As Uptime,
Solved! Go to Solution.
‎02-21-2016 03:19 PM
‎02-21-2016 03:19 PM
‎02-17-2016 05:57 PM
Sort [Uptime] by tblAssets.Uptime
Order [Uptime] by tblAssets.Uptime
‎02-17-2016 05:49 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now