r0berth1

What are the system spec of the PC running your Orion install? Do you have the SQL database on a separate server than the Orion install?

Are you running Orion and SQL on the same server? If so, you will want to move SQL to its own server.

you need to add the Custom Poller Rate and set it to a equal to or greater than a value that you want. I will work on getting some screenshots posted later today.

Nevermind, I figured it out. For those of you who want to do the same thing. Here is what I did. This is the original report that looks at a few custom node properites to pull % uptime. but i wanted a report that showed a list of every site that was under 98% uptime and show why it was down. Below is the code from the…

Can someone give me some help on this???????????????????

no, not really. I dont know why you would. There is nothing on those that are valuable as far as reports or statistics go.

I have one that i can post. I have it setup to pull the entire week, then modified it for the entire month only for the days of Monday - Sat. between the hours of 7 A.M. - 7 P.M. and it only looks at the ports that we have marked MPLS for METRO-E. Do you want me to post the SQL code here?

OK, when i run this report, it pulls all info that i need as far as outages go: _______________________________________________________________ SELECT TOP 10000 CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101) AS SummaryMonth, AVG(ResponseTime.Availability) AS AVERAGE_of_Availability,…

This is what i used on all of my 6509s and they appear to be collecting all data: ip flow-cache timeout active 1 ! mls aging fast time 8 threshold 127 mls aging normal 32 mls flow ip full no mls flow ipv6 mls nde sender version 7 ! interface Vlan??? description **???** ip address ???.???.???.??? ???.???.???.??? ip pim…

Do you have to report which day had the problem? otherwise just use a report that shows uptime for the month. I have a monthly report that your can use.

I had one today that was 180% receive and 12% transmit. but it was a 10mb Metro-E that runs on gig link to the bell. The interface from the bell and on my switch are 1gig interfaces and they have it throttled back to 10mb.

I haven't see that on any interface unless for instance i have a 10mb metro-e circuit running on a gig port, and have the port set to 10mb in orion, I will see spikes equivalent to 100mb.

My device is not showing up as unknown, but when I tried to view the interface details or netflow data on the serial0/0/0 interface of a cisco 2811 router, i get the following message: The Orion website is currently unable to display this page. Orion polling and alerting services often continue running, though this page…

I have some IBM x3400 servers and can monitor the RSA cars on them, Orion shows the IBM x3600 IMM cards as Unknown items. I will post more detail in the A.M.

this is a link to another post i answered. you can use the same instructions. except when you do the after hours report just do the following: Normal report filters will be: Date/Time 24Hr greater or equal to 07:00 and the second filter will be Date/Time 24Hr less or equal to 18:00. After hours report filter will be:…

I get it every time I open a page and when my main view refreshes

You should schedule your backups after hours to avoid this error.

you just are not monitoring the correct interfaces on that device. get into the settings of NetFlow from the webconsole and check the box to automatically add the netflow interfaces. Click on Admin, then on NTA settings, and change Automatic addition of NetFlow sources to enabled.

Mine doesn't even get that far. it times out. any help would be very appreciated.

Here is what i finally came up with. I had to create a custom node property called Nodes.Branch = Branch, and 2 custom interfaces properties Interfaces.MPLS = MPLS and Interfaces.METRO_E = METRO-E. SELECT StartTime.EventTime, dbo.Nodes.Branch, StartTime.Message, DATEDIFF(Mi, StartTime.EventTime, (SELECT TOP (1) EventTime…

There has to be a SQL guru out there that has eigher already done this and can point me to the correct location or help me with this.

If the other interfaces that have the errors are ethernet, you may want to check that both sides of that interface are set to the same speed/duplex, if they are not, you will transmit/receive discards and errors. If they are T1s or any other serial interface, make sure that the settings match the circuit, just keep in mind…

What router are you using? Cisco, Nortel...?

I have seen the problem before. You have to setup some extra lines with SNMP on the switch. They deal with SNMP groups and permissions. I am looking for the line now.

just for future reference, don't post a thread titled HELP!!! unless you need help.

the SUM_of_RecvXmitErrors: Common Causes: This includes runts, giants, no buffer, CRC, frame, overrun, and ignored counts. Other input-related errors can also cause the input errors count to be increased, and some datagrams can have more than one error. Therefore, this sum cannot balance with the sum of enumerated input…

I would create a separate drive and dedicate it just to pagefile and don't put any pagefiles on any other drive. But that is just my opinion.

I do have the shell of the report created, and it shows all devices and the last flow update, but i don't know SQL enough to make it pull current date and time.

To clarify. I am trying to create a report that shows which devices are not sending flows to orion. I would like for the report to show the Device Name and the last time a flow was received by that device, but i want to filter it by current date. As any device that does not have the last flow update = current date, display…

If you use universal device poller, you can enter the following MIBs to get what you are looking for: 1.3.6.1.4.1.11.2.3.9.4.2.1.4.1.10.1.1.11 = legal pages remaining 1.3.6.1.4.1.11.2.3.9.4.2.1.4.1.10.1.1.12 = leter pages remaining 1.3.6.1.4.1.11.2.3.9.4.2.1.4.1.10.1.1.13 = executive pages remaining…