Lnavin

You can update the query with an additional where clause to limit it to the Dial-up events by matching on the exact message generated by the event. You will also nee d to add the where statment to the nested Select. Sample Where clause Where events.message LIKE 'Enter message here'

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…

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…

This maybe out in left field, but you could create a custom SQL monitor which polls the Orion DB for the status of each of your DC's. Count the total nodes and return that to APM. Your actual downtime only occurs when the count equals 0. The SQL could look something like this. Select Count(node id) where node.status = Up…

You should be able to use the query below to get downtime in Minutes. I have adapted this based on a report I found here. You may need to adjust the NetObjectType. SELECT StartTime.EventTime,Nodes.Caption,StartTime.Message,DATEDIFF(Mi, StartTime.EventTime, (SELECT TOP 1 EventTime FROM Events AS Endtime WHERE…

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

You could run a SQL update to replace the old ID with the new ID. It's not pretty, but it should work. Try it in test first though.