// Name: Update device name
// Description: Update device name based on SNMP sysName variable
// Language: JScript

var oSnmpRqst =  new ActiveXObject("CoreAsp.SnmpRqst") ; 

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

var oResult = oSnmpRqst.Initialize(nDeviceID) ;

if (oResult.Failed) {
  Context.SetResult(1, "Initialization error " ) ; 
} 
else {
	var oResult = oSnmpRqst.Get("1.3.6.1.2.1.1.5.0"); // sysName.0
	
	if (oResult.Failed) {
	Context.SetResult(1, "Couldn't get sysName.0 variable" ) ; 
	} 
	else {
  		var oDb = Context.GetDB ;
  		
  		if (oDb == null) {
  			Context.SetResult(1, "DB Connection error" ) ; 
  		} 
  		else {
  			var oRs = new ActiveXObject("ADODB.Recordset");
  			var sSql = "UPDATE Device SET sDisplayName='" + oResult.GetPayload + "' WHERE nDeviceID = " + nDeviceID;
  			oDb.Execute (sSql) ;
  		}	
  	}
}