Monitor bandwidth utilization in WUG

Another good Jscript for Whats Up Gold. Customize the nMaxUtilizationPercentage based on your situation.

For instance, the ISP provides my client 10Mbps WAN connection, and my client firewall’s outside interface is 100Mbps. So if I want a alarm to be trigger when the bandwidth utilization higher than 90% (9Mbps), I need to change the nMaxUtilizationPercentage to 9.

Very useful script!!

*********************************************************************

// 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

{

 

// Get the device ID

  var nDeviceID = Context.GetProperty(“DeviceID”);

 

// Definition  of Maximum allowable Interface utilization percentage

//   Change this value to what you want to alarm at.

  var nMaxUtilizationPercentage = 9;

 

 

// Retrieve the nPivotStatisticalMonitorTypeToDeviceID for Interface (Monitor Type=1), Refer to dboStatisticalMonitorType for ComponentType

  var sSql = “SELECT nPivotStatisticalMonitorTypeToDeviceID from PivotStatisticalMonitorTypeToDevice WHERE  nStatisticalMonitorTypeID=1 and nDeviceID = ” + nDeviceID;

  var oRs = oDb.Execute(sSql);

  var nPivotStatisticalMonitorTypeToDeviceID = oRs(“nPivotStatisticalMonitorTypeToDeviceID”);

 

// Retrieve the data for the device

  var sSql2 = “SELECT nStatisticalInterfaceIdentificationID AS StatisticalInterfaceIdentificationID, nIfIndex AS  OIDinstance, sIfDescr AS IfName FROM StatisticalInterfaceIdentification WHERE nPivotStatisticalMonitorTypeToDeviceID = “+nPivotStatisticalMonitorTypeToDeviceID;

  oRs2 = oDb.Execute(sSql2);

  oRs2.moveFirst();

 

  var nExceed = 0;

  var oDisplay=”High Interface Usage at\n\n “;

 

  while ( !oRs2.EOF )

  {

 

    var IfMonID = oRs2(“StatisticalInterfaceIdentificationID”);

    var IfName = oRs2(“IfName”);

 

    var sSql3 = “SELECT nIfInOctets_Avg AS nInOctetsAvg, nIfOutOctets_Avg AS nOutOctetsAvg, nIfSpeedIn AS nIfSpeedInBps, nIfSpeedOut AS nIfSpeedOutBps FROM StatisticalInterfaceCache WHERE nStatisticalInterfaceIdentificationID = ” +IfMonID;

    var oRs3 = oDb.Execute(sSql3);

    if (!oRs3.EOF ) {

 

       var nIfSpeedIn = oRs3(“nIfSpeedInBps”);

       var nIfSpeedOut = oRs3(“nIfSpeedOutBps”);

       var nIfIn_Avg = oRs3(“nInOctetsAvg”);

       var nIfOut_Avg = oRs3(“nOutOctetsAvg”);

 

       if ( nIfSpeedIn > 0 )

       {

         var nInPercentage = Math.round((nIfIn_Avg / nIfSpeedIn * 800),2);

         var nOutPercentage = Math.round((nIfOut_Avg / nIfSpeedOut * 800),2);

       }

       else

       {

         var nInPercentage = 0;

         var nOutPercentage = 0;

       }

 

       if ( nInPercentage > nMaxUtilizationPercentage || nOutPercentage > nMaxUtilizationPercentage)

       {

               nExceed += 1; 

               oDisplay += “InterfaceName=” + IfName + ” is running at “+ nInPercentage + “% (In) /  ” + nOutPercentage + “%(Out). \n\n”;

 

       }

  

    }

 

    oRs2.moveNext();

  }

  oDb.Close(); //Close database connection

  if ( nExceed > 0)

  {

    Context.SetResult( 1, oDisplay);

  }

  else

  {

    Context.SetResult(0, ”     Ok”);

  }

*********************************************************************