Afternoon all, is there a way to set operationl hours for each server. I would like build a total uptime report but exclude any reboots that that are outside of business hours.
Thanks in advance
I would set up a couple of node custom properties to indicate the start & end hours for each server and then leverage those in a query to limit the hours of consideration on a per-node basis when I'm building the reports. Something like this:
And then a query might look like this:
SELECT n.Caption, AVG(MaxResponseTime) AS Avg_MaxResponseTimeFROM Orion.Nodes nJOIN Orion.ResponseTime rt ON n.NodeID = rt.NodeIDWHERE DAYDIFF(rt.[DateTime], GetDate()) <= 7 -- only the last 7 days (adjust this for more info)AND HOUR(rt.[DateTime]) >= n.CustomProperties.BusinessHourStart -- after business startsAND HOUR(rt.[DateTime]) <= n.CustomProperties.BusinessHourEnd -- before business endsGROUP BY n.Caption
** Caveat: Business hour reports will only work as long as you have hourly averages. By default SolarWinds sets them to 7 days of detail and 30 days of hourlies. If you need more than 30 days for this report increase the second setting to the # of days required.
--
Steven W. Klassen
Programmer Analyst @ Loop1 Systems
http://www.loop1systems.com/
http://www.linkedin.com/in/mrxinu
