Hi all,
I need to setup a report of a device outage (VPN tunnel) for the last 3 months and the time of outage for each episode. How and what should I use for this? I don't even know where to start.
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?
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?
I haven't found a way for Report Writer to calculate and display the actual amount of down time--only the start of the Nod Down event, and when the matching Up event occurred.
You're right, the information you want should be present as a canned report with the output the way you want it.
If the format above is at all helpful, at least for a start until someone provides the SQL query you need, you can build the above in Report Writer using these steps:
The output shows every node's down time and the time it came back up--if it DID come back up, sorted by node and date:
¿What version of NPM do you have? in 11.5.2, in the web based reports you have that option.
I like what that sounds like. But when I test it, the way I've built it is calculating the amount of time between the first even and the last event. That's not right--the device was up and down a few times in between--and mostly up. The Total Duration In Minutes between the first outage and the last recovery is not the right number to display:
Instead I think it should show the duration between each event, not between the first and last events. This is getting close! Now to figure out how to get that last defining item in place . . . Suggestions?
In my case is working properly
how exactly are you doing this table? I've been trying to reproduce but im lost....
im running 11.5.2 and do not have that web based report you have. Not sure why
Its not a report per se, its a component you can add to a custom table.
and how is that done? I need to understand how to reproduce mdecima's web object as i think that would work. At least it seems to be showing the correct information... But dont know how to create this object.
npereira1 I believe they are referring to the "Custom Table" resource, which you can run queries in, similar to how the web reports work. Currently, though, as far as I am aware of, you cannot directly place web reports in resources. So, this is the next best way, as it is almost the same thing in various parts of the resource.
Hope this helps.
Thank you,
-Will
ok but how does this need to be setup in order to get the preview shown?
Is there a reason i can only paste in wsql and cannot select sql?
