Up Time Report

Question

Is it possible to compile a report in Report Writer to show me the up time for each of my devices being monitored, there's a row on the node table that looks like it holds the uptime but I can't find it in report writer?

Any help would be much appreciated?

Thanks

IT Infrastructure Manager
Pilgrim Hospital
UK

rowle1jt · Answer

Never mind... figured out that I can sort it on the web page! :)

Thanks again!

rowle1jt · Answer

Thank you!  Very usefull!!!  I don't know anything about SQL, but is there  a way to sort by the highest uptime at the top of the page?

Thanks!

Jake

michael.buskin · Answer

Ok,

This is an advanced SQL Report.

Paste this into the SQL Tab

SELECT Caption,VendorIcon,Ip_Address,
DateDiff(hour,Nodes.LastBoot,GetDate()) AS HoursUp
FROM Nodes
ORDER BY 2 DESC

It will get the Node Name. Vendor Icon, Ip Address and Uptime in Hours then order them accending via the Node Name

-------------------------

If you have a problem click on email me with a brief description of the problem and / or solution

[url="mailto:michael.buskin@gmail.com?Subject=A Message from a SolarWinds Forum User"]Email Me

[url="www.v-eight.com"]Visit my Website