Report to show node availability and outage times over past month

I don't know how to produce it in Report writer, but this is a SQL script I use, but it is given to another department in text only.

Thanks for the SQL script. In Report Writer you can create a new Advanced SQL report and just add the SQL there. Unfortunately I am a real noob when it comes to SQL so I'm struggling to understand what the statements do in that script. Did you write that script yourself?

OK...so I have managed to get a report that shows node up and down times as displayed below. The SQL so far is in the attached file.

Please could someone help with the SQL on how to calculate the total time the node has been unreachable for according to the up/down events? Thank you

OK...so I've managed to get the report to show each time a particular node goes up and down as displayed below. The SQL so far is attached.

Please could someone help with the SQL to calculate the total time the node has been unreachable for according to the up/down times? Thank you, Amy

Hi Amy,

I found these on the Content exchange - the top one sounds like its close enough to what you're looking for. The calculation from the second one might be useful too.

Outage duration last month: 

Down nodes with duration: 

HTH,

Caroline

Fantastic! These are exactly what I'm looking for, thank you so much! Greatly appreciated :-D

Hi,

Does anyone know how to filter the report posted on this thread base on device name and/or location?

The report is great, just need to have the ability to filter for example:

Device Hostname the contains "GW1" and

Device Lacation "Australia"

Thanks