Monday, 27 June 2016

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

       
 

5 comments:

  1. Lansweeper 8.4.10.8 Crack is a network management tool specifically designed for asset management that is useful for tax calculation and auditing purposes to provide a fair view of your business assets.
    https://softwaregurucrack.com/lansweeper-crack/

    ReplyDelete
  2. I like your all post. You have done really good work. Thank you for the information you provide, it helped me a lot. I hope to have many more entries or so from you.
    Very interesting blog.
    Panda Antivirus Pro Crack
    Lansweeper Crack
    UltraEdit Crack
    EaseUS Data Recovery Wizard Crack
    Glary Utilities Pro Crack
    Ashampoo Photo Recovery Crack
    Recover My Files Crack
    CyberGhost VPN Crack

    ReplyDelete

PerfC Vaccination for ExPetr/Petya/NotPetya Wiper

This is a script I've written to 'vaccinate' our domain against the ExPetr/Petya/NotPetya Wiper. In short, it finds all comput...