Lnavin replied on Mon, Jun 8 2009 9:54 AM

rated by 0 users

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

Geoo replied on Mon, Jun 8 2009 10:02 AM

rated by 0 users

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 replied on Mon, Jun 8 2009 11:38 AM

rated by 0 users

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 replied on Mon, Jun 8 2009 11:56 AM

rated by 0 users

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 replied on Mon, Jun 8 2009 12:14 PM

rated by 0 users

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.  =)

Geoo replied on Tue, Jun 9 2009 8:15 AM

rated by 0 users

Thanks Lnavin, I think that might work very well.  However I need to pull out my newbie card and admit that I dont know where to use that statement.  I tried to open report writer and type it into the SQL box but it does not seem to allow that.

I opened APM (since we spoke of it earlier) but I could not find mention of reporting. 

Could you point me to the particular utility I should be looking for?  You help has been most appreciated.

Jim

kweise replied on Tue, Jun 9 2009 8:21 AM

rated by 0 users

Geoo,

In report writer, create a new report.  When the New Report window opens, scroll down.  You should see a report type called "Advanced SQL."  Select that report type.  When the design window opens, click the SQL tab.  You can enter the SQL statements into that tab.

Hope this helps!

Geoo replied on Tue, Jun 9 2009 8:28 AM

rated by 0 users

Excellent!  It did help.  Thank you

Geoo replied on Wed, Jul 1 2009 9:31 AM

rated by 0 users

After messing with this script for a bit, I have come to realize that it isnt going to get the data that I am looking for.  The problem is that our particular server is too unstable and so it doesnt always send and alert or log a problem.  The data that came out was inconsistant.

I was wondering if one of you SQL gurus could help me take a different approach.  Would it be possible to write a report that showed the amount of time in the last 30 days, where there was bandwidth being used on a particular interface?

If I could do that then my report could include data from the primary interfaces of each router and the async interface on each router.  That should give me the amount of time in minutes that it was on primary and time it was on backup.

Taking it a step futher it would be nice if I could identify which interface on each router was the primary so that the report could base itself on that.  The reason is because the primary interface changes depending on the provider and type of circuit that we are using at that location.

Geoo replied on Wed, Jul 1 2009 1:08 PM

rated by 0 users

Hey NG

Thanks for the response.  Actually the problem is that it does ping regardless of interface type.  For example.  I am monitoring a node for up/down and most of the month it is up.  I want a report to show me how often it is down, but the problem is that when the node goes to dial backup, Orion still sees the node as up.  So a node might show a 99.9% uptime but in reality it is off of the primary circuit 40% of that time.  How do I show my boss what is a better circuit between the various types we have?

Also, monitoring a device behind the router doesnt help for the same reason.

Thanks for the suggestions though.  If I misunderstood or if you come up with something else, I am all ears (eyes).  This problem is driving me crazy and I dont know SQL well enough to get what we need.  Unfortunately.

Network_Guru replied on Wed, Jul 1 2009 9:47 PM

rated by 0 users

I understand now, you want availability of the primary circuit, not the node.
I also created a weekly report several years ago which lists the minutes of dial-up time per site.

I'll have to check the code, but I believe it uses the syslogs from the head-end RAS router to log dial-up events into the Orion DB.
It then uses code similar to what was posted earlier, to calculate the minutes of dial-up per week.

Geoo replied on Thu, Jul 2 2009 10:50 AM

rated by 0 users

Exactly!  I would be very interested in your weekly report too.  I dont have a problem point our RAS to the Orion syslog server to get the results and i would assume i would have to change some of the parameters in your report.

At the end of the day, if I could identify (previous 30 days if possible) that a node was on dial backup then I could, even manually, subtract that from the total uptime and give the people that pay for this what they are looking for. 

Thanks for sticking it out with me on this one.