Lansweeper: Add Uptime To Your Hardware Reports

Lansweeper: Add Uptime To Your Hardware Reports

on November 12, 2014

Quick tip today. If you need to add an "Uptime" column on your Lansweeper reports, feel free to add the following;

  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

It's not going to be the best column format for sorting but it's definitely useful to see how long your servers have been running since last reboot.

Comments