// Set the result code of the check (0=Success, 1=Error)
Context.SetResult( 0, "No error");
var err;
err = "No Error";

// WUP Database connect
var oDb = Context.GetDB;

if (null == oDb) {
result = false;
err += "WUP DB inaccessible! ";
} else {

// Get DeviceID
var deviceID = Context.GetProperty("DeviceID");

// Check if the Attribute STATUS is Allready provided
var sSql1 = "SELECT sValue FROM DeviceAttribute WHERE nDeviceID = " + deviceID + " AND sName LIKE 'STATUS'";
var statusrs = oDb.Execute(sSql1);
if(!statusrs.EOF) {
// Attribute is available
} else {
// Create Attribute
var sSql2 = "INSERT INTO DeviceAttribute (nDeviceID,sName,sValue) VALUES('"+deviceID+"','STATUS','"+err+"')";
oDb.Execute(sSql2);
}

var sSql3 = "UPDATE DeviceAttribute SET sValue = '"+err+"' WHERE nDeviceID = " + deviceID + " AND sName LIKE 'STATUS'";
oDb.Execute(sSql3);
oDb.Close();
statusrs.Close();

// 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 {
// Variable to hold error message
var oDisplay = "Failure: ";

// Variable to determinate if we encountered an alarm
var bAlarm = false;

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

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

// Retrieve the data for the device
var sSql = "SELECT p.nDeviceID, e.sDescription, d.nUsed_Max, d.nSize FROM PivotStatisticalMonitorTypeToDevice p INNER JOIN StatisticalDiskIdentification e ON p.nPivotStatisticalMonitorTypeToDeviceID = e.nPivotStatisticalMonitorTypeToDeviceID INNER JOIN StatisticalDiskCache d ON e.nStatisticalDiskIdentificationID = d.nStatisticalDiskIdentificationID WHERE p.nDeviceID = " + nDeviceID + " AND (d.dPollTime+3) > getdate()";
oRs2 = oDb.Execute(sSql);

if(!oRs2.EOF) {
oRs2.moveFirst();
while ( !oRs2.EOF ) {
var sDescription = oRs2("sDescription");
var nUsed_Max = oRs2("nUsed_Max");
var nSize = oRs2("nSize");
if ( nSize > 0 ) {
var nDiskUsedPercentage = Math.round(nUsed_Max/nSize * 100);

if ( nDiskUsedPercentage >= nMaxUtilizationPercentage ) {
bAlarm = true;
oDisplay += "Disk " + sDescription;
oDisplay += " is ";
oDisplay += nDiskUsedPercentage;
oDisplay += " % full | ";

}
}
oRs2.moveNext();
}

}
else {
bAlarm = true;
oDisplay = "The Diskdata is to old!";
}

//// Here is the end of the checks now put the message into the attribute
//// You have to check if vars like "nDeviceID" or errorholders (here oDisplay) have other names

// Check if the Attribute DSTATUS is Allready provided
var sSqlattr = "SELECT sValue FROM DeviceAttribute WHERE nDeviceID = " + nDeviceID + " AND sName LIKE 'DSTATUS'";
var rsattr = oDb.Execute(sSqlattr);

if (bAlarm == false) {
oDisplay="Drives OK";
}

if(!rsattr.EOF) {
// Attribute is available
} else {
// Create Attribute
var sSqlattr2 = "INSERT INTO DeviceAttribute (nDeviceID,sName,sValue) VALUES('"+nDeviceID+"','DSTATUS','"+oDisplay+"')";
oDb.Execute(sSqlattr2);
}

var sSqlattr3 = "UPDATE DeviceAttribute SET sValue = '"+oDisplay+"' WHERE nDeviceID = " + nDeviceID + " AND sName LIKE 'DSTATUS'";
oDb.Execute(sSqlattr3);
rsattr.Close();

//// End of attribute setup now set Context result

if (bAlarm) {
Context.SetResult( 1, oDisplay);
} else {
Context.SetResult(0, "Drives Ok");
}
}

oDb.Close();

Additional information (from script monitor):
%Device.Attribute.USTATUS
%Device.Attribute.DSTATUS