Down time duration on nodes per Hours

Version 1

    This will give you a total downtime report on each node. Example: is you want to know how many hours "switch 1" has been down for the past year.

    This SQl query is only displaying the "top 25" but if you want to see everything just change "SELECT top 25" to "SELECT top 900"

    Just download the report and place this in C:\Program Files (x86)\Solarwinds\Orion\Reports.