|
| | |
Forum Newbie
Group: Forum Members
Last Login: 4/17/2008 9:44:44 AM
Posts: 8, Visits: 15 |
| | all of our devices that we configure have SNMP working on them. |
|
|
| | |
Forum Newbie
Group: Forum Members
Last Login: 8/15/2007 7:46:44 AM
Posts: 5, Visits: 7 |
| Interestingly - this works for me on 1 device (Cisco router), but fails on every other (Cisco switches) with this:
Error: Source:'Microsoft OLE DB Provider for ODBC Drivers'
Line:31 Char:2
Error:0 '[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.'
-v
(null)
Line 31 of the script reads:
var sSql3 = "SELECT nIfInOctets_AVG AS nInOctetsMax, nIfOutOctets_AVG AS nOutOctetsMax, nIfSpeedIn AS nIfSpeedInBps, nIfSpeedOut AS nIfSpeedOutBps FROM StatisticalInterfaceCache WHERE nStatisticalInterfaceIdentificationID = " + nStatisticalInterfaceIdentificationID;
I have SNMP Interface Performance Monitors on every device. Anyone else seen this issue and managed to resolve it? I'll try and determine the differences between the working device and failing devices in the meantime.
|
|
|
| | |
Forum Member
Group: Forum Members
Last Login: 5/14/2008 6:59:48 AM
Posts: 32, Visits: 53 |
| | Ah.....just had a thought. Its not to do with the interface speeds is it? If you havn't set interface speeds it won't know when to trigger the alarm, so it has to query them in the SQL. Can you check this please. |
|
|
| | |
Forum Newbie
Group: Forum Members
Last Login: 8/15/2007 7:46:44 AM
Posts: 5, Visits: 7 |
| Bingo! That's fixed it. Thanks for that. This is an important feature that we've struggled to implement in WUG v11.
Now it's just a case of manually setting all of our devices with interface speeds  |
|
|
| | |
Forum Member
Group: Forum Members
Last Login: 5/14/2008 6:59:48 AM
Posts: 32, Visits: 53 |
| | Ah good. I knew my code worked. Glad its helping you out. |
|
|
| | |
Forum Newbie
Group: Forum Members
Last Login: 12/21/2007 2:10:04 PM
Posts: 1, Visits: 5 |
| | I have used this script but I my WUP just monitor the first interface of the device... I have 6 interaces in the router, but just one of the fastethernet are show in the results. The script can't see other interfaces like serials on the router. Any ideas?
Luiz Ricarte |
|
|
| | |
Forum Member
Group: Forum Members
Last Login: 5/14/2008 6:59:48 AM
Posts: 32, Visits: 53 |
| | Hi, Yes I'm afraid the script will only alert on 1 interface. To change this would require quite an extensive rewrite of the script. Personally I found it better to make an individual device for all the interfaces you wish to alert for high utilization. That way you can easily see on your map what Interface has got high utilisation rather than having than the same red dot going red for many interfaces and then having to check which one it is. Nick |
|
|
| | |
Junior Member
Group: Forum Members
Last Login: 7/21/2008 2:21:32 PM
Posts: 10, Visits: 124 |
| | I started using the same script on a bunch of my router interfaces. It seems to work on some, but not on others. I've specified the appropriate speed for the interface...usually either 15440000 or 512000. Does anyone have any thoughts as to why it wouldn't work on some interfaces? Below is script error that I get when testing it on a router that doesn't seem to work: --------------------------------------------------------------------------------- Error: Source:'Microsoft OLE DB Provider for ODBC Drivers'
Line:26 Char:2
Error:0 '[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.'
-v
(null)
--------------------------------------------------------------------------------- I appreciate any help you all can provide. |
|
|
| | |
Forum Newbie
Group: Forum Members
Last Login: 6/3/2008 3:57:43 PM
Posts: 2, Visits: 8 |
| Has anyone tried this on v12? I'm seeing that some of the variable names have changed.
Also, I'm assuming that this is a AJScript, right?
Ed Ebel |
|
|
| |