Ipswitch Forums / Ipswitch Products / WhatsUp Gold / Making a interface utilization alarm / Latest Posts

RE: Making a interface utilization alarm

eebel49 — Fri, 16 May 2008 13:55:26 GMT

I'm getting the same error under the same inconsistent circumstances. I have been through the setups of all the routers and the single interface on each one that I need to monitor. All the speeds are set. The Perf Mons are collecting data and it can be seen in the interface util report. All have the same creds. ????????????

RE: Making a interface utilization alarm

Balrokk — Fri, 16 May 2008 07:45:21 GMT

Hi,

i tried to used that script as an Active Monitor, but if i press the "Test" Button i get always an Error : "Error: The script timed out because it exceeded 10 seconds."

The Devices i am using for testing are our Routers with Perfomance Monitor "interface Utilisation" activated. The Devices are Running and iam using the right SNMP credentials

Using WU 11.0.3

Any Ideas?

RE: Making a interface utilization alarm

eebel49 — Thu, 15 May 2008 14:17:49 GMT

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?

RE: Making a interface utilization alarm

clayman88 — Tue, 26 Feb 2008 11:08:47 GMT

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.

RE: Making a interface utilization alarm

NickF — Wed, 02 Jan 2008 06:01:11 GMT

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

RE: Making a interface utilization alarm

LuizRicarte — Fri, 21 Dec 2007 09:14:02 GMT

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?

RE: Making a interface utilization alarm

NickF — Wed, 11 Jul 2007 02:51:09 GMT

Ah good. I knew my code worked. Glad its helping you out.

RE: Making a interface utilization alarm

jbrummell — Tue, 10 Jul 2007 11:00:31 GMT

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 :(

RE: Making a interface utilization alarm

NickF — Tue, 10 Jul 2007 08:19:15 GMT

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.

RE: Making a interface utilization alarm

jbrummell — Tue, 10 Jul 2007 08:04:56 GMT

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.

RE: Making a interface utilization alarm

Darekn — Thu, 05 Jul 2007 17:35:29 GMT

all of our devices that we configure have SNMP working on them.

RE: Making a interface utilization alarm

NickF — Thu, 28 Jun 2007 02:43:58 GMT

And does this device have a working SNMP interface performance monitor?

RE: Making a interface utilization alarm

Darekn — Wed, 27 Jun 2007 13:38:28 GMT

i have attached it to an exsisting device, device status shows down for the monitor, never seems to come up.

RE: Making a interface utilization alarm

NickF — Mon, 25 Jun 2007 02:31:23 GMT

Right,

I have tried the test button as well. If I select the device that has a performance monitor attached to it, everything works fine. However if I just select a random device with no performance monitor I get the same error as you.

Can you make sure there is a performance monitor (SNMP interface traffic) on the device you are testing? This script only checks the values written to the DB by the performance monitor.

RE: Making a interface utilization alarm

Darekn — Fri, 22 Jun 2007 14:30:53 GMT

i do.

i'm not actually attaching the active monitor to a device yet.

This is how i get that error.

I create a new active script monitor in the active script monitor library, copy the script, select the script i just created and click the test button. it comes back with that error.

RE: Making a interface utilization alarm

NickF — Fri, 22 Jun 2007 12:54:50 GMT

I honestly don't have a clue why this is not working for you.

Can I just check that you do have a network interface performance monitor also on the device?

RE: Making a interface utilization alarm

Darekn — Fri, 22 Jun 2007 11:05:22 GMT

i'm getting this error message when i test it.

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)

RE: Making a interface utilization alarm

Darekn — Thu, 14 Jun 2007 11:47:13 GMT

thanx. i'll try that.

RE: Making a interface utilization alarm

NickF — Thu, 14 Jun 2007 03:00:22 GMT

No promises that this will work straight away for you, but here is the modified script which works fine for us

[code]
// Get the Open DB connection from the Context NameSpace
var oDb = Context.GetDB;
if (null == oDb)
{
Context.SetResult( 1, " Problem creating the DB object");
}
else
{

var oRs = new ActiveXObject("ADODB.Recordset");

// Get the device ID
var nDeviceID=0;
nDeviceID = Context.GetProperty("DeviceID");

// Definition of Maximum allowable interface utilization percentage
// Change this value to what you want to alarm at. We use 80%.
var nMaxUtilizationPercentage = 80;

// Retrieve the nPivotStatisticalMonitorTypeToDeviceID
var sSql = "SELECT nPivotStatisticalMonitorTypeToDeviceID from PivotStatisticalMonitorTypeToDevice WHERE bEnabled=1 AND nStatisticalMonitorTypeID = 1 AND nDeviceID = " + nDeviceID;
var oRs = oDb.Execute(sSql);
var nPivotStatisticalMonitorTypeToDeviceID = oRs("nPivotStatisticalMonitorTypeToDeviceID");

// Retrieve the nStatisticalInterfaceIdentificationID
var sSql = "SELECT nStatisticalInterfaceIdentificationID from StatisticalInterfaceIdentification WHERE nIfInSpeedCustom > 0 AND nPivotStatisticalMonitorTypeToDeviceID = " + nPivotStatisticalMonitorTypeToDeviceID;
var oRs = oDb.Execute(sSql);
var nStatisticalInterfaceIdentificationID = oRs("nStatisticalInterfaceIdentificationID");

// Retrieve the data for the device
var sSql3 = "SELECT nIfInOctets_AVG AS nInOctetsMax, nIfOutOctets_AVG AS nOutOctetsMax, nIfSpeedIn AS nIfSpeedInBps, nIfSpeedOut AS nIfSpeedOutBps FROM StatisticalInterfaceCache WHERE nStatisticalInterfaceIdentificationID = " + nStatisticalInterfaceIdentificationID;
oRs = oDb.Execute(sSql3);
oRs.moveFirst();

var nInPercentage = 0;
var nOutPercentage = 0;

while ( !oRs.EOF )
{
var nIfSpeedIn = oRs("nIfSpeedInBps");
var nIfSpeedOut = oRs("nIfSpeedOutBps");
var nIfIn_Avg = oRs("nInOctetsMax");
var nIfOut_Avg = oRs("nOutOctetsMax");
if ( nIfSpeedIn > 0 )
{
var nInPercentage = Math.round((nIfIn_Avg/(nIfSpeedIn / 10))*100);
var nOutPercentage = Math.round((nIfOut_Avg/(nIfSpeedOut / 10))*100);
}
else
{
nInPercentage = 0;
nOutPercentage = 0;
}
oRs.moveNext();

if ( nInPercentage > nMaxUtilizationPercentage || nOutPercentage > nMaxUtilizationPercentage)
{
var oDisplay;
oDisplay = nDeviceID+" Failure: Interface ";
oDisplay += " is running at ";
oDisplay += nInPercentage;
oDisplay += "%/" + nOutPercentage;
oDisplay += "% utilization inbound/outbound (threshold is ";
oDisplay += nMaxUtilizationPercentage + "%).";
Context.SetResult( 1, oDisplay);
}
else
{
Context.SetResult(0, nDeviceID+" Ok - Utilization Speed Normal" + nOutPercentage +"% / " + nInPercentage+"%");
}
}
oRs.Close();
}
[/code]

RE: Making a interface utilization alarm

Darekn — Mon, 11 Jun 2007 14:31:27 GMT

how do i implement this script??

Making a interface utilization alarm

Darekn — Mon, 11 Jun 2007 14:02:16 GMT

so after a few hours of reading documentation, i'm still confused as ever on how to create an active script.

This is what i need to accomplish.

i want a monitor in place to alert me via e-mail when my multilink starts spiking over 50%.

i found the script for it but i'm having a hard time trying to implement it.

here is the script that i have, it keeps giving me error messages.

any help would be greatly appreciated.

var oDb = Context.GetDB;
if (null == oDb)
{
Context.SetResult( 1, " Problem creating the DB object");
}
else
{

var nDeviceID = Context.GetProperty("DeviceID");

var nMaxUtilizationPercentage = 50;

var sSql = "SELECT nPivotStatisticalMonitorTypeToDeviceID from PivotStatisticalMonitorTypeToDevice WHERE nDeviceID = " + nDeviceID;
var oRs = oDb.Execute(sSql);
var nPivotStatisticalMonitorTypeToDeviceID = oRs("nPivotStatisticalMonitorTypeToDeviceID");

var sSql3 = "SELECT nIfInOctets_Max AS nInOctetsMax, nIfOutOctets_Max AS nOutOctetsMax, nIfSpeed AS nIfSpeedBps, sIfDescr FROM StatisticalInterface WHERE nPivotStatisticalMonitorTypeToDeviceID = " + nPivotStatisticalMonitorTypeToDeviceID;
oRs2 = oDb.Execute(sSql3);
oRs2.moveFirst();

while ( !oRs2.EOF )
{
var nIfSpeed = oRs2("nIfSpeedBps");
var nIfIn_Avg = oRs2("nInOctetsMax");
var nIfOut_Avg = oRs2("nOutOctetsMax");
var nIfDescr = oRs2("sIfDescr");
if ( nIfSpeed > 0 )
{
var nInPercentage = Math.round((nIfIn_Avg / nIfSpeed * 100));
var nOutPercentage = Math.round((nIfOut_Avg / nIfSpeed * 100));
}
else
{
var nInPercentage = 0;
var nOutPercentage = 0;
}
oRs2.moveNext();

if ( nInPercentage > nMaxUtilizationPercentage || nOutPercentage > nMaxUtilizationPercentage)
{
var oDisplay;
oDisplay = " Failure: Interface " + nIfDescr;
oDisplay += " is running at ";
oDisplay += nInPercentage;
oDisplay += "%/" + nOutPercentage;
oDisplay += "% utilization inbound/outbound (threshold is ";
oDisplay += nMaxUtilizationPercentage + "%).";
Context.SetResult( 1, oDisplay);
}
else
{
Context.SetResult(0, " Ok");
}
}
}