Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    SQL syntax help needed

    Hello

    I am using a network monitoring tool called SolarWinds Orion NPM, in which you can create reports using SQL. The report output and associated SQL I have written so far is attached.

    What I need to do now is calculate the TOTAL time that the node has been down for (e.g. over the past month/week), based on the up/down time stamps in the database. If anybody thinks they may be able to help please get in touch and I can provide more info if needed.

    Thanks in advance
    Amy
    Attached Thumbnails Attached Thumbnails ReportWriterOutput.JPG  
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •