Reboots and Downtime Report (Last 7 Days)

Updated to include Availability from Orion.ResponseTime, calculated Availability (based on minutes down from Orion.NetObjectDowntime), and the number of 'Node rebooted' events from Orion.Events.

It was inspired by a question posted on the Network Performance Monitor (NPM) Forum.

There is plenty of details in the query about how the information was calculated. There's also a mention (commented out) on how to add filters for Node-based custom properties.

Important Note:

There will be a discrepancy between Availability and the Calculated Availability. This is based on the polling cycles, the pollers being used, and the way data is stored in the database. I (personally) prefer the Calculated Availability because it isn't limited to ICMP tests only.

KMSigma

patriot 5 months ago

Nice combination report. I would need this in daily, weekly, and for calendar month as well. Also, would need to be able to filter to only include nodes with a true value for a custom property. Can you help with these additional requirements?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
KMSigma 7 months ago in reply to Jovetic1981

BTW - if they are scheduled Unmanaged then polling stops 100% and the platform has no idea if they are or are not "up."

However, if they are "muted" then the polling still happens and should get flagged as being offline. The way I understand it when an element is "Muted," the polling still occurs and the alerts still trigger, but the "trigger actions" in the alerts (like sending an email or writing a log) do not take place.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Jovetic1981 7 months ago in reply to KMSigma

These servers have been offline a few times. I reboot them to patch, they have unscheduled main happen. They are agent based devices. Stumped. but thanks for getting back to me.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
KMSigma 7 months ago in reply to Jovetic1981

Point of clarity:

"It's not pulling data for any servers that are online" - You mean ones that are online but have never been offline - because it should. The Orion.NetObjectDowntime entity only records downtime - so anything that's always been up won't have data in that entity - hence no records in the final report.

If you instead want an "uptime" report - or a 5-9's or something like that, then that'll rely on a slightly different query. I build this one specifically for Nodes that have been down at some point.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Jovetic1981 7 months ago in reply to KMSigma

Yeah, If i remove the line below it pulls back my servers that are currently deallocated, but is not pulling data for any servers that are online.

AND [SI].StatusName = 'Down' -- Where the status is 'Down' (not 'Critical', 'Warning', etc.)
- Cancel
- Up 0 Down
- Reply
- More
- Cancel