wugSpace: The WhatsUp Gold Community

Script Library

This is a public Media Gallery public RSS

Action

Update Device Description

Action posted 06/26/09 by Stanley Johnson, last edited 07/10/09 by Will Sansbury

1845 Views

Name:

Update Device Description

Description:

Updates a device's description with the SNMP description, contact and location information that resides on the device.

We use a syslog passive monitor to trigger this whenever we receive a message that says "configured from console".

Language:

JScript

Code:

// Name: Update device description
// Description: Update device description based on SNMP sysName variable
// Language: JScript
// SNMP MIB-2 Usefull System OIDS
//1.3.6.1.2.1.1.1 - sysDescr 
//1.3.6.1.2.1.1.2 - sysObjectID 
//1.3.6.1.2.1.1.3 - sysUpTime 
//1.3.6.1.2.1.1.4 - sysContact 
//1.3.6.1.2.1.1.5 - sysName 
//1.3.6.1.2.1.1.6 - sysLocation 

var oSnmpRqst =  new ActiveXObject("CoreAsp.SnmpRqst") ; 
var nDeviceID = Context.GetProperty("DeviceID") ;
var oResult = oSnmpRqst.Initialize(nDeviceID) ;
var sSuccess=0;

 Context.Logmessage("Starting Device Description Update");



if (oResult.Failed) {
  Context.SetResult(1, "Initialization error " ) ; 
} 
else {

//-------Do the Description Attribute SNMP Get and DB updates.
  var sysDesc = GetSNMPAttrib(nDeviceID,"1.3.6.1.2.1.1.1.0","Description");
  Context.LogMessage("Getting Description");
  if (sysDesc != 1) {
     Context.LogMessage("Description = " + sysDesc);
     if (SetDBAttrib(nDeviceID,"Description",sysDesc)==1) sSuccess=1;
  }
  else {
    sSuccess=1;
  }

//-------Do the Contact Attribute SNMP Get and DB updates.
  var sysContact = GetSNMPAttrib(nDeviceID,"1.3.6.1.2.1.1.4.0","Contact");
  if (sysContact != 1) {
     if (SetDBAttrib(nDeviceID,"Contact",sysContact)==1) sSuccess=1;
  }
  else {
    sSuccess=1;
  }


//-------Do the Location Attribute SNMP Get and DB updates.
  var sysLocation = GetSNMPAttrib(nDeviceID,"1.3.6.1.2.1.1.6.0","Location");
  if (sysLocation != 1) {
     if (SetDBAttrib(nDeviceID,"Location",sysLocation)==1) sSuccess=1;
  }
  else {
    sSuccess=1;
  }

  
  if (sSuccess != 0){
    Context.SetResult(1,"Update Failed");
  }
  else {
    Context.SetResult(0,"Update Successful");
  }
}

//--------This function Gets the payload for an SNMP OID from a given Device
function GetSNMPAttrib(nDeviceID,sOID) {
  var oResult = oSnmpRqst.Get(sOID); 
  if (oResult.Failed) {
    return 1; 
  }
  else {
    return oResult.GetPayload;
  }
}


//--------This Function updates the DeviceAttribute table for a given device/attribute combination.
function SetDBAttrib(nDeviceID,sAttrib,sPayload) {
    var oDb = Context.GetDB ;
    if (oDb == null) {
     return 1;
    } 
    else {
     var oRs = new ActiveXObject("ADODB.Recordset");
     var sSql = "UPDATE DeviceAttribute SET sValue='" + sPayload + "' WHERE sName='" +sAttrib + "' AND nDeviceID = " + nDeviceID;
     oDb.Execute (sSql) ;
    return 0;
    } 
}

Disclaimer:

All scripts found on wugSpace are provided as-is with no warranty or guarantee. These scripts are not supported by Ipswitch Technical Support. If you have a problem with this script, please post is in the comments.

Be the first to rate this
|
Sign in to rate this