Lansweeper: Add 'Uptime' to your reports

Found a really useful post here on how to add system uptime to your Lansweeper reports. Add the following to your query to add an additional 'Uptime' column

       

Cast(DateDiff(d, 0, DateAdd(second, DateDiff(s, tblAssets.Lastseen, GetDate()) + 
tblAssets.Uptime, 0)) As VARCHAR(15)) + ' day(s) ' + Convert(VARCHAR(8),DateAdd(second, 
DateDiff(s, tblAssets.Lastseen, GetDate()) + tblAssets.Uptime, 0),108) As Uptime