Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Need accurate reporting of availability.

Management is looking for an availability report that does not include the time that the node was one a dial backup link. Orion is currently setup so that the nodes are watch for when they look for a new route to a specific device, and when this occurs it writes to the log and sends out an email.

Is there currently a report, or one that can be created with SQL, that would give me the availability of each node without it being on dial backup? Can someone point me in a direction to explore?

Thanks

Find more posts tagged with

Availability

Reports

sql

report_writer

Accepted answers

Lnavin

The query below calculates downtime in minutes based on the Event table. You can update the where statements to look at the particular events that you need. This will give you results in minutes. You can calculate this into a percentage once you have the data. I did percentages first but was then asked for actual minutes of downtime.

Once you start getting data, you can message it to get what you need. Remeber that this reports uptime of a node so you are going to have to change the event type to the UnDP in the fields.

SELECT
StartTime.EventTime,
Nodes.Caption,
StartTime.Message,
DATEDIFF(Mi, StartTime.EventTime,       (SELECT TOP 1           EventTime           FROM Events AS Endtime           WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5               AND EndTime.NetObjectType = 'N'               AND EndTime.NetworkNode = StartTime.NetworkNode           ORDER BY EndTime.EventTime))
FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID   WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N')   ORDER BY Nodes.Caption

All comments

Lnavin

Would an interface availability report work? Do the interfaces go down when in dial backup mode?

Geoo

Unfortunately they dont. I was just looking at that. When a router is up on dial backup, all the interface show up/up. I wonder if there is a way to filter out times when the router shows up but the UnDP poller is active on that device. The UnDP poller is what we use to tell if they have chosen a new default route.

Lnavin

If you have APM, you could run a query on the orion db which checks the status of the UnDP and the Device. Anytime the query is up, you could mark the device in Dial backup. You should be able to do the same with Excel but I'm not sure if you can report accurately on the history.

Does your UnDP poller cause an event in the Orion Event log?

kweise

When the router is not on backup, does the dial interface show down? If so, you might be able to create a report and filter out times when the dial interface shows up.

Geoo

We do have APM. I am not so familiar with it but I will definately look into this. The UnDP does cause an event, I believe. If not, I can make it so.

Whether on the primary circuit or the backup circuit, all the interfaces show up. Not completely sure I understand why this is so with the backup interface, its a standard async phone line, but the reason the primary stays up is because it is looking at, in many cases, a DSL router and in other cases an MPLS end point. As far as the interface is concerned everything is normal.

Thanks for all the suggestions.. keep them coming.