Need help getting reports on outages

1. Monitor the device in Orion (and back it up with NCM, if you have NCM)
2. Set up Alerting for it so you get e-mails or pages
3. Create a Report for its uptime
4. If you've already got this information, simply click on the node in NCM and you can graph its uptime/downtime.
5. From the graphed up/down time, you can drill in on the specific outage times.
6. Similarly in Alerts, you can search for all Events associated with that node--up, down, etc.

We need more info. What vpn server/box and clients are you using?

It's not related to VPN, I was just stating that the device is monitored via a VPN tunnel.

SO I need to know the different times this specific node goes down and for how long for each episode.

I would then do as rschroeder suggested above. Hopefully you have the node already monitored and can start at step 4 of his instructions.

yes it's been monitored and in NCM for over a year.

Step 3 is where im having issues, I dont know how to setup this report for uptime. I searched in the web report tool and there is no reports for uptime. So how is that done exactly?

yes, but I need to report on the individual times the node was not available and for how many minutes/seconds for each event. Seems like this can be built using the report writer although I know nothing of SQL and all the reports I found and tried, give me errors of invalid column names.

but i need the duration for each outage?

but this is too cumbersome, there should be a way to do this as a report and have the table setup as:

Node 24

time/date     even name     duration of outage

OK let me see what we are trying to do. You have a device, a vpn tunnel? or monitored through a vpn tunnel, what is the device you are getting the report on. If you don't have the monitoring set up already in ncm with the right parameters that may not have the info you require, but the device itself may. What is the device? As much detail as possible (make model etc) and I will look at this from a different perspective and maybe get an idea from that.

If the device keeps logs it may be able to tell you when it was working and not, or other things like the logs on a switch (if it's connected to a managed switch) may have logs that tell you it disconnected at time and reconnected at time and you can build the report from those.

It may be some work for you though and you are starting to sound frustrated, maybe some air and breathing to clear your mind and something may become clearer for you (some people drink tea or coffee to help.) I know someone is asking for a report and they are probably important and this is really important to get right. We know that and rschroeder has been a lot more help than I have but we are trying to help. K?

Have you seen some of the answers on this post: report node's downtime?