<!-- #include virtual = "/inc/jscriptHdr.inc"-->
<!-- #include file = "../inc/connectdb.inc" -->
<!-- #include file = "../inc/groupSql.inc" -->
<!-- #include file = "../inc/checkFuncAccess.inc" -->
<!-- #include file = "../inc/getSQLstring.inc" -->
<!-- #include file = "../inc/helpLink.inc" -->
<!-- #include virtual = "/inc/adojavas.inc" -->
<!-- #include virtual = "/inc/xssSupport.inc" -->
<!-- #include virtual = "/inc/parameterizedQuerySupport.inc" -->
<%
// REVISIT # Prince  # Variable Declaration
var sql="";
var cmd=null;
// use current machine ID filter or default to abx*
// use the current group id filter or default to groupx
// Show machines currently online/offline
// Show machines that have/have not checked in since y/m/d h:s
// Checking in from connection gateway 1.2.3.4
// In IP address range 1.2.3.4 to 1.2.3.4

// machines with script "x" pending
// machines with script "x" failed/succeeded
// machines that have/have not run script "x" since y/m/d h:s

// computer name filter
// operating system type & OS version

var recSet = Server.CreateObject("ADODB.Recordset");
var tempSet = Server.CreateObject("ADODB.Recordset");
var needToSave = new String("false");
var radioSet = new String("");
var reloadCmd = new String("");

var newView = getQueryStr("newView");
var firstPass = new String(Request.form("firstPass"));
if (firstPass == "undefined") firstPass = "";
var activeViewId = new Number(Request.form("activeViewId"));
if (isNaN(activeViewId)) activeViewId = 0;
var takeId = new Number(Request.form("takeId"));
if (isNaN(takeId)) takeId = 0;
var lastViewId = new Number(Request.form("lastViewId"));
if (isNaN(lastViewId)) lastViewId = -1;
var buttonType = new Number(Request.form("buttonType"));
if (isNaN(buttonType)) buttonType = 0;
var editTitle = new String(Request.form("editTitle"));
editTitle = ArgumentCheck(editTitle, "string");
if (editTitle == "undefined") editTitle = "";
editTitle = editTitle.replace(/[\%\'\"\/\\\:\?\<\>\|]/g,"").substr(0,100);
var useMachFil = new String(Request.form("useMachFil"));
if (useMachFil == "undefined") useMachFil = "";
var overMachFil = new String(Request.form("overMachFil"));
overMachFil = ArgumentCheck(overMachFil);
if (overMachFil == "undefined") overMachFil = "*";
overMachFil = overMachFil.replace(/[\%,\'\"\/\\\:\?\<\>\| ]/g,"").substr(0,100);
if (overMachFil.length == 0) overMachFil = "*";
var useGroupFil = new String(Request.form("useGroupFil"));
if (useGroupFil == "undefined") useGroupFil = "";
var groupIdFil = new String(Request.form("groupIdFil"));
groupIdFil = ArgumentCheck(groupIdFil);
if (groupIdFil == "undefined") groupIdFil = "";
var useViewColFil = new String(Request.form("useViewColFil"));
if (useViewColFil == "undefined") useViewColFil = "";
var useColFil = new String(Request.form("useColFil"));
if (useColFil == "undefined") useColFil = "";
var colIdFil = new Number(Request.form("colIdFil"));
if (isNaN(colIdFil)) colIdFil = 0;
var showHideCollection = new Number(Request.form("showHideCollection"));
if (isNaN(showHideCollection)) showHideCollection = 0;
var showCheckin = new String(Request.form("showCheckin"));
if (showCheckin == "undefined") showCheckin = "";
var checkinStat = new Number(Request.form("checkinStat"));
if (isNaN(checkinStat)) checkinStat = 1;
var onLineMin = new Number(Request.form("onLineMin"));
if (isNaN(onLineMin)) onLineMin = 1;
if (onLineMin < 1) onLineMin = 1;
if (onLineMin > 9999) onLineMin = 9999;
var onLineMinUnit = new String(Request.form("onLineMinUnit"));
if (onLineMinUnit == "undefined") onLineMinUnit = "Day";
var showSuspended = new String(Request.form("showSuspended"));
if (showSuspended == "undefined") showSuspended = "";
var suspendedStat = new Number(Request.form("suspendedStat"));
if (isNaN(suspendedStat)) suspendedStat = 1;
var showReboot = new String(Request.form("showReboot"));
if (showReboot == "undefined") showReboot = "";
var rebootStat = new Number(Request.form("rebootStat"));
if (isNaN(rebootStat)) rebootStat = 1;
var rebootMin = new Number(Request.form("rebootMin"));
if (isNaN(rebootMin)) rebootMin = 1;
if (rebootMin < 1) rebootMin = 1;
if (rebootMin > 9999) rebootMin = 9999;
var rebootMinUnit = new String(Request.form("rebootMinUnit"));
if (rebootMinUnit == "undefined") rebootMinUnit = "Day";
var useAgentCredentialStatus = new String(Request.form("useAgentCredentialStatus"));
if (useAgentCredentialStatus == "undefined") useAgentCredentialStatus = "";
var agentCredentialStatus = new Number(Request.form("agentCredentialStatus"));
if (isNaN(agentCredentialStatus)) agentCredentialStatus = -1;
var useGateway = new String(Request.form("useGateway"));
if (useGateway == "undefined") useGateway = "";
var onlyGateway = new String(Request.form("onlyGateway"));
if (onlyGateway == "undefined") onlyGateway = "";
onlyGateway = onlyGateway.replace(/[^\d\.\*]/g,"").substr(0,20);
var useIpFil = new String(Request.form("useIpFil"));
if (useIpFil == "undefined") useIpFil = "";
var ipFil = new String(Request.form("ipFil"));
if (ipFil == "undefined") ipFil = "";
ipFil = ipFil.replace(/[^\d\.\*]/g,"").substr(0,20);
var useOs = new String(Request.form("useOs"));
if (useOs == "undefined") useOs = "";
var osType = new Number(Request.form("osType"));
if (isNaN(osType)) osType = 0;
var useOsVer = new String(Request.form("useOsVer"));
if (useOsVer == "undefined") useOsVer = "";
var osVer = new String(Request.form("osVer"));
osVer = ArgumentCheck(osVer);
if (osVer == "undefined") osVer = "*";
osVer = osVer.substr(0,100);
if (osVer.length == 0) osVer = "*";
var scriptId = new Number(Request.form("scriptId"));
if (isNaN(scriptId)) scriptId = 0;
var scriptName = new String(Request.form("scriptName"));
if (scriptName == "undefined") scriptName = "";
var useScriptPending = new String(Request.form("useScriptPending"));
if (useScriptPending == "undefined") useScriptPending = "";
var scriptPending = new Number(Request.form("scriptPending"));
if (isNaN(scriptPending)) scriptPending = 0;
var useScriptResult = new String(Request.form("useScriptResult"));
if (useScriptResult == "undefined") useScriptResult = "";
var scriptResult = new Number(Request.form("scriptResult"));
if (isNaN(scriptResult)) scriptResult = 0;
var useScriptSince = new String(Request.form("useScriptSince"));
if (useScriptSince == "undefined") useScriptSince = "";
var scriptSince = new Number(Request.form("scriptSince"));
if (isNaN(scriptSince)) scriptSince = 0;
var scriptMin = new Number(Request.form("scriptMin"));
if (isNaN(scriptMin)) scriptMin = 1;
if (scriptMin < 1) scriptMin = 1;
if (scriptMin > 9999) scriptMin = 9999;
var scriptMinUnit = new String(Request.form("scriptMinUnit"));
if (scriptMinUnit == "undefined") scriptMinUnit = "Day";
var useAppName = new String(Request.form("useAppName"));
if (useAppName == "undefined") useAppName = "";
var appContainMiss = new Number(Request.form("appContainMiss"));
if (isNaN(appContainMiss)) appContainMiss = 1;
var appFilter = new String(Request.form("appFilter"));
if (appFilter == "undefined") appFilter = "*";
appFilter = appFilter.substr(0,100);
appFilter = appFilter.replace(/\'/g,"''");
appFilter = ArgumentCheck(appFilter);
var useAppVer = new String(Request.form("useAppVer"));
if (useAppVer == "undefined") useAppVer = "";
var verCompare = new Number(Request.form("verCompare"));
if (isNaN(verCompare)) verCompare = 1;
var verFilter = new String(Request.form("verFilter"));
if (verFilter == "undefined") verFilter = "0";
verFilter = verFilter.substr(0,100);
verFilter = verFilter.replace(/\'/g,"''");
verFilter = ArgumentCheck(verFilter);
var usePatchFil = new String(Request.form("usePatchFil"));
if (usePatchFil == "undefined") usePatchFil = "";
var missingPatches = new Number(Request.form("missingPatches"));
if (isNaN(missingPatches)) missingPatches = 0;
if (missingPatches < 1) missingPatches = 0;
if (missingPatches > 9999) missingPatches = 9999;
var usePatchPolicy = new String(Request.form("usePatchPolicy"));
if (usePatchPolicy == "0") {
    usePatchPolicy = "";
} else if (usePatchPolicy == "undefined") {
    usePatchPolicy = "";
}
var usePatchScanPending = new String(Request.form("usePatchScanPending"));
if (usePatchScanPending == "undefined") usePatchScanPending = "";
var patchScanPending = new Number(Request.form("patchScanPending"));
if (isNaN(patchScanPending)) patchScanPending = 0;
var useDefaultPatchScanSource = new String(Request.form("useDefaultPatchScanSource"));
if (useDefaultPatchScanSource == "undefined") useDefaultPatchScanSource = "";
// radio buttons
var defaultPatchScanSource = new Number(Request.form("defaultPatchScanSource"));
if (isNaN(defaultPatchScanSource)) defaultPatchScanSource = 0;
var usePatchScanResult = new String(Request.form("usePatchScanResult"));
if (usePatchScanResult == "undefined") usePatchScanResult = "";
var patchScanResult = new Number(Request.form("patchScanResult"));
if (isNaN(patchScanResult)) patchScanResult = 0;
var usePatchScanSince = new String(Request.form("usePatchScanSince"));
if (usePatchScanSince == "undefined") usePatchScanSince = "";
var patchScanSince = new Number(Request.form("patchScanSince"));
if (isNaN(patchScanSince)) patchScanSince = 0;
var patchScanMin = new Number(Request.form("patchScanMin"));
if (isNaN(patchScanMin)) patchScanMin = 1;
if (patchScanMin < 1) patchScanMin = 0;
if (patchScanMin > 9999) patchScanMin = 9999;
var patchScanMinUnit = new String(Request.form("patchScanMinUnit"));
if (patchScanMinUnit == "undefined") patchScanMinUnit = "Day";
var usePatchRebootPending = new String(Request.form("usePatchRebootPending"));
if (usePatchRebootPending == "undefined") usePatchRebootPending = "";
var usePatchInstallFailures = new String(Request.form("usePatchInstallFailures"));
if (usePatchInstallFailures == "undefined") usePatchInstallFailures = "";
var usePatchWuauservFailures = new String(Request.form("usePatchWuauservFailures"));
if (usePatchWuauservFailures == "undefined") usePatchWuauservFailures = "";
var usePatchTestStatus = new String(Request.form("usePatchTestStatus"));
if (usePatchTestStatus == "undefined") usePatchTestStatus = "";
var patchTestStatus = new Number(Request.form("patchTestStatus"));
if (isNaN(patchTestStatus)) patchTestStatus = -2;
var usePatchAutoUpdateConfig = new String(Request.form("usePatchAutoUpdateConfig"));
if (usePatchAutoUpdateConfig == "undefined") usePatchAutoUpdateConfig = "";
var patchAutoUpdateConfig = new Number(Request.form("patchAutoUpdateConfig"));
if (isNaN(patchAutoUpdateConfig)) patchAutoUpdateConfig = 0;
var usePatchRebootConfig = new String(Request.form("usePatchRebootConfig"));
if (usePatchRebootConfig == "undefined") usePatchRebootConfig = "";
var patchRebootConfig = new Number(Request.form("patchRebootConfig"));
if (isNaN(patchRebootConfig)) patchRebootConfig = 0;
var usePatchFileSrcConfig = new String(Request.form("usePatchFileSrcConfig"));
if (usePatchFileSrcConfig == "undefined") usePatchFileSrcConfig = "";
var patchFileSrcConfig = new String(Request.form("patchFileSrcConfig"));
patchFileSrcConfig = ArgumentCheck(patchFileSrcConfig);
if (patchFileSrcConfig == "undefined") patchFileSrcConfig = "0,4";
var usePatchUnscanned = new String(Request.form("usePatchUnscanned"));
if (usePatchUnscanned == "undefined") usePatchUnscanned = "";
var usePatchFileShare = new String(Request.form("usePatchFileShare"));
if (usePatchFileShare == "undefined") usePatchFileShare = "";
var usePatchFileShareSet = new String(Request.form("usePatchFileShareSet"));
if (usePatchFileShareSet == "undefined") usePatchFileShareSet = "";
var patchFileShareAgentGuid = new String(Request.form("machGuid"));
patchFileShareAgentGuid = ArgumentCheck(patchFileShareAgentGuid);
if (patchFileShareAgentGuid == "undefined") patchFileShareAgentGuid = null;
var patchFileShareAgentDisplayName = new String(Request.form("patchFileShareAgentDisplayName"));
if (patchFileShareAgentDisplayName == "undefined") patchFileShareAgentDisplayName = "";
var usePatchOnlineScanFail = new String(Request.form("usePatchOnlineScanFail"));
if (usePatchOnlineScanFail == "undefined") usePatchOnlineScanFail = "";
var usePatchMissingKB = new String(Request.form("usePatchMissingKB"));
if (usePatchMissingKB == "undefined") usePatchMissingKB = "";
var patchMissingKB = new String(Request.form("patchMissingKB"));
patchMissingKB = ArgumentCheck(patchMissingKB);
if (patchMissingKB == "undefined") patchMissingKB = "";
var usePatchInstalledKB = new String(Request.form("usePatchInstalledKB"));
if (usePatchInstalledKB == "undefined") usePatchInstalledKB = "";
var patchInstalledKB = new String(Request.form("patchInstalledKB"));
patchInstalledKB = ArgumentCheck(patchInstalledKB);
if (patchInstalledKB == "undefined") patchInstalledKB = "";
var useWuaDisabled = new String(Request.form("useWuaDisabled"));
if (useWuaDisabled == "undefined") useWuaDisabled = "";
var wuaDisabled = new Number(Request.form("wuaDisabled"));
if (isNaN(wuaDisabled)) wuaDisabled = 0;
var andMachineLabelsFlag = new Number(Request.form("andMachineLabelsFlag"));
if (isNaN(andMachineLabelsFlag)) andMachineLabelsFlag = 0;

var advFilter = new String(Request.form("advFilter"));
if (advFilter == "undefined") advFilter = "";
var advFilterId = new Number(Request.form("advFilterId"));
if (isNaN(advFilterId)) advFilterId = 0;

var useMonitorset = new String(Request.form("useMonitorset"));
if (useMonitorset == "undefined") useMonitorset = "";
var useMonitorsetID = new String(Request.form("useMonitorsetID"));
if (useMonitorsetID == "undefined") useMonitorsetID = 0;

var useSNMPMonitorset = new String(Request.form("useSNMPMonitorset"));
if (useSNMPMonitorset == "undefined") useSNMPMonitorset = "";
var useSNMPMonitorsetID = new String(Request.form("useSNMPMonitorsetID"));
if (useSNMPMonitorsetID == "undefined") useSNMPMonitorsetID = 0;

var useApp1 = new String(Request.form("useApp1"));
if (useApp1 == "undefined") useApp1 = "";
var useApp2 = new String(Request.form("useApp2"));
if (useApp2 == "undefined") useApp2 = "";
var useApp3 = new String(Request.form("useApp3"));
if (useApp3 == "undefined") useApp3 = "";
var useApp4 = new String(Request.form("useApp4"));
if (useApp4 == "undefined") useApp4 = "";
var useApp5 = new String(Request.form("useApp5"));
if (useApp5 == "undefined") useApp5 = "";
var useApp6 = new String(Request.form("useApp6"));
if (useApp6 == "undefined") useApp6 = "";
var useApp7 = new String(Request.form("useApp7"));
if (useApp7 == "undefined") useApp7 = "";
var useApp8 = new String(Request.form("useApp8"));
if (useApp8 == "undefined") useApp8 = "";
var useApp9 = new String(Request.form("useApp9"));
if (useApp9 == "undefined") useApp9 = "";
var useApp10 = new String(Request.form("useApp10"));
if (useApp10 == "undefined") useApp10 = "";
var useApp11 = new String(Request.form("useApp11"));
if (useApp11 == "undefined") useApp11 = "";
var useApp12 = new String(Request.form("useApp12"));
if (useApp12 == "undefined") useApp12 = "";
var useApp13 = new String(Request.form("useApp13"));
if (useApp13 == "undefined") useApp13 = "";
var useApp14 = new String(Request.form("useApp14"));
if (useApp14 == "undefined") useApp14 = "";
var useApp15 = new String(Request.form("useApp15"));
if (useApp15 == "undefined") useApp15 = "";
var useApp16 = new String(Request.form("useApp16"));
if (useApp16 == "undefined") useApp16 = "";
var useApp17 = new String(Request.form("useApp17"));
if (useApp17 == "undefined") useApp17 = "";
var useApp18 = new String(Request.form("useApp18"));
if (useApp18 == "undefined") useApp18 = "";
var useApp19 = new String(Request.form("useApp19"));
if (useApp19 == "undefined") useApp19 = "";
var useApp20 = new String(Request.form("useApp20"));
if (useApp20 == "undefined") useApp20 = "";

var useLabel1 = new String(Request.form("useLabel1"));
if (useLabel1 == "undefined") useLabel1 = "";
var useLabel2 = new String(Request.form("useLabel2"));
if (useLabel2 == "undefined") useLabel2 = "";
var useLabel3 = new String(Request.form("useLabel3"));
if (useLabel3 == "undefined") useLabel3 = "";
var useLabel4 = new String(Request.form("useLabel4"));
if (useLabel4 == "undefined") useLabel4 = "";
var useLabel5 = new String(Request.form("useLabel5"));
if (useLabel5 == "undefined") useLabel5 = "";
var useLabel6 = new String(Request.form("useLabel6"));
if (useLabel6 == "undefined") useLabel6 = "";
var useLabel7 = new String(Request.form("useLabel7"));
if (useLabel7 == "undefined") useLabel7 = "";
var useLabel8 = new String(Request.form("useLabel8"));
if (useLabel8 == "undefined") useLabel8 = "";
var useLabel9 = new String(Request.form("useLabel9"));
if (useLabel9 == "undefined") useLabel9 = "";
var useLabel10 = new String(Request.form("useLabel10"));
if (useLabel10 == "undefined") useLabel10 = "";
var useLabel11 = new String(Request.form("useLabel11"));
if (useLabel11 == "undefined") useLabel11 = "";
var useLabel12 = new String(Request.form("useLabel12"));
if (useLabel12 == "undefined") useLabel12 = "";
var useLabel13 = new String(Request.form("useLabel13"));
if (useLabel13 == "undefined") useLabel13 = "";
var useLabel14 = new String(Request.form("useLabel14"));
if (useLabel14 == "undefined") useLabel14 = "";
var useLabel15 = new String(Request.form("useLabel15"));
if (useLabel15 == "undefined") useLabel15 = "";
var useLabel16 = new String(Request.form("useLabel16"));
if (useLabel16 == "undefined") useLabel16 = "";
var useLabel17 = new String(Request.form("useLabel17"));
if (useLabel17 == "undefined") useLabel17 = "";
var useLabel18 = new String(Request.form("useLabel18"));
if (useLabel18 == "undefined") useLabel18 = "";
var useLabel19 = new String(Request.form("useLabel19"));
if (useLabel19 == "undefined") useLabel19 = "";
var useLabel20 = new String(Request.form("useLabel20"));
if (useLabel20 == "undefined") useLabel20 = "";
var useLabel21 = new String(Request.form("useLabel21"));
if (useLabel21 == "undefined") useLabel21 = "";
var useLabel22 = new String(Request.form("useLabel22"));
if (useLabel22 == "undefined") useLabel22 = "";
var useLabel23 = new String(Request.form("useLabel23"));
if (useLabel23 == "undefined") useLabel23 = "";
var useLabel24 = new String(Request.form("useLabel24"));
if (useLabel24 == "undefined") useLabel24 = "";
var useLabel25 = new String(Request.form("useLabel25"));
if (useLabel25 == "undefined") useLabel25 = "";
var useLabel26 = new String(Request.form("useLabel26"));
if (useLabel26 == "undefined") useLabel26 = "";
var useLabel27 = new String(Request.form("useLabel27"));
if (useLabel27 == "undefined") useLabel27 = "";
var useLabel28 = new String(Request.form("useLabel28"));
if (useLabel28 == "undefined") useLabel28 = "";
var useLabel29 = new String(Request.form("useLabel29"));
if (useLabel29 == "undefined") useLabel29 = "";
var useLabel30 = new String(Request.form("useLabel30"));
if (useLabel30 == "undefined") useLabel30 = "";
var useLabel31 = new String(Request.form("useLabel31"));
if (useLabel31 == "undefined") useLabel31 = "";
var useLabel32 = new String(Request.form("useLabel32"));
if (useLabel32 == "undefined") useLabel32 = "";
var useLabel33 = new String(Request.form("useLabel33"));
if (useLabel33 == "undefined") useLabel33 = "";
var useLabel34 = new String(Request.form("useLabel34"));
if (useLabel34 == "undefined") useLabel34 = "";
var useLabel35 = new String(Request.form("useLabel35"));
if (useLabel35 == "undefined") useLabel35 = "";
var useLabel36 = new String(Request.form("useLabel36"));
if (useLabel36 == "undefined") useLabel36 = "";
var useLabel37 = new String(Request.form("useLabel37"));
if (useLabel37 == "undefined") useLabel37 = "";
var useLabel38 = new String(Request.form("useLabel38"));
if (useLabel38 == "undefined") useLabel38 = "";
var useLabel39 = new String(Request.form("useLabel39"));
if (useLabel39 == "undefined") useLabel39 = "";
var useLabel40 = new String(Request.form("useLabel40"));
if (useLabel40 == "undefined") useLabel40 = "";
var useLabel41 = new String(Request.form("useLabel41"));
if (useLabel41 == "undefined") useLabel41 = "";
var useLabel42 = new String(Request.form("useLabel42"));
if (useLabel42 == "undefined") useLabel42 = "";
var useLabel43 = new String(Request.form("useLabel43"));
if (useLabel43 == "undefined") useLabel43 = "";
var useLabel44 = new String(Request.form("useLabel44"));
if (useLabel44 == "undefined") useLabel44 = "";
var useLabel45 = new String(Request.form("useLabel45"));
if (useLabel45 == "undefined") useLabel45 = "";
var useLabel46 = new String(Request.form("useLabel46"));
if (useLabel46 == "undefined") useLabel46 = "";
var useLabel47 = new String(Request.form("useLabel47"));
if (useLabel47 == "undefined") useLabel47 = "";
var useLabel48 = new String(Request.form("useLabel48"));
if (useLabel48 == "undefined") useLabel48 = "";
var useLabel49 = new String(Request.form("useLabel49"));
if (useLabel49 == "undefined") useLabel49 = "";
var useLabel50 = new String(Request.form("useLabel50"));
if (useLabel50 == "undefined") useLabel50 = "";
var useLabel51 = new String(Request.form("useLabel51"));
if (useLabel51 == "undefined") useLabel51 = "";
var useLabel52 = new String(Request.form("useLabel52"));
if (useLabel52 == "undefined") useLabel52 = "";
var useLabel53 = new String(Request.form("useLabel53"));
if (useLabel53 == "undefined") useLabel53 = "";
var useLabel54 = new String(Request.form("useLabel54"));
if (useLabel54 == "undefined") useLabel54 = "";
var useLabel55 = new String(Request.form("useLabel55"));
if (useLabel55 == "undefined") useLabel55 = "";


/* Temporary conditional statement */
cmd = "IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS  " +
    " WHERE TABLE_NAME = 'ViewDef' AND COLUMN_NAME = 'useMonsetFilter') " +
    " BEGIN "  +
    " ALTER TABLE ViewDef ADD useMonsetFilter INT NULL" +
    " END;  ";
dbConn.Execute(cmd ,0,128);

/* Temporary conditional statement */
cmd = "IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS  " +
    " WHERE TABLE_NAME = 'ViewDef' AND COLUMN_NAME = 'MonsetID') " +
    " BEGIN "  +
    " ALTER TABLE ViewDef ADD MonsetID INT NULL" +
    " END;  ";
dbConn.Execute(cmd ,0,128);

/* Temporary conditional statement */
cmd = "IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS  " +
    " WHERE TABLE_NAME = 'ViewDef' AND COLUMN_NAME = 'useSNMPsetFilter') " +
    " BEGIN "  +
    " ALTER TABLE ViewDef ADD useSNMPsetFilter INT NULL" +
    " END;  ";
dbConn.Execute(cmd ,0,128);

/* Temporary conditional statement */
cmd = "IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS  " +
    " WHERE TABLE_NAME = 'ViewDef' AND COLUMN_NAME = 'SNMPsetID') " +
    " BEGIN "  +
    " ALTER TABLE ViewDef ADD SNMPsetID INT NULL" +
    " END;  ";
dbConn.Execute(cmd ,0,128);

if (firstPass.length == 0 && newView.length == 0) {
    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
    sql ="SELECT activeViewId FROM adminMachFil WHERE adminId=?";
    cmd = createAdoCommand(dbConn,sql,adCmdText);
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
    recSet.CursorType = adOpenStatic;
    recSet.Open(cmd);
    if (recSet.EOF == false) {
        activeViewId = Number(recSet("activeViewId"));
    }
    recSet.Close();
}

var appInt = 0;
var appArray = new Array();
var appArrayStr = new Array();
// SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
sql ="select id, ref from partnerApp where usageCountsAvail = 1 and partitionId = ?";
cmd = createAdoCommand(dbConn,sql,adCmdText);
cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionid", sessionPartition));
recSet.CursorType = adOpenStatic;
recSet.Open(cmd);
while (recSet.EOF == false) {
    appArray[appInt] = new Number(recSet("id"));
    appArrayStr[appInt] = new String(recSet("ref"));
    appInt++;
    recSet.MoveNext();
}
recSet.Close();
var appsCount = appInt;

var labelInt = 0;
var labelArray = new Array();
var labelArrayStr = new Array();
// SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
sql ="select id, ref from agentlabel where partitionId = ? OR internalCode = 1 ORDER BY ref";
cmd = createAdoCommand(dbConn,sql,adCmdText);
cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionid", sessionPartition));
recSet.CursorType = adOpenStatic;
recSet.Open(cmd);
while (recSet.EOF == false) {
    labelArray[labelInt] = new Number(recSet("id"));
    labelArrayStr[labelInt] = new String(recSet("ref"));
    labelInt++;
    recSet.MoveNext();
}
recSet.Close();
var labelsCount = labelInt;

if ((takeId > 0)&&(sessionAdminType==2)) {
    // Take ownership
    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
    sql ="UPDATE viewDef SET adminId=? WHERE adminId > 0 AND viewId=?";
    cmd = createAdoCommand(dbConn,sql,adCmdText);
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", takeId));
    cmd.Execute(adExecuteNoRecords);
}

showCollections = true;

switch (Number(buttonType)) {
  case 0: // nothing hit
  default:
    break;
  case 1: // save hit
  case 2: // save as hit. create a new view
    if (useMachFil.length == 0) uMachFil = 0;
    else uMachFil = 1;
    if (useGroupFil.length == 0) uGroupFil = 0;
    else uGroupFil = 1;
    if (useViewColFil.length == 0) uViewColFil = 0;
    else uViewColFil = 1;
    if (useColFil.length == 0) uColFil = 0;
    else if (Number(showHideCollection) == 1) uColFil = 2;
    else uColFil = 1;
    if (showCheckin.length == 0) sCheckin = 0;
    else if (Number(checkinStat) == 0) sCheckin = 1;
    else if (Number(checkinStat) == 1) sCheckin = 2;
    else sCheckin = 3;
    switch (String(onLineMinUnit)) {
      case "Min":
      default:
        oMin = onLineMin;
        break;
      case "Hr":
        oMin = onLineMin * 60;
        break;
      case "Day":
        oMin = onLineMin * 60 * 24;
        break;
    }
    if (showSuspended.length == 0) sSuspended = 0;
    else if (Number(suspendedStat) == 0) sSuspended = 1;
    else sSuspended = 2;
    if (showReboot.length == 0) sReboot = 0;
    else if (Number(rebootStat) == 0) sReboot = 1;
    else sReboot = 2;
    switch (String(rebootMinUnit)) {
      case "Min":
      default:
        rMin = rebootMin;
        break;
      case "Hr":
        rMin = rebootMin * 60;
        break;
      case "Day":
        rMin = rebootMin * 60 * 24;
        break;
    }
    if (useAgentCredentialStatus.length > 0) cCredentialStatus = 1;
    else cCredentialStatus = 0;
    if (cCredentialStatus == 0) agentCredentialStatus = -1;
    if (useGateway.length == 0) uGateway = 0;
    else uGateway = 1;
    if (useIpFil.length == 0) uIp = 0;
    else uIp = 1;
    if (Number(useOs) == 0) uOs = 0;
    else uOs = osType;
    if (useOsVer.length == 0) uOsVer = 0;
    else uOsVer = 1;
    if (useScriptPending.length == 0) uScriptPending = 0;
    else if (Number(scriptPending) == 1) uScriptPending = 1;
    else uScriptPending = 2;
    if (useScriptResult.length == 0) uScriptResult = 0;
    else if (Number(scriptResult) == 1) uScriptResult = 1;
    else uScriptResult = 2;
    if (useScriptSince.length == 0) uScriptSince = 0;
    else if (Number(scriptSince) == 1) uScriptSince = 1;
    else uScriptSince = 2;
    switch (String(scriptMinUnit)) {
      case "Min":
      default:
        sMin = scriptMin;
        break;
      case "Hr":
        sMin = scriptMin * 60;
        break;
      case "Day":
        sMin = scriptMin * 60 * 24;
        break;
    }
    if (Number(useAppName) == 0) uApp = 0;
    else uApp = appContainMiss;
    if (Number(useAppName) == 0) uAppVer = 0;
    else if (Number(useAppVer) == 0) uAppVer = 0;
    else uAppVer = verCompare;

    if (usePatchFil.length == 0) {
        uPatch = 0;
        uMissingPatch = 0;
        uPatchPolicy = 0;
    } else {
        if (Number(missingPatches) > 0) {
           uPatch = 1;
           uMissingPatch = Number(missingPatches);
           if (usePatchPolicy.length == 0) {
               uPatchPolicy = 0;
           } else {
               uPatchPolicy = 1;
           }
        } else {
           uPatch = 0;
           uMissingPatch = 0;
           uPatchPolicy = 0;
        }
    }
    if (usePatchScanPending.length == 0) uPatchScanPending = 0;
    else if (Number(patchScanPending) == 1) uPatchScanPending = 1;
    else uPatchScanPending = 2;
    if (useDefaultPatchScanSource.length == 0) uDefaultPatchScanSource = 0;
    else if (Number(defaultPatchScanSource) == 1) uDefaultPatchScanSource = 1;
    else uDefaultPatchScanSource = 2;
    if (usePatchScanResult.length == 0) uPatchScanResult = 0;
    else if (Number(patchScanResult) == 1) uPatchScanResult = 1;
    else uPatchScanResult = 2;
    if (usePatchScanSince.length == 0) uPatchScanSince = 0;
    else if (Number(patchScanSince) == 1) uPatchScanSince = 1;
    else uPatchScanSince = 2;
    switch (String(patchScanMinUnit)) {
      case "Min":
      default:
        psMin = patchScanMin;
        break;
      case "Hr":
        psMin = patchScanMin * 60;
        break;
      case "Day":
        psMin = patchScanMin * 60 * 24;
        break;
    }
    if (uPatchScanSince == 0) {
        patchScanMinUnit = "Day";
        psMin = 60 * 24;
    }

    if (usePatchRebootPending.length > 0) cPatchRebootPending = 1;
    else cPatchRebootPending = 0;

    if (usePatchInstallFailures.length > 0) cPatchInstallFailures = 1;
    else cPatchInstallFailures = 0;

    if (usePatchWuauservFailures.length > 0) cPatchWuauservFailures = 1;
    else cPatchWuauservFailures = 0;

    if (usePatchTestStatus.length > 0) cPatchTestStatus = 1;
    else cPatchTestStatus = 0;
    if (cPatchTestStatus == 0) patchTestStatus = -2;

    if (usePatchAutoUpdateConfig.length > 0) cPatchAutoUpdateConfig = 1;
    else cPatchAutoUpdateConfig = 0;
    if (cPatchAutoUpdateConfig == 0) patchAutoUpdateConfig = 0;

    if (usePatchRebootConfig.length > 0) cPatchRebootConfig = 1;
    else cPatchRebootConfig = 0;
    if (cPatchRebootConfig == 0) patchRebootConfig = 0;

    if (usePatchFileSrcConfig.length > 0) cPatchFileSrcConfig = 1;
    else cPatchFileSrcConfig = 0;
    if (cPatchFileSrcConfig == 0) patchFileSrcConfig = "0,4";

    if (usePatchUnscanned.length > 0) cPatchUnscanned = 1;
    else cPatchUnscanned = 0;

    if (usePatchFileShare.length > 0) cPatchFileShare = 1;
    else cPatchFileShare = 0;

    if (usePatchFileShareSet.length > 0) cPatchFileShareSet = 1;
    else cPatchFileShareSet = 0;
    if (cPatchFileShareSet == 0 || patchFileShareAgentGuid.length == 0) patchFileShareAgentGuid = null;

    if (usePatchOnlineScanFail.length > 0) cPatchOnlineScanFail = 1;
    else cPatchOnlineScanFail = 0;

    if (usePatchOnlineScanFail.length > 0) cPatchOnlineScanFail = 1;
    else cPatchOnlineScanFail = 0;

    if (usePatchMissingKB.length > 0) cPatchMissingKB = 1;
    else cPatchMissingKB = 0;
    if (cPatchMissingKB == 0) patchMissingKB = "";

    if (usePatchInstalledKB.length > 0) cPatchInstalledKB = 1;
    else cPatchInstalledKB = 0;
    if (cPatchInstalledKB == 0) patchInstalledKB = "";

    if (useWuaDisabled.length == 0) uWuaDisabled = 0;
    else if (Number(wuaDisabled) == 1) uWuaDisabled = 1;
    else uWuaDisabled = 2;
	
	if (Number(andMachineLabelsFlag) == 1) uAndMachineLabelsFlag = 1;
	else uAndMachineLabelsFlag = 0;

    if (advFilter.length > 0) cAdvFilter = 1;
    else cAdvFilter = 0;

    if (useMonitorset.length > 0) useMonitorset = 1;
    else useMonitorset = 0;

    if (useMonitorsetID <= 0)
    {
        useMonitorset = 0;
    }

    if (useSNMPMonitorset.length > 0) useSNMPMonitorset = 1;
    else useSNMPMonitorset = 0;

    if (useSNMPMonitorsetID <= 0)
    {
       useSNMPMonitorset = 0;
    }


    if (Number(buttonType) == 2) { // process save as
        // create a unique id for this view
        oldActiveViewId = activeViewId;
        activeViewId = Number(String(Math.random()).substr(2,8));
        // duplicate the advanced filter so this new view gets its own copy to use
        newAdvFilterId = Number(String(Math.random()).substr(2,8));

        numViewName = 0;
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="SELECT COUNT(*) AS numViewName "+
             "FROM viewDef v "+
             "JOIN adminIdTab t ON v.adminId = t.adminId "+
             "JOIN administrators a ON t.adminName = a.adminName "+
             "AND a.partitionStr = ? "+
             "WHERE v.viewName = ?";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@partitionStr", sessionPartition));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@viewName", editTitle));
        tempSet.CursorType = adOpenStatic;
        tempSet.Open(cmd);
        if (!tempSet.EOF) {
            numViewName = Number(tempSet("numViewName"));
        }
        tempSet.Close();
        if (numViewName > 0) {
            editTitle = xlate("Copy of",true) + " " + editTitle;
        }

        // create the view
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="INSERT reportFilters (filterId,colId,showCol,filter) "+
                    "(SELECT ?,colId,showCol,filter FROM reportFilters "+
                    "WHERE filterId=?)";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@filterId", newAdvFilterId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@filterId", advFilterId));
        cmd.Execute(adExecuteNoRecords);
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="INSERT INTO viewDef (viewId,adminId,viewName,readWrite,shareAll,"+
             "useMachFil,overMachFil,useGroupFil,groupIdFil,showCheckin,onLineMin,showSuspended,"+
             "showReboot,rebootMin,useAgentCredentialStatus,agentCredentialStatus,useGateway,onlyGateway,useIpFil,ipFil,useOs,useOsVer,osVer,"+
             "useScriptPending,scriptId,useScriptResult,useScriptSince,scriptMin,useViewColFil,useColFil,colIdFil,"+
             "useAppName,appFilter,useAppVer,verFilter,usePatchFil,missingPatches,usePatchPolicy,usePatchScanPending,useDefaultPatchScanSource,"+
             "usePatchScanResult,usePatchScanSince,patchScanMin,usePatchRebootPending,usePatchInstallFailures,usePatchTestStatus,usePatchWuauservFailures,"+
             "patchTestStatus,usePatchAutoUpdateConfig,patchAutoUpdateConfig,usePatchRebootConfig,patchRebootConfig,"+
             "usePatchFileSrcConfig,patchFileSrcConfig,usePatchUnscanned,usePatchFileShare,usePatchFileShareSet,patchFileShareAgentGuid,usePatchOnlineScanFail,"+
             "usePatchMissingKB,patchMissingKB,usePatchInstalledKB,patchInstalledKB,useWuaDisabled,advFilter,advFilterId, useMonsetFilter, MonsetID, useSNMPsetFilter, SNMPsetID, andMachineLabelsFlag) "+
             "VALUES (?,?,?,0,0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@viewName", editTitle));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useMachFil", uMachFil));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@overMachFil", overMachFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useGroupFil", uGroupFil));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@groupIdFil", groupIdFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@showCheckin", sCheckin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@onLineMin", oMin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@showSuspended", sSuspended));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@showReboot", sReboot));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@rebootMin", rMin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useAgentCredentialStatus", cCredentialStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@agentCredentialStatus", agentCredentialStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useGateway", uGateway));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@onlyGateway", onlyGateway));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useIpFil", uIp));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@ipFil", ipFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useOs", uOs));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useOsVer", uOsVer));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@osVer", osVer));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useScriptPending", uScriptPending));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@scriptId", scriptId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useScriptResult", uScriptResult));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useScriptSince", uScriptSince));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@scriptMin", sMin));
        cmd.Parameters.Append( createAdoInputParamTinyInt(cmd, "@useViewColFil", uViewColFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useColFil", uColFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@colIdFil", colIdFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useAppName", uApp));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@appFilter", appFilter));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useAppVer", uAppVer));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@verFilter", verFilter));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFil", uPatch));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@missingPatches", uMissingPatch));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchPolicy", uPatchPolicy));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchScanPending", uPatchScanPending));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useDefaultPatchScanSource", uDefaultPatchScanSource));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchScanResult", uPatchScanResult));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchScanSince", uPatchScanSince));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchScanMin", psMin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchRebootPending", cPatchRebootPending));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchInstallFailures", cPatchInstallFailures));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchTestStatus", cPatchWuauservFailures));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchWuauservFailures", cPatchTestStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchTestStatus", patchTestStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchAutoUpdateConfig", cPatchAutoUpdateConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchAutoUpdateConfig", patchAutoUpdateConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchRebootConfig", cPatchRebootConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchRebootConfig", patchRebootConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFileSrcConfig", cPatchFileSrcConfig));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@patchFileSrcConfig", patchFileSrcConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchUnscanned", cPatchUnscanned));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFileShare", cPatchFileShare));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFileShareSet", cPatchFileShareSet));
        cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@patchFileShareAgentGuid", patchFileShareAgentGuid));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchOnlineScanFail", cPatchOnlineScanFail));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchMissingKB", cPatchMissingKB));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@patchMissingKB", patchMissingKB));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchInstalledKB", cPatchInstalledKB));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@patchInstalledKB", patchInstalledKB));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useWuaDisabled", uWuaDisabled));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@advFilter", cAdvFilter));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@advFilterId", newAdvFilterId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useMonsetFilter", useMonitorset));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@MonsetID", useMonitorsetID));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useSNMPsetFilter", useSNMPMonitorset));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@SNMPsetID", useSNMPMonitorsetID));
        cmd.Parameters.Append( createAdoInputParamBit(cmd, "@andMachineLabelsFlag", uAndMachineLabelsFlag));
        cmd.Execute(adExecuteNoRecords);
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="delete from viewDefApp where viewId = ? ";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Execute(adExecuteNoRecords);
        for(i = 0; i < appsCount; i++) {
            if (i == 0) {
                if (useApp1 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[0]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[0]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 1) {
                if (useApp2 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[1]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[1]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 2) {
                if (useApp3 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[2]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[2]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 3) {
                if (useApp4 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[3]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[3]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 4) {
                if (useApp5 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[4]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[4]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 5) {
                if (useApp6 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[5]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[5]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 6) {
                if (useApp7 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[6]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[6]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 7) {
                if (useApp8 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[7]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[7]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 8) {
                if (useApp9 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[8]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[8]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 9) {
                if (useApp10 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[9]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[9]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 10) {
                if (useApp11 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[10]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[10]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 11) {
                if (useApp12 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[11]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[11]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 12) {
                if (useApp13 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[12]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[12]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 13) {
                if (useApp14 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[13]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[13]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 14) {
                if (useApp15 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[14]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[14]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 15) {
                if (useApp16 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[15]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[15]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 16) {
                if (useApp17 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[16]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[16]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 17) {
                if (useApp18 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[17]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[17]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 18) {
                if (useApp19 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[18]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[18]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 19) {
                if (useApp20 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[19]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[19]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
        }
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="delete from viewDeflabel where viewId = ? ";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Execute(adExecuteNoRecords);
        for(i = 0; i < labelsCount; i++) {
            if (i == 0) {
                if (useLabel1 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[0]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 1) {
                if (useLabel2 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[1]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 2) {
                if (useLabel3 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[2]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 3) {
                if (useLabel4 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[3]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 4) {
                if (useLabel5 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[4]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 5) {
                if (useLabel6 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[5]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 6) {
                if (useLabel7 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[6]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 7) {
                if (useLabel8 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[7]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 8) {
                if (useLabel9 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[8]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 9) {
                if (useLabel10 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[9]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 10) {
                if (useLabel11 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[10]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 11) {
                if (useLabel12 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[11]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 12) {
                if (useLabel13 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[12]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 13) {
                if (useLabel14 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[13]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 14) {
                if (useLabel15 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[14]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 15) {
                if (useLabel16 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[15]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 16) {
                if (useLabel17 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[16]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 17) {
                if (useLabel18 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[17]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 18) {
                if (useLabel19 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[18]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 19) {
                if (useLabel20 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[19]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 20) {
                if (useLabel21 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[20]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 21) {
                if (useLabel22 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[21]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 22) {
                if (useLabel23 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[22]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 23) {
                if (useLabel24 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[23]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 24) {
                if (useLabel25 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[24]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 25) {
                if (useLabel26 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[25]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 26) {
                if (useLabel27 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[26]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 27) {
                if (useLabel28 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[27]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 28) {
                if (useLabel29 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[28]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 29) {
                if (useLabel30 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[29]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 30) {
                if (useLabel31 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[30]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 31) {
                if (useLabel32 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[31]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 32) {
                if (useLabel33 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[32]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 33) {
                if (useLabel34 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[33]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 34) {
                if (useLabel35 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[34]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 35) {
                if (useLabel36 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[35]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 36) {
                if (useLabel37 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[36]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 37) {
                if (useLabel38 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[37]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 38) {
                if (useLabel39 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[38]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 39) {
                if (useLabel40 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[39]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 40) {
                if (useLabel41 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[40]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 41) {
                if (useLabel42 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[41]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 42) {
                if (useLabel43 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[42]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 43) {
                if (useLabel44 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[43]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 44) {
                if (useLabel45 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[44]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 45) {
                if (useLabel46 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[45]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 46) {
                if (useLabel47 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[46]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 47) {
                if (useLabel48 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[47]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 48) {
                if (useLabel49 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[48]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 49) {
                if (useLabel50 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[49]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 50) {
                if (useLabel51 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[50]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 51) {
                if (useLabel52 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[51]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 52) {
                if (useLabel53 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[52]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 53) {
                if (useLabel54 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[53]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 54) {
                if (useLabel55 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[54]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
        }

        // copy over any view collection attached to the old view
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="INSERT viewCollection (viewId,agentGuid) "+
             "(SELECT ?,agentGuid FROM viewCollection WHERE viewId=?)";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", oldActiveViewId));
        cmd.Execute(adExecuteNoRecords);
    } else {
        // save hit
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="UPDATE viewDef SET viewName=?,useMachFil=?,overMachFil=?,useGroupFil=?,groupIdFil=?,showCheckin=?,onLineMin=?,showSuspended=?,showReboot=?,rebootMin=?,useAgentCredentialStatus=?,agentCredentialStatus=?,useGateway=?,onlyGateway=?,useIpFil=?,ipFil=?,useOs=?,useOsVer=?,osVer=?,useScriptPending=?,scriptId=?,useScriptResult=?,useScriptSince=?,scriptMin=?,useViewColFil=?,useColFil=?,colIdFil=?,useAppName=?,appFilter=?,useAppVer=?,verFilter=?,advFilter=?,advFilterId=?,usePatchFil=?,missingPatches=?,usePatchPolicy=?,usePatchScanPending=?,usePatchScanResult=?,useDefaultPatchScanSource=?,usePatchScanSince=?,patchScanMin=?,usePatchRebootPending=?,usePatchInstallFailures=?,usePatchWuauservFailures=?,usePatchTestStatus=?,patchTestStatus=?,usePatchAutoUpdateConfig=?,patchAutoUpdateConfig=?,usePatchRebootConfig=?,patchRebootConfig=?,usePatchFileSrcConfig=?,patchFileSrcConfig=? "+
             ",usePatchUnscanned=?,usePatchFileShare=?,usePatchFileShareSet=?,patchFileShareAgentGuid=?,usePatchOnlineScanFail=?,usePatchMissingKB=?,patchMissingKB=? "+
             ",usePatchInstalledKB=?,patchInstalledKB=? "+
             ",useWuaDisabled=?,useMonsetFilter=?,MonsetID=?,useSNMPsetFilter=?,SNMPsetID=?,andMachineLabelsFlag=? WHERE viewId=? AND (adminId=? OR (readWrite=1 AND shareAll=1)"+
             " OR (readWrite=1 AND EXISTS (SELECT 1 FROM viewAcl WHERE viewId = ? AND adminId=?)))";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@viewName", editTitle));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useMachFil", uMachFil));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@overMachFil", overMachFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useGroupFil", uGroupFil));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@groupIdFil", groupIdFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@showCheckin", sCheckin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@onLineMin", oMin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@showSuspended", sSuspended));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@showReboot", sReboot));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@rebootMin", rMin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useAgentCredentialStatus", cCredentialStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@agentCredentialStatus", agentCredentialStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useGateway", uGateway));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@onlyGateway", onlyGateway));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useIpFil", uIp));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@ipFil", ipFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useOs", uOs));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useOsVer", uOsVer));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@osVer", osVer));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useScriptPending", uScriptPending));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@scriptId", scriptId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useScriptResult", uScriptResult));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useScriptSince", uScriptSince));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@scriptMin", sMin));
        cmd.Parameters.Append( createAdoInputParamTinyInt(cmd, "@useViewColFil", uViewColFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useColFil", uColFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@colIdFil", colIdFil));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useAppName", uApp));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@appFilter", appFilter));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useAppVer", uAppVer));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@verFilter", verFilter));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@advFilter", cAdvFilter));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@advFilterId", advFilterId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFil", uPatch));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@missingPatches", uMissingPatch));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchPolicy", uPatchPolicy));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchScanPending", uPatchScanPending));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchScanResult", uPatchScanResult));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useDefaultPatchScanSource", uDefaultPatchScanSource));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchScanSince", uPatchScanSince));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchScanMin", psMin));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchRebootPending", cPatchRebootPending));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchInstallFailures", cPatchInstallFailures));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchWuauservFailures", cPatchWuauservFailures));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchTestStatus", cPatchTestStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchTestStatus", patchTestStatus));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchAutoUpdateConfig", cPatchAutoUpdateConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchAutoUpdateConfig", patchAutoUpdateConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchRebootConfig", cPatchRebootConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@patchRebootConfig", patchRebootConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFileSrcConfig", cPatchFileSrcConfig));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@patchFileSrcConfig", patchFileSrcConfig));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchUnscanned", cPatchUnscanned));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFileShare", cPatchFileShare));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchFileShareSet", cPatchFileShareSet));
        cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@patchFileShareAgentGuid", patchFileShareAgentGuid));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchOnlineScanFail", cPatchOnlineScanFail));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchMissingKB", cPatchMissingKB));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@patchMissingKB", patchMissingKB));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@usePatchInstalledKB", cPatchInstalledKB));
        cmd.Parameters.Append( createAdoInputParamNVarchar(cmd, "@patchInstalledKB", patchInstalledKB));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useWuaDisabled", uWuaDisabled));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useMonsetFilter", useMonitorset));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@MonsetID", useMonitorsetID));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@useSNMPsetFilter", useSNMPMonitorset));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@SNMPsetID", useSNMPMonitorsetID));
        cmd.Parameters.Append( createAdoInputParamBit(cmd, "@andMachineLabelsFlag", uAndMachineLabelsFlag));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
        cmd.Execute(adExecuteNoRecords);
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="delete from viewDefApp where viewId = ? ";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Execute(adExecuteNoRecords);
        for(i = 0; i < appsCount; i++) {
            if (i == 0) {
                if (useApp1 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[0]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[0]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 1) {
                if (useApp2 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[1]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[1]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 2) {
                if (useApp3 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[2]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[2]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 3) {
                if (useApp4 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[3]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[3]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 4) {
                if (useApp5 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[4]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[4]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 5) {
                if (useApp6 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[5]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[5]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 6) {
                if (useApp7 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[6]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[6]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 7) {
                if (useApp8 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[7]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[7]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 8) {
                if (useApp9 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[8]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[8]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 9) {
                if (useApp10 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[9]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[9]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 10) {
                if (useApp11 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[10]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[10]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 11) {
                if (useApp12 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[11]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[11]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 12) {
                if (useApp13 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[12]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[12]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 13) {
                if (useApp14 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[13]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[13]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 14) {
                if (useApp15 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[14]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[14]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 15) {
                if (useApp16 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[15]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[15]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 16) {
                if (useApp17 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[16]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[16]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 17) {
                if (useApp18 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[17]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[17]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 18) {
                if (useApp19 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[18]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[18]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 19) {
                if (useApp20 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDefApp (viewId, appId, appRef) values (?, ?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@appId", appArray[19]));
                    cmd.Parameters.Append( createAdoInputParamVarchar(cmd, "@appRef", appArrayStr[19]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
        }
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="delete from viewDeflabel where viewId = ? ";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
        cmd.Execute(adExecuteNoRecords);
        for(i = 0; i < labelsCount; i++) {
            if (i == 0) {
                if (useLabel1 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[0]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 1) {
                if (useLabel2 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[1]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 2) {
                if (useLabel3 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[2]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 3) {
                if (useLabel4 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[3]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 4) {
                if (useLabel5 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[4]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 5) {
                if (useLabel6 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[5]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 6) {
                if (useLabel7 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[6]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 7) {
                if (useLabel8 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[7]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 8) {
                if (useLabel9 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[8]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 9) {
                if (useLabel10 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[9]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 10) {
                if (useLabel11 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[10]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 11) {
                if (useLabel12 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[11]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 12) {
                if (useLabel13 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[12]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 13) {
                if (useLabel14 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[13]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 14) {
                if (useLabel15 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[14]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 15) {
                if (useLabel16 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[15]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 16) {
                if (useLabel17 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[16]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 17) {
                if (useLabel18 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[17]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 18) {
                if (useLabel19 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[18]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 19) {
                if (useLabel20 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[19]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 20) {
                if (useLabel21 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[20]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 21) {
                if (useLabel22 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[21]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 22) {
                if (useLabel23 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[22]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 23) {
                if (useLabel24 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[23]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 24) {
                if (useLabel25 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[24]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 25) {
                if (useLabel26 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[25]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 26) {
                if (useLabel27 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[26]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 27) {
                if (useLabel28 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[27]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 28) {
                if (useLabel29 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[28]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 29) {
                if (useLabel30 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[29]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 30) {
                if (useLabel31 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[30]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 31) {
                if (useLabel32 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[31]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 32) {
                if (useLabel33 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[32]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 33) {
                if (useLabel34 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[33]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 34) {
                if (useLabel35 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[34]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 35) {
                if (useLabel36 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[35]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 36) {
                if (useLabel37 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[36]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 37) {
                if (useLabel38 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[37]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 38) {
                if (useLabel39 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[38]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
            if (i == 39) {
                if (useLabel40 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[39]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 40) {
                if (useLabel41 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[40]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 41) {
                if (useLabel42 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[41]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 42) {
                if (useLabel43 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[42]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 43) {
                if (useLabel44 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[43]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 44) {
                if (useLabel45 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[44]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 45) {
                if (useLabel46 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[45]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 46) {
                if (useLabel47 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[46]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 47) {
                if (useLabel48 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[47]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 48) {
                if (useLabel49 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[48]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 49) {
                if (useLabel50 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[49]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 50) {
                if (useLabel51 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[50]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 51) {
                if (useLabel52 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[51]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 52) {
                if (useLabel53 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[52]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 53) {
                if (useLabel54 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[53]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
			if (i == 54) {
                if (useLabel55 == 'checked') {
                    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                    sql ="insert into viewDeflabel (viewId, labelId) values (?, ?) ";
                    cmd = createAdoCommand(dbConn,sql,adCmdText);
                    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@labelId", labelArray[54]));
                    cmd.Execute(adExecuteNoRecords);
                }
            }
        }

    }
    // set the selected view for this admin to the new activeViewId
    saveDbView(activeViewId);
    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
    sql ="UPDATE adminMachFil SET activeViewId=? WHERE adminId=?";
    cmd = createAdoCommand(dbConn,sql,adCmdText);
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@activeViewId", activeViewId));
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
    cmd.Execute(adExecuteNoRecords);
    reloadCmd = "opener.document.location.href.indexOf('#') > -1?opener.document.location = opener.document.location.href.replace('#', '&reload=true#'):opener.document.location = opener.document.location.href+'&reload=true'; ";
    if (reloadCmd.indexOf("?") < 0) reloadCmd = reloadCmd.replace(/\&/,"?");
    lastViewId = -1;
    break;
  case 3: // delete hit
    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
    sql ="DELETE FROM viewDef WHERE viewId=?; "+
         "DELETE FROM viewAcl WHERE viewId=?; "+
         "DELETE FROM viewDefApp WHERE viewId=?; ";
    cmd = createAdoCommand(dbConn,sql,adCmdText);
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
    cmd.Execute(adExecuteNoRecords);
    dropDbView(activeViewId);
    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
    sql ="if exists (select id from partnerApp where id = 44 and partitionId = ?) " +
         " insert into policy.event (id, partitionId, policyEventType, contextFK, policyEventGuid) values " +
         " (dbo.fn_GenerateKid(),?,23,1,?)";
    cmd = createAdoCommand(dbConn,sql,adCmdText);
    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionid", sessionPartition));
    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionid", sessionPartition));
    cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@policyEventGuid", activeViewId));
    cmd.Execute(adExecuteNoRecords);
    // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
    sql ="UPDATE adminMachFil SET activeViewId=0 WHERE activeViewId=?";
    cmd = createAdoCommand(dbConn,sql,adCmdText);
    cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@activeViewId", activeViewId));
    cmd.Execute(adExecuteNoRecords);
    activeViewId = 0;
    reloadCmd = "opener.document.location.href.indexOf('#') > -1?opener.document.location = opener.document.location.href.replace('#', '&reload=true#'):opener.document.location = opener.document.location.href+'&reload=true'; ";
    if (reloadCmd.indexOf("?") < 0) reloadCmd = reloadCmd.replace(/\&/,"?");
    break;
}

appInt = 0;
var appArrayOn = new Array();
// SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
sql ="select isNull(va.viewId,0) AS viewId from partnerApp pa LEFT OUTER JOIN viewDefApp va ON pa.id = va.appId and va.viewId = ? where usageCountsAvail = 1 and partitionId = ? ";
cmd = createAdoCommand(dbConn,sql,adCmdText);
cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionid", sessionPartition));
recSet.CursorType = adOpenStatic;
recSet.Open(cmd);
while (recSet.EOF == false) {
    appArrayOn[appInt] = new Number(recSet("viewId"));

    if (appInt == 0) {
        useApp1 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 1) {
        useApp2 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 2) {
        useApp3 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 3) {
        useApp4 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 4) {
        useApp5 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 5) {
        useApp6 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 6) {
        useApp7 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 7) {
        useApp8 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 8) {
        useApp9 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 9) {
        useApp10 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 10) {
        useApp11 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 11) {
        useApp12 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 12) {
        useApp13 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 13) {
        useApp14 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 14) {
        useApp15 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 15) {
        useApp16 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 16) {
        useApp17 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 17) {
        useApp18 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 18) {
        useApp19 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    if (appInt == 19) {
        useApp20 = (appArrayOn[appInt] != 0) ? "checked" : "";
    }
    appInt++;
    recSet.MoveNext();
}
recSet.Close();

labelInt = 0;
var labelArrayOn = new Array();
// SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
sql ="select isNull(va.viewId,0) AS viewId from agentlabel al LEFT OUTER JOIN viewDeflabel va ON al.id = va.labelId and va.viewId = ? where partitionId = ? OR internalCode = 1 ORDER BY al.ref";
cmd = createAdoCommand(dbConn,sql,adCmdText);
cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionid", sessionPartition));
recSet.CursorType = adOpenStatic;
recSet.Open(cmd);
while (recSet.EOF == false) {
    labelArrayOn[labelInt] = new Number(recSet("viewId"));

    if (labelInt == 0) {
        useLabel1 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 1) {
        useLabel2 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 2) {
        useLabel3 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 3) {
        useLabel4 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 4) {
        useLabel5 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 5) {
        useLabel6 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 6) {
        useLabel7 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 7) {
        useLabel8 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 8) {
        useLabel9 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 9) {
        useLabel10 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 10) {
        useLabel11 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 11) {
        useLabel12 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 12) {
        useLabel13 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 13) {
        useLabel14 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 14) {
        useLabel15 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 15) {
        useLabel16 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 16) {
        useLabel17 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 17) {
        useLabel18 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 18) {
        useLabel19 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 19) {
        useLabel20 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 20) {
        useLabel21 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 21) {
        useLabel22 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 22) {
        useLabel23 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 23) {
        useLabel24 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 24) {
        useLabel25 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 25) {
        useLabel26 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 26) {
        useLabel27 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 27) {
        useLabel28 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 28) {
        useLabel29 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 29) {
        useLabel30 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 30) {
        useLabel31 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 31) {
        useLabel32 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 32) {
        useLabel33 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 33) {
        useLabel34 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 34) {
        useLabel35 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 35) {
        useLabel36 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 36) {
        useLabel37 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 37) {
        useLabel38 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 38) {
        useLabel39 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    if (labelInt == 39) {
        useLabel40 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 40) {
        useLabel41 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 41) {
        useLabel42 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 42) {
        useLabel43 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 43) {
        useLabel44 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 44) {
        useLabel45 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 45) {
        useLabel46 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 46) {
        useLabel47 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 47) {
        useLabel48 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 48) {
        useLabel49 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 49) {
        useLabel50 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 50) {
        useLabel51 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 51) {
        useLabel52 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 52) {
        useLabel53 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 53) {
        useLabel54 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
	if (labelInt == 54) {
        useLabel55 = (labelArrayOn[labelInt] != 0) ? "checked" : "";
    }
    labelInt++;
    recSet.MoveNext();
}
recSet.Close();

// SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
sql ="SELECT v.*,ISNULL(s.scriptName,N'') AS scriptName, ISNULL(m.displayName, '') as patchFileShareAgentDisplayName FROM viewDef v LEFT OUTER JOIN "+
     "scriptIdTab s ON s.scriptId=v.scriptId LEFT OUTER JOIN machNameTab m ON v.patchFileShareAgentGuid = m.agentGuid WHERE viewId=?";
cmd = createAdoCommand(dbConn,sql,adCmdText);
cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
recSet.CursorType = adOpenStatic;
recSet.Open(cmd);
if (recSet.EOF == false)  {
    editTitle = String(recSet("viewName"));
    ownerId = Number(recSet("adminId"));
    readWrite = Number(recSet("readWrite"));
    if (Number(recSet("useMachFil")) == 1) useMachFil = "checked";
    else useMachFil = "";
    overMachFil = String(recSet("overMachFil"));
    if (Number(recSet("useGroupFil")) == 1) useGroupFil = "checked";
    else useGroupFil = "";
    groupIdFil = String(recSet("groupIdFil"));
    if (Number(recSet("useViewColFil")) == 1) useViewColFil = "checked";
    else useViewColFil = "";
    if ((Number(recSet("useColFil")) > 0)&&(showCollections == true)) {
        useColFil = "checked";
        if (Number(recSet("useColFil")) == 1) {
            radioSet += "showHideCollection[0].checked=true; showHideCollection[1].checked=false; ";
        } else {
            radioSet += "showHideCollection[0].checked=false; showHideCollection[1].checked=true; ";
        }
    } else {
        useColFil = "";
        if (showCollections == true) {
            radioSet += "showHideCollection[0].checked=true; showHideCollection[1].checked=false; ";
        }
    }
    colIdFil = Number(recSet("colIdFil"));
    if (Number(recSet("showCheckin")) == 0) {
        showCheckin = "";
        radioSet += "checkinStat[0].checked=false; checkinStat[1].checked=true; setOnlineStat(); ";
    } else {
        showCheckin = "checked";
        if (Number(recSet("showCheckin")) == 1) {
            radioSet += "checkinStat[0].checked=true; checkinStat[1].checked=false; checkinStat[2].checked=false; setOnlineStat(); ";
        } else if (Number(recSet("showCheckin")) == 2) {
            radioSet += "checkinStat[0].checked=false; checkinStat[1].checked=true; checkinStat[2].checked=false; setOnlineStat(); ";
        } else {
            radioSet += "checkinStat[0].checked=false; checkinStat[1].checked=false; checkinStat[2].checked=true; setOnlineStat(); ";
        }
    }
    onLineMin = Number(recSet("onLineMin"));
    // convert to hour or day
    onLineHr = onLineMin / 60;
    onLineDay = onLineHr / 24;
    if (Math.round(onLineDay) == onLineDay) {
        onLineMin = onLineDay;
        onLineMinUnit = "Day";
    } else if (Math.round(onLineHr) == onLineHr) {
        onLineMin = onLineHr;
        onLineMinUnit = "Hr";
    } else {
        onLineMinUnit = "Min";
    }
    if (Number(recSet("showSuspended")) == 0) {
        showSuspended = "";
        radioSet += "suspendedStat[0].checked=false; suspendedStat[1].checked=true; ";
    } else {
        showSuspended = "checked";
        if (Number(recSet("showSuspended")) == 1) {
            radioSet += "suspendedStat[0].checked=true; suspendedStat[1].checked=false; ";
        } else {
            radioSet += "suspendedStat[0].checked=false; suspendedStat[1].checked=true; ";
        }
    }
    if (Number(recSet("showReboot")) == 0) {
        showReboot = "";
        radioSet += "rebootStat[0].checked=false; rebootStat[1].checked=true; ";
    } else {
        showReboot = "checked";
        if (Number(recSet("showReboot")) == 1) {
            radioSet += "rebootStat[0].checked=true; rebootStat[1].checked=false; ";
        } else {
            radioSet += "rebootStat[0].checked=false; rebootStat[1].checked=true; ";
        }
    }
    rebootMin = Number(recSet("rebootMin"));
    // convert to hour or day
    rebootHr = rebootMin / 60;
    rebootDay = rebootHr / 24;
    if (Math.round(rebootDay) == rebootDay) {
        rebootMin = rebootDay;
        rebootMinUnit = "Day";
    } else if (Math.round(rebootHr) == rebootHr) {
        rebootMin = rebootHr;
        rebootMinUnit = "Hr";
    } else {
        rebootMinUnit = "Min";
    }
    if (Number(recSet("useAgentCredentialStatus")) == 0) useAgentCredentialStatus = "";
    else useAgentCredentialStatus = "checked";
    agentCredentialStatus = Number(recSet("agentCredentialStatus"));
    if (Number(recSet("useGateway")) == 1) useGateway = "checked";
    else useGateway = "";
    onlyGateway = String(recSet("onlyGateway"));
    if (Number(recSet("useIpFil")) == 1) useIpFil = "checked";
    else useIpFil = "";
    ipFil = String(recSet("ipFil"));
    if (Number(recSet("useOs")) > 0) useOs = "checked";
    else useOs = "";
    osType = Number(recSet("useOs"));
    if (Number(recSet("useOsVer")) == 1) useOsVer = "checked";
    else useOsVer = "";
    osVer = String(recSet("osVer"));
    if (Number(activeViewId) != Number(lastViewId)) {
        scriptId = Number(recSet("scriptId"));
        scriptName = String(recSet("scriptName"));
    } else {
        // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
        sql ="SELECT scriptName FROM scriptIdTab WHERE scriptId=?";
        cmd = createAdoCommand(dbConn,sql,adCmdText);
        cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@scriptId", scriptId));
        tempSet.CursorType = adOpenStatic;
        tempSet.Open(cmd);
        if (tempSet.EOF == false) {
            scriptName = String(tempSet("scriptName"));
            needToSave = "true";
        }
        tempSet.Close();
    }
    if (Number(recSet("useScriptPending")) == 0) {
        useScriptPending = "";
        radioSet += "scriptPending[0].checked=false; scriptPending[1].checked=true; ";
    } else {
        useScriptPending = "checked";
        if (Number(recSet("useScriptPending")) == 1) {
            radioSet += "scriptPending[0].checked=true; scriptPending[1].checked=false; ";
        } else {
            radioSet += "scriptPending[0].checked=false; scriptPending[1].checked=true; ";
        }
    }
    if (Number(recSet("useScriptResult")) == 0) {
        useScriptResult = "";
        radioSet += "scriptResult[0].checked=false; scriptResult[1].checked=true; ";
    } else {
        useScriptResult = "checked";
        if (Number(recSet("useScriptResult")) == 1) {
            radioSet += "scriptResult[0].checked=true; scriptResult[1].checked=false; ";
        } else {
            radioSet += "scriptResult[0].checked=false; scriptResult[1].checked=true; ";
        }
    }
    if (Number(recSet("useScriptSince")) == 0) {
        useScriptSince = "";
        radioSet += "scriptSince[0].checked=false; scriptSince[1].checked=true; ";
    } else {
        useScriptSince = "checked";
        if (Number(recSet("useScriptSince")) == 1) {
            radioSet += "scriptSince[0].checked=true; scriptSince[1].checked=false; ";
        } else {
            radioSet += "scriptSince[0].checked=false; scriptSince[1].checked=true; ";
        }
    }
    scriptMin = Number(recSet("scriptMin"));
    // convert to hour or day
    scriptHr = scriptMin / 60;
    scriptDay = scriptHr / 24;
    if (Math.round(scriptDay) == scriptDay) {
        scriptMin = scriptDay;
        scriptMinUnit = "Day";
    } else if (Math.round(scriptHr) == scriptHr) {
        scriptMin = scriptHr;
        scriptMinUnit = "Hr";
    } else {
        scriptMinUnit = "Min";
    }

    if (Number(recSet("useAppName")) == 0) {
        useAppName = "";
        radioSet += "appContainMiss[0].checked=true; appContainMiss[1].checked=false; ";
    } else {
        useAppName = "checked";
        if (Number(recSet("useAppName")) == 1) {
            radioSet += "appContainMiss[0].checked=true; appContainMiss[1].checked=false; ";
        } else {
            radioSet += "appContainMiss[0].checked=false; appContainMiss[1].checked=true; ";
        }
    }
    appFilter = String(recSet("appFilter"));
    if (String(appFilter) == "null") appFilter = "*";
    if (Number(recSet("useAppVer")) == 0) {
        useAppVer = "";
        radioSet += "verCompare[0].checked=true; verCompare[1].checked=false; verCompare[2].checked=false; verCompare[3].checked=false; ";
    } else {
        useAppVer = "checked";
        if (Number(recSet("useAppVer")) == 1) {
            radioSet += "verCompare[0].checked=true; verCompare[1].checked=false; verCompare[2].checked=false; verCompare[3].checked=false; ";
        } else if (Number(recSet("useAppVer")) == 2) {
            radioSet += "verCompare[0].checked=false; verCompare[1].checked=true; verCompare[2].checked=false; verCompare[3].checked=false; ";
        } else if (Number(recSet("useAppVer")) == 3) {
            radioSet += "verCompare[0].checked=false; verCompare[1].checked=false; verCompare[2].checked=true; verCompare[3].checked=false; ";
        } else {
            radioSet += "verCompare[0].checked=false; verCompare[1].checked=false; verCompare[2].checked=false; verCompare[3].checked=true; ";
        }
    }
    verFilter = String(recSet("verFilter"));
    if (String(verFilter) == "null") verFilter = "0";

    if (Number(recSet("usePatchFil")) == 1) usePatchFil = "checked";
    else usePatchFil = "";
    missingPatches = Number(recSet("missingPatches"));
    if (Number(recSet("usePatchPolicy")) == 1) usePatchPolicy = "checked";
    else usePatchPolicy = "";
    if (Number(recSet("usePatchScanPending")) == 0) {
        usePatchScanPending = "";
        radioSet += "patchScanPending[0].checked=false; patchScanPending[1].checked=true; ";
    } else {
        usePatchScanPending = "checked";
        if (Number(recSet("usePatchScanPending")) == 1) {
            radioSet += "patchScanPending[0].checked=true; patchScanPending[1].checked=false; ";
        } else {
            radioSet += "patchScanPending[0].checked=false; patchScanPending[1].checked=true; ";
        }
    }
    if (Number(recSet("useDefaultPatchScanSource")) == 0) {
        useDefaultPatchScanSource = "";
        radioSet += "defaultPatchScanSource[0].checked=true; defaultPatchScanSource[1].checked=false; ";
    } else {
        useDefaultPatchScanSource = "checked";
        if (Number(recSet("useDefaultPatchScanSource")) == 1) {
            radioSet += "defaultPatchScanSource[0].checked=true; defaultPatchScanSource[1].checked=false; ";
        } else {
            radioSet += "defaultPatchScanSource[0].checked=false; defaultPatchScanSource[1].checked=true; ";
        }
    }
    if (Number(recSet("usePatchScanResult")) == 0) {
        usePatchScanResult = "";
        radioSet += "patchScanResult[0].checked=false; patchScanResult[1].checked=true; ";
    } else {
        usePatchScanResult = "checked";
        if (Number(recSet("usePatchScanResult")) == 1) {
            radioSet += "patchScanResult[0].checked=true; patchScanResult[1].checked=false; ";
        } else {
            radioSet += "patchScanResult[0].checked=false; patchScanResult[1].checked=true; ";
        }
    }
    if (Number(recSet("usePatchScanSince")) == 0) {
        usePatchScanSince = "";
        radioSet += "patchScanSince[0].checked=false; patchScanSince[1].checked=true; ";
    } else {
        usePatchScanSince = "checked";
        if (Number(recSet("usePatchScanSince")) == 1) {
            radioSet += "patchScanSince[0].checked=true; patchScanSince[1].checked=false; ";
        } else {
            radioSet += "patchScanSince[0].checked=false; patchScanSince[1].checked=true; ";
        }
    }
    patchScanMin = Number(recSet("patchScanMin"));
    // convert to hour or day
    patchScanHr = patchScanMin / 60;
    patchScanDay = patchScanHr / 24;
    if (Math.round(patchScanDay) == patchScanDay) {
        patchScanMin = patchScanDay;
        patchScanMinUnit = "Day";
    } else if (Math.round(patchScanHr) == patchScanHr) {
        patchScanMin = patchScanHr;
        patchScanMinUnit = "Hr";
    } else {
        patchScanMinUnit = "Min";
    }

    if (Number(recSet("usePatchRebootPending")) == 0) usePatchRebootPending = "";
    else usePatchRebootPending = "checked";

    if (Number(recSet("usePatchInstallFailures")) == 0) usePatchInstallFailures = "";
    else usePatchInstallFailures = "checked";

    if (Number(recSet("usePatchWuauservFailures")) == 0) usePatchWuauservFailures = "";
    else usePatchWuauservFailures = "checked";

    if (Number(recSet("usePatchTestStatus")) == 0) usePatchTestStatus = "";
    else usePatchTestStatus = "checked";
    patchTestStatus = Number(recSet("patchTestStatus"));

    if (Number(recSet("usePatchAutoUpdateConfig")) == 0) usePatchAutoUpdateConfig = "";
    else usePatchAutoUpdateConfig = "checked";
    patchAutoUpdateConfig = Number(recSet("patchAutoUpdateConfig"));

    if (Number(recSet("usePatchRebootConfig")) == 0) usePatchRebootConfig = "";
    else usePatchRebootConfig = "checked";
    patchRebootConfig = Number(recSet("patchRebootConfig"));

    if (Number(recSet("usePatchFileSrcConfig")) == 0) usePatchFileSrcConfig = "";
    else usePatchFileSrcConfig = "checked";
    patchFileSrcConfig = String(recSet("patchFileSrcConfig"));

    if (Number(recSet("usePatchUnscanned")) == 0) usePatchUnscanned = "";
    else usePatchUnscanned = "checked";

    if (Number(recSet("usePatchFileShare")) == 0) usePatchFileShare = "";
    else usePatchFileShare = "checked";

    if (Number(recSet("usePatchFileShareSet")) == 0) usePatchFileShareSet = "";
    else usePatchFileShareSet = "checked";
    patchFileShareAgentGuid = String(recSet("patchFileShareAgentGuid"));
    if (patchFileShareAgentGuid.length == 0) patchFileShareAgentGuid = null;

    patchFileShareAgentDisplayName = String(recSet("patchFileShareAgentDisplayName"));

    if (Number(recSet("usePatchOnlineScanFail")) == 0) usePatchOnlineScanFail = "";
    else usePatchOnlineScanFail = "checked";

    if (Number(recSet("usePatchMissingKB")) == 0) usePatchMissingKB = "";
    else usePatchMissingKB = "checked";
    patchMissingKB = String(recSet("patchMissingKB"));

    if (Number(recSet("usePatchInstalledKB")) == 0) usePatchInstalledKB = "";
    else usePatchInstalledKB = "checked";
    patchInstalledKB = String(recSet("patchInstalledKB"));

    if (Number(recSet("useWuaDisabled")) == 0) {
        useWuaDisabled = "";
        radioSet += "wuaDisabled[0].checked=true; wuaDisabled[1].checked=false; ";
    } else {
        useWuaDisabled = "checked";
        if (Number(recSet("useWuaDisabled")) == 1) {
            radioSet += "wuaDisabled[0].checked=true; wuaDisabled[1].checked=false; ";
        } else {
            radioSet += "wuaDisabled[0].checked=false; wuaDisabled[1].checked=true; ";
        }
    }

	if (Number(recSet("andMachineLabelsFlag")) == 1) {
		radioSet += "andMachineLabelsFlag[0].checked=true; andMachineLabelsFlag[1].checked=false; ";
	} else {
		radioSet += "andMachineLabelsFlag[0].checked=false; andMachineLabelsFlag[1].checked=true; ";
	}

    if (Number(recSet("advFilter")) == 0) advFilter = "";
    else advFilter = "checked";
    advFilterId = Number(recSet("advFilterId"));
    if (advFilterId == 0) advFilterId = Number(String(Math.random()).substr(2,8));


    if (Number(recSet("useMonsetFilter")) == 0) useMonitorset = "";
    else useMonitorset = "checked";
    useMonitorsetID = Number(recSet("MonsetID"));

   if (Number(recSet("useSNMPsetFilter")) == 0) useSNMPMonitorset = "";
    else useSNMPMonitorset = "checked";
    useSNMPMonitorsetID = Number(recSet("SNMPsetID"));
} else {
    editTitle = "";
    ownerId = sessionAdminId;
    readWrite = 0;
    useMachFil = "";
    overMachFil = "*";
    useGroupFil = "";
    useViewColFil = "";
    useColFil = 0;
    groupIdFil = "";
    if (showCollections == true) {
        radioSet += "showHideCollection[0].checked=true; showHideCollection[1].checked=false; ";
    }
    showCheckin = "";
    radioSet += "checkinStat[0].checked=false; checkinStat[1].checked=true; checkinStat[2].checked=false; setOnlineStat(); ";
    onLineMin = 1;
    onLineMinUnit = "Min";
    showSuspended = "";
    radioSet += "suspendedStat[0].checked=false; suspendedStat[1].checked=true; ";
    showReboot = "";
    radioSet += "rebootStat[0].checked=false; rebootStat[1].checked=true; ";
    rebootMin = 1;
    rebootMinUnit = "Min";
    useAgentCredentialStatus = "";
    agentCredentialStatus = -1;
    useGateway = "";
    onlyGateway = "";
    useIpFil = "";
    ipFil = "";
    useOs = "";
    osType = 0;
    useOsVer = "";
    osVer = "*";
    scriptId = 0;
    scriptName = "";
    useScriptPending = "";
    radioSet += "scriptPending[0].checked=false; scriptPending[1].checked=true; ";
    useScriptResult = "";
    radioSet += "scriptResult[0].checked=false; scriptResult[1].checked=true; ";
    useScriptSince = "";
    radioSet += "scriptSince[0].checked=false; scriptSince[1].checked=true; ";
    scriptMin = 1;
    scriptMinUnit = "Day";
    useAppName = "";
    radioSet += "appContainMiss[0].checked=true; appContainMiss[1].checked=false; ";
    appFilter = "*";
    useAppVer = "";
    radioSet += "verCompare[0].checked=true; verCompare[1].checked=false; verCompare[2].checked=false; verCompare[3].checked=false; ";
    verFilter = "0";
    usePatchFil = "";
    missingPatches = 0;
    usePatchPolicy = "";
    usePatchScanPending = "";
    radioSet += "patchScanPending[0].checked=false; patchScanPending[1].checked=true; ";
    useDefaultPatchScanSource = "";
    radioSet += "defaultPatchScanSource[0].checked=true; defaultPatchScanSource[1].checked=false; ";
	
	radioSet += "andMachineLabelsFlag[0].checked=false; andMachineLabelsFlag[1].checked=true; ";
	
    usePatchScanResult = "";
    radioSet += "patchScanResult[0].checked=false; patchScanResult[1].checked=true; ";
    usePatchScanSince = "";
    radioSet += "patchScanSince[0].checked=false; patchScanSince[1].checked=true; ";
    patchScanMin = 1;
    patchScanMinUnit = "Day";
    usePatchRebootPending = "";
    usePatchInstallFailures = "";
    usePatchWuauservFailures = "";
    usePatchTestStatus = "";
    patchTestStatus = -2;
    usePatchAutoUpdateConfig = "";
    patchAutoUpdateConfig = 0;
    usePatchRebootConfig = "";
    patchRebootConfig = 0;
    usePatchFileSrcConfig = "";
    patchFileSrcConfig = "0,4";
    usePatchUnscanned = "";
    usePatchFileShare = "";
    usePatchFileShareSet = "";
    patchFileShareAgentGuid = "";
    usePatchOnlineScanFail = "";
    usePatchMissingKB = "";
    patchMissingKB = "";
    usePatchInstalledKB = "";
    patchInstalledKB = "";
    useWuaDisabled = "";
    radioSet += "wuaDisabled[0].checked=true; wuaDisabled[1].checked=false; ";

    advFilter = "";
    advFilterId = Number(String(Math.random()).substr(2,8));

    useMonitorset = "";
    useMonitorsetID = 0;
    useSNMPMonitorset = "";
    useSNMPMonitorsetID = 0;

}
recSet.Close();

if (scriptName.length == 0) scriptName = "select agent procedure";
if ((Number(activeViewId) == 0)||
    ((Number(readWrite)!=1)&&(Number(ownerId)!=Number(sessionAdminId)))) {
    shareDisabled = "disabled";
} else {
    shareDisabled = "";
}
%>
<HTML>
<HEAD>
<title>View Definitions</title>
<!-- #include file = "../inc/mainStyle.inc" -->
<script type="text/javascript" src="/inc/ext-3.3.3/ext-base.js"></script>
<link rel="stylesheet" type="text/css" href="/inc/ext-3.3.3/resources/css/ext-all.css" />
<script type="text/javascript" src="/inc/ext-3.3.3/ext-all.js"></script>
<script type="text/javascript" src="/inc/vsapreslib.js"></script>
<!-- #include virtual = "/inc/mainStyle.inc" -->
<style>
<!--
input {font-size: 12 px; font-family : Arial;}
p {text-indent:-23px; padding-left:23px; margin-top:2px; margin-bottom:0px;}
div {width:100%; padding-top:2px;}
.viewButton {width:90px;margin-bottom:4px;}

.toolbarCls{
  background-image: none; background-repeat:repeat-x;
  background-color: #ffffff;
  border-color: transparent;
 }
-->
</style>
</HEAD>
<%
if ((Number(readWrite) == 2)&&(Number(ownerId)!=Number(sessionAdminId))) {
    // execute only for this view. Do not let anyone other than the owner view or edit
%>
<body bgcolor="#FFFFFF">
<table border="0" ID="Table1">
  <tr>
    <td width=80 align='center' valign='middle'>
      <img border="0" src="../images/warning32.gif">
    </td>
    <td align="left">
      <b><%Response.Write(xlate("You do not have rights to view or edit this view",false)+". "+
        xlate("You may only use this view",false))%>.</b>
    </td>
  </tr>
<%
    if (Number(sessionAdminType) == 2) {
%>
  <tr>
    <td>&nbsp;</td>
    <td align="center"><a href="javascript:document.UserForm.submit()"><%Response.Write(xlate("Take Ownership",false))%></a></td>
    <td>&nbsp;</td>
  </tr>
  <form method="post" name="UserForm" ID="Form1">
    <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
    <input type="hidden" name="takeId" value="<%=EncodeHTMLAttribForXSS(activeViewId)%>" ID="Hidden1">
  </form>
<%
    }
%>
</table>
<%
} else {
%>
<script language="javascript">
<!--#include file = "../inc/setSelector.js" -->
var needToSave=<%=needToSave%>;
var errMsg = new String("");

function toggleSection(sectionName) {
    var fsElement = document.getElementById('fs' + sectionName);
    var divElement = document.getElementById('div' + sectionName);
    var chkElement = document.getElementById('chk' + sectionName);
    //alert(chkElement.checked);
    var expand = true;
    if (fsElement.className == 'x-fieldset') expand = false;
    fsElement.className = 'x-fieldset' + (expand ? '' : ' x-panel-collapsed');
    divElement.style.display = (expand ? 'block' : 'none');
}
function checkForm() {
  with (document.UserForm) {
    if ((useGateway.checked)&&(onlyGateway.value.length == 0)) {
        errMsg = "<%Response.Write(xlate("Enter connection gateway IP address",true))%>";
        onlyGateway.focus();
        onlyGateway.select();
        return(false);
    }
    if ((useIpFil.checked)&&(ipFil.value.length == 0)) {
        errMsg = "<%Response.Write(xlate("Fill in the IP address filter",true))%>";
        ipFil.focus();
        ipFil.select();
        return(false);
    }
    if ((useGroupFil.checked)&&(groupIdFil.length == 0)) {
        errMsg = "<%Response.Write(xlate("Select a group ID to filter on",true))%>";
        return(false);
    }
    if (editTitle.value.search(/[\%\'\"\/\\\:\?\<\>\|]/g) >= 0) {
        errMsg = "\%\'\"\/\\\:\?\<\>\| <%Response.Write(xlate("are illegal characters for names",true))%>"; //'
        return(false);
    }
    if (editTitle.value.length == 0) {
        errMsg = "<%Response.Write(xlate("Title is blank",true)+". "+xlate("Enter a name for this view",true))%>.";
        editTitle.focus();
        editTitle.select();
        return(false);
    }
  }
  return(true);
}
function buttonClick(bType) {
// 1: save
// 2: save as
// 3: delete
    needToSave = false;
    document.UserForm.buttonType.value = bType;
    if (Number(bType) == 3) {
        if (confirm("<%Response.Write(xlate("Are you sure you want to permanently delete this view",true)+"?")%>")) {
            document.UserForm.submit();
        }
    } else if (Number(bType) == 2) {
        if (document.UserForm.editTitle.value.length == 0) {
            currViewName = "<%Response.Write(xlate("New View",true))%>";
        } else {
            currViewName = "<%Response.Write(xlate("Copy of",true))%> " + document.UserForm.editTitle.value;
        }
        saveAsViewName = prompt("<%Response.Write(xlate("Please enter new View name",true))%>", currViewName);
        if (String(saveAsViewName).toLowerCase() != "null") {
            document.UserForm.editTitle.disabled = false;
            document.UserForm.editTitle.value = saveAsViewName;
            if (checkForm()) {
                document.UserForm.submit();
            }
        }
    } else if (checkForm()) {
        document.UserForm.submit();
    } else {
        alert(errMsg);
    }
}
function saveChanges() {
    if ((needToSave == true)&&("<%=shareDisabled%>".length == 0)) {
        if (confirm("Save changes first?") == true) {
            if (checkForm() == true) {
                document.UserForm.buttonType.value = 1;
                document.UserForm.submit();
                return(true);
            } else {
                alert(errMsg);
            }
        }
    }
    return(false);
}

function pickScript() {
    searchWin = window.open("/InstallTab/scriptSearch.asp?scriptPick=true","searchWin",
        "dependent,toolbar=no,scrollbars,resizable=yes,width=400,height=288,top=20,left=20");
    searchWin.focus();
}
function showScript() {
    document.UserForm.scriptId.value = document.UserForm.selectScriptId.value;
    document.getElementById("scriptLabel1").innerHTML=document.UserForm.scriptName.value;
    document.getElementById("scriptLabel2").innerHTML=document.UserForm.scriptName.value;
    document.getElementById("scriptLabel3").innerHTML=document.UserForm.scriptName.value;
}
function changeGroup() {
    if (document.UserForm.groupIdFil.value.length == 0) {
        document.UserForm.useGroupFil.checked = false;
    } else {
        document.UserForm.useGroupFil.checked = true;
    }
}
function changeView(ctl) {
    if (needToSave == true) {
        if (confirm("Save changes first?") == true) {
            setSelector("activeViewId",document.UserForm.lastViewId.value);
            if (checkForm() == true) {
                if (document.UserForm.lastViewId.value == 0) {
                    document.UserForm.buttonType.value = 2; // Save As for a new view
                } else {
                    document.UserForm.buttonType.value = 1;
                }
            } else {
                alert(errMsg);
                return(false);
            }
        }
    }
    needToSave = false;
    changeCtlValue(ctl,true);
}
function openAdvanced(filId) {
    viewAdvWin=window.open("/ReportsTab/dataTableFilter.asp?viewFilter="+filId+
        "&viewOnly=<%=shareDisabled%>&"+String(Math.random()).substr(2,6),
        "viewAdvWin","scrollbars,toolbar=no,width=500,height=580,top=30,left=30,resizable=yes");
    document.UserForm.advFilter.checked = true;
    viewAdvWin.focus();
}
function setShare() {
    shareWin = window.open("/InstallTab/scriptShare.asp?itemId=<%=activeViewId%>&shareType=4"+
        "&"+String(Math.random()).substr(2,6),
        "shareWin","dependent,toolbar=no,resizable=yes,width=600,height=500,top=20,left=20");
    shareWin.focus();
}
function setOnlineStat() {
    if (document.UserForm.checkinStat[2].checked == true) {
        document.UserForm.onLineMin.disabled = true;
        document.UserForm.onLineMinUnit.disabled = true;
    } else {
        document.UserForm.onLineMin.disabled = false;
        document.UserForm.onLineMinUnit.disabled = false;
    }
}
function editViewCollection() {
    viewCollectionWin = window.open("collectionPicker.asp?editViewId=<%=activeViewId%>"+
        "&"+String(Math.random()).substr(2,6),
        "viewCollectionWin","dependent,toolbar=no,scrollbars,resizable=yes,width=966,height=700,top=20,left=20");
    viewCollectionWin.focus();
}
function pickMach() {
    machPicWin = window.open("machinePicker.asp","machPicWin",
        "dependent,toolbar=no,scrollbars,resizable=yes,width=380,height=500,top=20,left=20");
    machPicWin.focus();
}
function showMach() {
    if (document.UserForm.machName.value.length == 0) {
        document.getElementById("machLabel").innerHTML = "<%Response.Write(xlate("select a machine",true))%>";
    } else {
        document.getElementById("machLabel").innerHTML = document.UserForm.machName.value;
    }
}
</script>
<body bgcolor="#ffffff" onunload="saveChanges();">
<form method="post" name="UserForm" style="margin-bottom:0px;">
<input type="hidden" name="firstPass" value="true">
<input type="hidden" name="buttonType" value=0>
<!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
<input type="hidden" name="lastViewId" value="<%=EncodeHTMLAttribForXSS(activeViewId)%>">
<input type="hidden" name="scriptId" value="<%=EncodeHTMLAttribForXSS(scriptId)%>">
<input type="hidden" name="selectScriptId" value="<%=EncodeHTMLAttribForXSS(scriptId)%>">
<input type="hidden" name="scriptName" value="<%=EncodeHTMLAttribForXSS(scriptName)%>">
<table width="560px" height="40px" cellspacing="0" cellpadding="0" style="padding-bottom: 5px;">
  <tr class="toolbarCls">
    <td width="510px"><div id="actionIcon"></td>
    <td align="right"><div id="helpIcon"></div><!--a href="javascript:getHelp()"><img border="0" src="/images/help.gif"></a--></td>
  </tr>
</table>

<div style="padding-left: 15">
    <div class="x-form-item">
        <label class="x-form-item-label" style="width: 100px;"><%Response.Write(xlate("Select View",false))%>:</label>
        <div class="x-form-element" style="padding-left: 10px;">
            <select size=1 name="activeViewId" class="small9pt" style="WIDTH:432px"
            onchange="changeView(this);" onmousedown="expandCtlWidth(this)" onblur="resetCtlWidth(this)">
            <option value=0 selected>&lt; <%Response.Write(xlate("New View",true))%> &gt;</option>
                <%
                // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                sql ="SELECT viewId,viewName,shareAll FROM viewDef WHERE adminId=? OR viewId IN (SELECT viewId FROM viewAcl WHERE adminId=? OR adminId = (select adminGroupId from appSession where appSessionId = ?)) "+
                     "OR (shareAll > 0 AND adminId in (select adminId from partnerUser WHERE partitionId = ?))"+
                     " ORDER BY viewName";
                cmd = createAdoCommand(dbConn,sql,adCmdText);
                cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
                cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
                cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@appSessionId", sessionId));
                cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionid", sessionPartition));
                recSet.CursorType = adOpenStatic;
                recSet.Open(cmd);
                while (recSet.EOF == false) {
                    Response.Write("<option value="+EncodeHTMLAttribForXSS(recSet("viewId"))+">"+EncodeHTMLForXSS(recSet("viewName"))+"</option>");
                    recSet.MoveNext();
                }
                recSet.Close();
                %>
          </select>
        </div>
        <div class="x-form-clear-left"></div>
    </div>
    <div class="x-form-item">
        <label class="x-form-item-label" style="width: 100px;"><%Response.Write(xlate("Edit Title",false))%>:</label>
        <div class="x-form-element" style="padding-left: 10px;">
            <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
            <input type="text" name="editTitle" size=80 maxlength=100 value="<%=EncodeHTMLAttribForXSS(editTitle)%>" onclick="javascript:needToSave=true;">
        </div>
        <div class="x-form-clear-left"></div>
    </div>
</div>

<%
var sectionMachineFilterOn = false;
if (useMachFil == "checked" || useGroupFil == "checked" || useViewColFil == "checked") {
    sectionMachineFilterOn = true;
}

var sectionMachineStatusOn = false;
if (showCheckin == "checked" || showSuspended == "checked" || showReboot == "checked"
 || useAgentCredentialStatus == "checked" || useGateway == "checked" || useIpFil == "checked") {
    sectionMachineStatusOn = true;
}

var sectionOSInfoOn = false;
if (useOs == "checked" || useOsVer == "checked") {
    sectionOSInfoOn = true;
}

var sectionAgentProcOn = false;
if (useScriptPending == "checked" || useScriptResult == "checked" || useScriptSince == "checked") {
    sectionAgentProcOn = true;
}

var sectionAppOn = false;
if (useAppName == "checked" || useAppVer == "checked") {
    sectionAppOn = true;
}

var sectionAddOnOn = false;
if (useApp1 == "checked" || useApp2 == "checked" || useApp3 == "checked" || useApp4 == "checked"
   || useApp5 == "checked" || useApp6 == "checked" || useApp7 == "checked" || useApp8 == "checked"
   || useApp9 == "checked" || useApp10 == "checked" || useApp11 == "checked" || useApp12 == "checked"
   || useApp13 == "checked" || useApp14 == "checked" || useApp15 == "checked" || useApp16 == "checked"
   || useApp17 == "checked" || useApp18 == "checked" || useApp19 == "checked" || useApp20 == "checked") {
    sectionAddOnOn = true;
}

var sectionLabelOn = false;
if (useLabel1 == "checked" || useLabel2 == "checked" || useLabel3 == "checked" || useLabel4 == "checked"
   || useLabel5 == "checked" || useLabel6 == "checked" || useLabel7 == "checked" || useLabel8 == "checked"
   || useLabel9 == "checked" || useLabel10 == "checked" || useLabel11 == "checked" || useLabel12 == "checked"
   || useLabel13 == "checked" || useLabel14 == "checked" || useLabel15 == "checked" || useLabel16 == "checked"
   || useLabel17 == "checked" || useLabel18 == "checked" || useLabel19 == "checked" || useLabel20 == "checked"
   || useLabel21 == "checked" || useLabel22 == "checked" || useLabel23 == "checked" || useLabel24 == "checked"
   || useLabel25 == "checked" || useLabel26 == "checked" || useLabel27 == "checked" || useLabel28 == "checked"
   || useLabel29 == "checked" || useLabel30 == "checked" || useLabel31 == "checked" || useLabel32 == "checked"
   || useLabel33 == "checked" || useLabel34 == "checked" || useLabel35 == "checked" || useLabel36 == "checked"
   || useLabel37 == "checked" || useLabel38 == "checked" || useLabel39 == "checked" || useLabel40 == "checked"
   || useLabel41 == "checked" || useLabel42 == "checked" || useLabel43 == "checked" || useLabel44 == "checked"
   || useLabel45 == "checked" || useLabel46 == "checked" || useLabel47 == "checked" || useLabel48 == "checked"
   || useLabel49 == "checked" || useLabel50 == "checked" || useLabel51 == "checked" || useLabel52 == "checked"
   || useLabel53 == "checked" || useLabel54 == "checked" || useLabel55 == "checked") {
    sectionLabelOn = true;
}

var sectionPatchOn = false;
if (useColFil == "checked" || usePatchUnscanned == "checked" || usePatchFil == "checked" || usePatchScanPending == "checked" || useDefaultPatchScanSource == "checked"
   || usePatchScanResult == "checked" || usePatchScanSince == "checked" || usePatchRebootPending == "checked" || usePatchInstallFailures == "checked" || usePatchWuauservFailures == "checked"
   || usePatchTestStatus == "checked" || usePatchAutoUpdateConfig == "checked" || usePatchRebootConfig == "checked" || usePatchFileSrcConfig == "checked" || usePatchMissingKB == "checked"
   || usePatchInstalledKB == "checked" || useWuaDisabled == "checked" || usePatchFileShare == "checked" || usePatchFileShareSet == "checked" || usePatchOnlineScanFail == "checked") {
    sectionPatchOn = true;
}

var sectionAdvancedOn = false;
if (advFilter == "checked") {
    sectionAdvancedOn = true;
}

var sectionMonitorOn = false;
if (useMonitorset == "checked" || useSNMPMonitorset == "checked") {
    sectionMonitorOn = true;
}
%>
<div style="padding-left: 10px;">


<fieldset id="fsMachineFilter" class="x-fieldset<%= (sectionMachineFilterOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="lgMachineFilter" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('MachineFilter');"><span id="ext-gen27" class="x-tool x-tool-toggle"></span></a>
        <span id="ext-gen28" class="x-fieldset-header-text"><%=xlate("Machine Filter", false)%></span></legend>
    <div id="divMachineFilter" class="x-fieldset-bwrap" style="display: <%= (sectionMachineFilterOn ? "block" : "none") %>; padding-left: 5px;">
        <div id="ext-gen558" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <p title="<%Response.Write(xlate("Force the machine ID filter to this setting when selecting this view",true)+". "+xlate("Machine ID may not be editted when using this view",true))%>.">
              <input type="checkbox" name="useMachFil" value="checked" <%=useMachFil%> onclick="javascript:needToSave=true;">
              <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
              <%Response.Write(xlate("Set machine ID",false))%> <input type="text" size=15 name="overMachFil" value="<%=EncodeHTMLAttribForXSS(overMachFil)%>"
                onchange="document.UserForm.useMachFil.checked=true;needToSave=true;">
            </p>
            <p title="<%Response.Write(xlate("Force the group ID filter to this setting when selecting this view",true)+". "+xlate("Group ID may not be edited when using this view",true))%>.">
              <input type="checkbox" name="useGroupFil" value="checked" <%=useGroupFil%> onclick="javascript:needToSave=true;">
              <%Response.Write(xlate("Set group ID",false))%>
            <select size="1" name="groupIdFil" class="small9pt" style="width:168px;"
                onchange="document.UserForm.useGroupFil.checked=true; changeCtlValue(this,false); needToSave=true;" onmousedown="expandCtlWidth(this)" onblur="resetCtlWidth(this)">
            <option value=''>&lt; <%Response.Write(xlate("Select Group ID",true))%> &gt;</option>
            <option value='*'>&lt; <%Response.Write(xlate("All Groups",true))%> &gt;</option>
            <%  //get all the group names to load into the drop down control
            var recSet = Server.CreateObject("ADODB.Recordset");
            // Variable Declaration To Implement groupSqlCmd() 
            var theGrpXObject = null;
            var theGrpXCmd = null;
            theGrpXObject = groupSqlCmd();
            theGrpXCmd = createAdoCommand(dbConn, theGrpXObject.SqlQuery, adCmdText);
            theGrpXCmd = decorateAdoCommand(theGrpXCmd, theGrpXObject.ParamCollection);
            recSet.CursorType = adOpenStatic;
            recSet.Open(theGrpXCmd);
            while (recSet.EOF == false) {
                theGroupId = String(recSet("groupId"));
                Response.Write("<option value='"+EncodeHTMLAttribForXSS(theGroupId)+"'");
                if (String(theGroupId) == groupIdFil) Response.Write(" selected");
                Response.Write(">"+EncodeHTMLForXSS(theGroupId)+"</option>");
                recSet.MoveNext();
            }
            recSet.Close();
            %>
            </select>
            </p>
            <p title="<%Response.Write(xlate("Restict this view to only show data from selected machines",true)+".")%>.">
              <input type="checkbox" name="useViewColFil" value="checked" <%=useViewColFil%> ID="Checkbox4" onclick="javascript:needToSave=true;">
              <%Response.Write(xlate("Only show selected machine IDs",false))%>&nbsp;&nbsp;
            <%
            if (Number(activeViewId) > 0) {
                // remove any agentGuids that were deleted but the system has not cleaned the db yet.
                dbConn.Execute("DELETE FROM viewCollection WHERE agentGuid IN "+
                    "(SELECT v.agentGuid FROM viewCollection v LEFT OUTER JOIN machNameTab m "+
                    "ON v.agentGuid=m.agentGuid WHERE m.agentGuid IS NULL)",0,128);
                // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                sql ="SELECT COUNT(*) FROM viewCollection WHERE viewId=?";
                cmd = createAdoCommand(dbConn,sql,adCmdText);
                cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@viewId", activeViewId));
                recSet.CursorType = adOpenStatic;
                recSet.Open(cmd);
                memberCnt = Number(recSet(0));
                recSet.Close();
            %>
            <a href="javascript:editViewCollection()" title="<%Response.Write(xlate("Click to select machines for a view collection",true))%>"
               onclick="javascript:needToSave=true;"><%Response.Write("<span id='memberCnt'>"+memberCnt+"</span>&nbsp;"+xlate("machines selected",true))%></a>
            </p>
            <%
            } else {
                Response.Write("&nbsp;&nbsp;&nbsp;<i>"+xlate("Save view before assigning machines",true)+"</i>");
            }
            %>
        </div>
    </div>
</fieldset>
<fieldset id="fsMachineStatus" class="x-fieldset<%= (sectionMachineStatusOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="lgMachineStatus" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('MachineStatus');"><span id="ext-gen27" class="x-tool x-tool-toggle"></span></a>
        <span id="Span5" class="x-fieldset-header-text"><%=xlate("Machine Status", false)%></span>
    </legend>
    <div id="divMachineStatus" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div2" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <p title="<%Response.Write(xlate("List machines that have or have not checked into the server within the specified period of time",true))%>.">
            <input type="checkbox" name="showCheckin" value="checked" <%=showCheckin%> onclick="javascript:needToSave=true;">
            <%Response.Write(xlate("Show machines that",false))%>&nbsp;
            <input type="radio" name="checkinStat" value="0" onclick="setOnlineStat();needToSave=true;">&nbsp;<b><%Response.Write(xlate("have",false))%></b>&nbsp;&nbsp;
            <input type="radio" name="checkinStat" value="1" onclick="setOnlineStat();needToSave=true;">&nbsp;<b><%Response.Write(xlate("have not",false))%></b>&nbsp;&nbsp;
            <input type="radio" name="checkinStat" value="2" onclick="setOnlineStat();needToSave=true;">&nbsp;<b><%Response.Write(xlate("have never",false))%></b>
            <br><%Response.Write(xlate("been online in the last",false))%>&nbsp;&nbsp;<input type="text" name="onLineMin" value="<%=onLineMin%>" size=2>
            <select size=1 name="onLineMinUnit" class="small9pt" onchange="javascript:needToSave=true;">
            <option value="Min"><%Response.Write(xlate("Min",true))%></option>
            <option value="Hr"><%Response.Write(xlate("Hr",true))%></option>
            <option value="Day"><%Response.Write(xlate("Day",true))%></option>
            </select>
        </p>
            <p title="<%Response.Write(xlate("List machines that currently are suspended or not suspended",true))%>.">
            <input type="checkbox" name="showSuspended" value="checked" <%=showSuspended%> onclick="javascript:needToSave=true;"> <%Response.Write(xlate("Show machines that are",false))%>&nbsp;
            <input type="radio" name="suspendedStat" value=0 ID="Radio10" onclick="javascript:needToSave=true;">&nbsp;<b><%Response.Write(xlate("suspended",false))%></b>&nbsp;&nbsp;
            <input type="radio" name="suspendedStat" value=1 ID="Radio11" onclick="javascript:needToSave=true;">&nbsp;<b><%Response.Write(xlate("not suspended",false))%></b>
        </p>
            <p title="<%Response.Write(xlate("List machines that have or have not rebooted within the specified period of time",true))%>.">
                <input type="checkbox" name="showReboot" value="checked" <%=showReboot%> ID="Checkbox1" onclick="javascript:needToSave=true;">
                <%Response.Write(xlate("Show machines that",false))%>&nbsp;
                <input type="radio" name="rebootStat" value="0" ID="Radio1" onclick="javascript:needToSave=true;">&nbsp;<b><%Response.Write(xlate("have",false))%></b>&nbsp;&nbsp;
                <input type="radio" name="rebootStat" value="1" ID="Radio2" onclick="javascript:needToSave=true;">&nbsp;<b><%Response.Write(xlate("have not",false))%></b>
                <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
                <br><%Response.Write(xlate("rebooted in the last",false))%>&nbsp;&nbsp;<input type="text" name="rebootMin" value="<%=EncodeHTMLAttribForXSS(rebootMin)%>" size=2 ID="Text1">
                <select size=1 name="rebootMinUnit" class="small9pt" ID="Select1" onchange="javascript:needToSave=true;">
                <option value="Min"><%Response.Write(xlate("Min",true))%></option>
                <option value="Hr"><%Response.Write(xlate("Hr",true))%></option>
                <option value="Day"><%Response.Write(xlate("Day",true))%></option>
                </select>
            </p>
            <p title="<%Response.Write(xlate("List machines that have a specific Credential status",true))%>.">
                <input type="checkbox" name="useAgentCredentialStatus" value="checked" <%=useAgentCredentialStatus%> onclick="javascript:needToSave=true;">
                <%Response.Write(xlate("Machines with Credential status",false))%>
                <select size=1 name="agentCredentialStatus" class="small9pt" onchange="document.UserForm.useAgentCredentialStatus.checked=true;needToSave=true;">
                <option value=-1><%Response.Write(xlate("Missing Credential",true))%></option>
                <option value=0><%Response.Write(xlate("Credential Not Tested",true))%></option>
                <option value=1><%Response.Write(xlate("Credential Test Failed",true))%></option>
                <option value=2><%Response.Write(xlate("Credential Test Passed",true))%></option>
                </select>
            </p>
            <p title="<%Response.Write(xlate("List machines whose connection gateway address match this filter",true)+". "+xlate("Use * as a wildcard",true))%>.">
                <input type="checkbox" name="useGateway" value="checked" <%=useGateway%> onclick="javascript:needToSave=true;">
                <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
                <%Response.Write(xlate("Connection gateway filter",false))%> <input type="text" size=12 name="onlyGateway" value="<%=EncodeHTMLAttribForXSS(onlyGateway)%>"
                onchange="document.UserForm.useGateway.checked=true;needToSave=true;">
            </p>
            <p title="<%Response.Write(xlate("List machines whose IP address match this filter",true)+". "+xlate("Use * as a wildcard",true)+". "+xlate("For instance: 192.168.* displays all machines in the class C private network space 192.168.0.0 through 192.168.255.255",true))%>">
                <input type="checkbox" name="useIpFil" value="checked" <%=useIpFil%> onclick="javascript:needToSave=true;">
                <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
                <%Response.Write(xlate("IP address filter",false))%> <input type="text" size=12 name="ipFil" value="<%=EncodeHTMLAttribForXSS(ipFil)%>"
                onchange="document.UserForm.useIpFil.checked=true;needToSave=true;">
            </p>
        </div>
    </div>
</fieldset>
<fieldset id="fsOSInfo" class="x-fieldset<%= (sectionOSInfoOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="lgOSInfo" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('OSInfo');"><span id="ext-gen27" class="x-tool x-tool-toggle"></span></a>
        <span id="Span7" class="x-fieldset-header-text"><%=xlate("OS Info", false)%></span>
    </legend>
    <div id="divOSInfo" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div3" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <p title="<%Response.Write(xlate("List all machines running the selected operating system",true))%>.">
            <input type="checkbox" name="useOs" value="checked" <%=useOs%>> <%Response.Write(xlate("OS Type",false))%>
                <select size=1 name="osType" class="small9pt" onchange="document.UserForm.useOs.checked=true">
                    <option value=0>&lt; <%Response.Write(xlate("Select Type",true))%> &gt;</option>
                    <option value=13><%Response.Write(xlate("Mac OS X",true))%></option>
                    <option value=17><%Response.Write(xlate("Linux",true))%></option>
                    <option value=14><%Response.Write(xlate("All Windows Operating Systems",true))%></option>
                    <option value=10><%Response.Write(xlate("All Workstations",true))%></option>
                    <option value=11><%Response.Write(xlate("All Servers",true))%></option>
					<option value=23>Windows Server 2019</option>
                    <option value=22>Windows Server 2016</option>
                    <option value=19>Windows Server 2012</option>
                    <option value=15>Windows Server 2008</option>
                    <option value=9>Windows Server 2003</option>
					<option value=21>Windows 10</option>
					<option value=20>Windows 8.1</option>
                    <option value=18>Windows 8</option>
                    <option value=16>Windows 7</option>
                    <option value=12>Windows Vista</option>
                    <option value=8>Windows XP</option>
                    <option value=3>Windows 2000</option>
                    <option value=4>Windows NT4</option>
                    <option value=1>Windows NT4 / 2000 / XP / Vista / 2003 / 2008 / 2012 / 7 / 8 / 8.1 / 10 / 2016 / 2019</option>
                    <option value=2>Windows 95 / 98 / Me</option>
                    <option value=5>Windows Me</option>
                    <option value=6>Windows 98</option>
                    <option value=7>Windows 95</option>
                </select>
            </p>
            <p title="<%Response.Write(xlate("List machines matching the operating system version string filter. Use * for wildcard. The Name/OS Info function under the Audit tab lists the OS version string. Use this filter to find all machines running a particular service pack.",true))%>">
                <input type="checkbox" name="useOsVer" value="checked" <%=useOsVer%>>
                <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
                <%Response.Write(xlate("OS version filter",false))%> <input type="text" name="osVer" value="<%=EncodeHTMLAttribForXSS(osVer)%>" style="width:300px"
                onchange="document.UserForm.useOsVer.checked=true">
            </p>
        </div>
    </div>
</fieldset>
<fieldset id="fsAgentProc" class="x-fieldset<%= (sectionAgentProcOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="lgAgentProc" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('AgentProc');"><span id="Span11" class="x-tool x-tool-toggle"></span></a>
        <span id="spAgentProc" class="x-fieldset-header-text"><%=xlate("Agent Procedure", false)%></span>
    </legend>
    <div id="divAgentProc" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div6" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <p title="<%Response.Write(xlate("List machines that currently have the specified agent procedure scheduled or not",true)+". "+xlate("Select the script by clicking the 'select agent procedure' link",true))%>.">
              <input type="checkbox" name="useScriptPending" value="checked" <%=useScriptPending%> onclick="javascript:needToSave=true;">
              <%Response.Write(xlate("With agent procedure",false))%> <a href='javascript:pickScript()'><span id='scriptLabel1'></span></a>&nbsp;&nbsp;
              <b><input type="radio" name="scriptPending" value=1 onclick="javascript:needToSave=true;">&nbsp;<%Response.Write(xlate("scheduled",false))%>&nbsp;&nbsp;
              <input type="radio" name="scriptPending" value=2 onclick="javascript:needToSave=true;">&nbsp;<%Response.Write(xlate("not scheduled",false))%></b>
            </p>
            <p title="<%Response.Write(xlate("List machines that have run the specified agent procedure at least once and whose result was either success or failure",true)+". "+xlate("Select the agent procedure by clicking the 'select agent procedure' link",true))%>.">
              <input type="checkbox" name="useScriptResult" value="checked" <%=useScriptResult%> onclick="javascript:needToSave=true;">
              <%Response.Write(xlate("Last execution status for",false))%> <a href='javascript:pickScript()'><span id='scriptLabel2'></span></a>&nbsp;&nbsp;
              <b><input type="radio" name="scriptResult" value=1 onclick="javascript:needToSave=true;">&nbsp;<%Response.Write(xlate("success",false))%>&nbsp;&nbsp;
              <input type="radio" name="scriptResult" value=2 onclick="javascript:needToSave=true;">&nbsp;<%Response.Write(xlate("failed",false))%></b>
            </p>
            <p title="<%Response.Write(xlate("List machines that have or have not executed the specified script in the given period of time",true)+". "+xlate("Select the script by clicking the 'select agent procedure' link",true))%>.">
              <input type="checkbox" name="useScriptSince" value="checked" <%=useScriptSince%> onclick="javascript:needToSave=true;">
              <%Response.Write(xlate("Agent Procedure",false))%> <a href='javascript:pickScript()'><span id='scriptLabel3'></span></a>&nbsp;&nbsp;
              <b><input type="radio" name="scriptSince" value=1 onclick="javascript:needToSave=true;">&nbsp;<%Response.Write(xlate("has",false))%>&nbsp;&nbsp;
              <input type="radio" name="scriptSince" value=2 onclick="javascript:needToSave=true;">&nbsp;<%Response.Write(xlate("has not",false))%></b>
              <br><%Response.Write(xlate("executed in the last",false))%>&nbsp;&nbsp;<input type="text" name="scriptMin" value="<%=EncodeHTMLAttribForXSS(scriptMin)%>" size=2>
              <select size=1 name="scriptMinUnit" class="small9pt" onchange="javascript:needToSave=true;">
                <option value="Min"><%Response.Write(xlate("Min",true))%></option>
                <option value="Hr"><%Response.Write(xlate("Hr",true))%></option>
                <option value="Day"><%Response.Write(xlate("Day",true))%></option>
              </select>
            </p>
        </div>
    </div>
</fieldset>
<fieldset id="fsApp" class="x-fieldset<%= (sectionAppOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="Legend1" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('App');"><span id="Span6" class="x-tool x-tool-toggle"></span></a>
        <span id="Span1" class="x-fieldset-header-text"><%=xlate("Applications", false)%></span>
    </legend>
    <div id="divApp" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div4" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <p title="<%Response.Write(xlate("List machines containing or missing applications matching the filter",true)+". "+xlate("Use * for wildcard",true)+". "+xlate("Use this view to find all machines containing an application",true))%>.">
              <input type="checkbox" name="useAppName" value="checked" <%=useAppName%> ID="Checkbox2" onclick="javascript:needToSave=true;">
              <input type="radio" name="appContainMiss" value=1 ID="Radio3" onclick="javascript:needToSave=true;">&nbsp;<b><%Response.Write(xlate("Contains",false))%></b>
              <input type="radio" name="appContainMiss" value=2 ID="Radio4" onclick="javascript:needToSave=true;">&nbsp;<b><%Response.Write(xlate("Missing",false))%></b>
              <%Response.Write(xlate("application",false))%> <input type="text" name="appFilter" value="<%=appFilter%>" style="width:160px"
                onchange="document.UserForm.useAppName.checked=true;needToSave=true;" ID="Text2">
            </p>
            <p title="<%Response.Write(xlate("List machines with applications matching the application filter AND whose application version string is greater than or less than or equal to the specified string",true)+". \r\n"+
               xlate("NOTE: This is a string, NOT a number, so the compare is in alphabetical order",true))%>.">
              <input type="checkbox" name="useAppVer" value="checked" <%=useAppVer%> style="margin-left:24px;" onclick="javascript:needToSave=true;">
              <%Response.Write(xlate("Version string is",false))%>
              <input type="radio" name="verCompare" value=1 ID="Radio5" onclick="javascript:needToSave=true;">&nbsp;<b>&gt;</b>&nbsp;&nbsp;
              <input type="radio" name="verCompare" value=2 ID="Radio6" onclick="javascript:needToSave=true;">&nbsp;<b>&lt;</b>&nbsp;&nbsp;
              <input type="radio" name="verCompare" value=3 ID="Radio7" onclick="javascript:needToSave=true;">&nbsp;<b>=</b>&nbsp;&nbsp;
              <input type="radio" name="verCompare" value=4 ID="Radio9" onclick="javascript:needToSave=true;">&nbsp;<b>Like</b>
              <input type="text" name="verFilter" value="<%=EncodeHTMLAttribForXSS(verFilter)%>" style="width:100px"
                onchange="document.UserForm.useAppVer.checked=true;needToSave=true;" ID="Text3">
            </p>
        </div>
    </div>
</fieldset>
<%
if(appsCount > 0) {
%>
<fieldset id="fsAddOn" class="x-fieldset<%= (sectionAddOnOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="Legend2" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('AddOn');"><span id="Span8" class="x-tool x-tool-toggle"></span></a>
        <span id="Span2" class="x-fieldset-header-text"><%=xlate("Add-On Modules", false)%></span>
    </legend>
    <div id="divAddOn" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div5" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <% Response.Write(xlate("Show machines with the following modules installed",false)); %>
            <%for(i = 0;i < appsCount; i++) {
                  if(i == 0) { %>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp1" value="checked" <%=useApp1%>><%
                    } else if (i == 1) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp2" value="checked" <%=useApp2%>><%
                    } else if (i == 2) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp3" value="checked" <%=useApp3%>><%
                    } else if (i == 3) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp4" value="checked" <%=useApp4%>><%
                    } else if (i == 4) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp5" value="checked" <%=useApp5%>><%
                    } else if (i == 5) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp6" value="checked" <%=useApp6%>><%
                    } else if (i == 6) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp7" value="checked" <%=useApp7%>><%
                    } else if (i == 7) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp8" value="checked" <%=useApp8%>><%
                    } else if (i == 8) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp9" value="checked" <%=useApp9%>><%
                    } else if (i == 9) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp10" value="checked" <%=useApp10%>><%
                    } else if (i == 10) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp11" value="checked" <%=useApp11%>><%
                    } else if (i == 11) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp12" value="checked" <%=useApp12%>><%
                    } else if (i == 12) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp13" value="checked" <%=useApp13%>><%
                    } else if (i == 13) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp14" value="checked" <%=useApp14%>><%
                    } else if (i == 14) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp15" value="checked" <%=useApp15%>><%
                    } else if (i == 15) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp16" value="checked" <%=useApp16%>><%
                    } else if (i == 16) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp17" value="checked" <%=useApp17%>><%
                    } else if (i == 17) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp18" value="checked" <%=useApp18%>><%
                    } else if (i == 18) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp19" value="checked" <%=useApp19%>><%
                    } else if (i == 19) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useApp20" value="checked" <%=useApp20%>><%
                    }
                    Response.Write("&nbsp;"+xlate(appArrayStr[i],false));
                }
                %>
        </div>
    </div>
</fieldset><%
} %>
<%
if(labelsCount > 0) {
%>
<fieldset id="fsLabel" class="x-fieldset<%= (sectionLabelOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="Legend4" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('Label');"><span id="Span12" class="x-tool x-tool-toggle"></span></a>
        <span id="Span13" class="x-fieldset-header-text"><%=xlate("Label", false)%></span>
    </legend>
    <div id="divLabel" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div8" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <% Response.Write(xlate("Show machines with ",false)); %>
              <b><input type="radio" onclick="javascript:needToSave=true;" name="andMachineLabelsFlag" value=1>&nbsp;<%Response.Write(xlate("all",false))%>&nbsp;
              <input type="radio" onclick="javascript:needToSave=true;" name="andMachineLabelsFlag" value=2>&nbsp;<%Response.Write(xlate("any ",false))%></b>
            <% Response.Write(xlate("of the following labels",false)); %>
            <br />
            <%for(i = 0;i < labelsCount; i++) {
                  if(i == 0) { %>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel1" value="checked" <%=useLabel1%>><%
                    } else if (i == 1) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel2" value="checked" <%=useLabel2%>><%
                    } else if (i == 2) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel3" value="checked" <%=useLabel3%>><%
                    } else if (i == 3) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel4" value="checked" <%=useLabel4%>><%
                    } else if (i == 4) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel5" value="checked" <%=useLabel5%>><%
                    } else if (i == 5) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel6" value="checked" <%=useLabel6%>><%
                    } else if (i == 6) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel7" value="checked" <%=useLabel7%>><%
                    } else if (i == 7) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel8" value="checked" <%=useLabel8%>><%
                    } else if (i == 8) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel9" value="checked" <%=useLabel9%>><%
                    } else if (i == 9) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel10" value="checked" <%=useLabel10%>><%
                    } else if (i == 10) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel11" value="checked" <%=useLabel11%>><%
                    } else if (i == 11) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel12" value="checked" <%=useLabel12%>><%
                    } else if (i == 12) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel13" value="checked" <%=useLabel13%>><%
                    } else if (i == 13) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel14" value="checked" <%=useLabel14%>><%
                    } else if (i == 14) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel15" value="checked" <%=useLabel15%>><%
                    } else if (i == 15) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel16" value="checked" <%=useLabel16%>><%
                    } else if (i == 16) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel17" value="checked" <%=useLabel17%>><%
                    } else if (i == 17) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel18" value="checked" <%=useLabel18%>><%
                    } else if (i == 18) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel19" value="checked" <%=useLabel19%>><%
                    } else if (i == 19) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel20" value="checked" <%=useLabel20%>><%
                    } else if (i == 20) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel21" value="checked" <%=useLabel21%>><%
                    } else if (i == 21) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel22" value="checked" <%=useLabel22%>><%
                    } else if (i == 22) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel23" value="checked" <%=useLabel23%>><%
                    } else if (i == 23) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel24" value="checked" <%=useLabel24%>><%
                    } else if (i == 24) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel25" value="checked" <%=useLabel25%>><%
                    } else if (i == 25) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel26" value="checked" <%=useLabel26%>><%
                    } else if (i == 26) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel27" value="checked" <%=useLabel27%>><%
                    } else if (i == 27) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel28" value="checked" <%=useLabel28%>><%
                    } else if (i == 28) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel29" value="checked" <%=useLabel29%>><%
                    } else if (i == 29) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel30" value="checked" <%=useLabel30%>><%
                    } else if (i == 30) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel31" value="checked" <%=useLabel31%>><%
                    } else if (i == 31) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel32" value="checked" <%=useLabel32%>><%
                    } else if (i == 32) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel33" value="checked" <%=useLabel33%>><%
                    } else if (i == 33) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel34" value="checked" <%=useLabel34%>><%
                    } else if (i == 34) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel35" value="checked" <%=useLabel35%>><%
                    } else if (i == 35) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel36" value="checked" <%=useLabel36%>><%
                    } else if (i == 36) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel37" value="checked" <%=useLabel37%>><%
                    } else if (i == 37) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel38" value="checked" <%=useLabel38%>><%
                    } else if (i == 38) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel39" value="checked" <%=useLabel39%>><%
                    } else if (i == 39) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel40" value="checked" <%=useLabel40%>><%
                    } else if (i == 40) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel41" value="checked" <%=useLabel41%>><%
                    } else if (i == 41) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel42" value="checked" <%=useLabel42%>><%
                    } else if (i == 42) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel43" value="checked" <%=useLabel43%>><%
                    } else if (i == 43) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel44" value="checked" <%=useLabel44%>><%
                    } else if (i == 44) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel45" value="checked" <%=useLabel45%>><%
                    } else if (i == 45) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel46" value="checked" <%=useLabel46%>><%
                    } else if (i == 46) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel47" value="checked" <%=useLabel47%>><%
                    } else if (i == 47) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel48" value="checked" <%=useLabel48%>><%
                    } else if (i == 48) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel49" value="checked" <%=useLabel49%>><%
                    } else if (i == 49) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel50" value="checked" <%=useLabel50%>><%
                    } else if (i == 50) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel51" value="checked" <%=useLabel51%>><%
                    } else if (i == 51) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel52" value="checked" <%=useLabel52%>><%
                    } else if (i == 52) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel53" value="checked" <%=useLabel53%>><%
                    } else if (i == 53) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel54" value="checked" <%=useLabel54%>><%
                    } else if (i == 54) {%>
                  <br /><input type="checkbox" onclick="javascript:needToSave=true;" name="useLabel55" value="checked" <%=useLabel55%>><%
                    }
                    Response.Write("&nbsp;"+xlate(labelArrayStr[i],false));
                }
                %>
        </div>
    </div>
</fieldset><%
} %>
<fieldset id="fsPatch" class="x-fieldset<%= (sectionPatchOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="Legend3" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('Patch');"><span id="Span9" class="x-tool x-tool-toggle"></span></a>
        <span id="Span3" class="x-fieldset-header-text"><%=xlate("Patch Management", false)%></span>
    </legend>
    <div id="divPatch" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div7" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <%if (showCollections == true) { %>
            <p title="<%Response.Write(xlate("Only show machines from this patch policy that match the machine ID and group ID filters",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="useColFil" value="checked" <%=useColFil%>>
              <input type="radio" onclick="javascript:needToSave=true;" name="showHideCollection" value="0">&nbsp;<b><%Response.Write(xlate("Show",false))%></b>&nbsp;&nbsp;
              <input type="radio" onclick="javascript:needToSave=true;" name="showHideCollection" value="1">&nbsp;<b><%Response.Write(xlate("Hide",false))%></b>&nbsp;&nbsp;
              <%Response.Write(xlate("members of patch policy",false))%>
            <select size="1" name="colIdFil" class="small9pt" style="width:210px;"
                onchange="document.UserForm.useColFil.checked=true; changeCtlValue(this,false); needToSave=true;" onmousedown="expandCtlWidth(this)" onblur="resetCtlWidth(this)">
                    <option value='0'>&lt; <%Response.Write(xlate("unassigned machines",true))%> &gt;</option>
            <!-- #include virtual = "/PatchTab/patchPolicySql.inc" -->
            <%
            recSet.CursorType = adOpenStatic;
            recSet.Open(cmdpatchPolicySql);
            while (recSet.EOF == false) {
                Response.Write("<option value='"+EncodeHTMLAttribForXSS(String(recSet("collectionId")))+"'>"+
                    EncodeHTMLForXSS(String(recSet("collectionName")))+"</option>");
                recSet.MoveNext();
            }
            recSet.Close();
            %>
            </select>
            </p>
            <% } %>
            <p title="<%Response.Write(xlate("List machines that have not been scanned for missing patches",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchUnscanned" value="checked" <%=usePatchUnscanned%>>
              <%Response.Write(xlate("Machines that have no patch scan results (unscanned)",false))%>
            </p>
            <p>
              <span title="<%Response.Write(xlate("List machines with a minimum number of missing patches",false))%>.">
                  <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchFil" value="checked" <%=usePatchFil%>>
                  <%Response.Write(xlate("Machines missing greater than or equal to",true))%>
                  <input type="text" name="missingPatches" value="<%=EncodeHTMLAttribForXSS(missingPatches)%>" maxlength="3" style="width:30px" onchange="document.UserForm.usePatchFil.checked=true;needToSave=true;">
                  <%Response.Write(xlate("patches",true))%>.&nbsp;&nbsp;(
              </span>
              <span title="<%Response.Write(xlate("List machines with a minimum number of missing approved patches according to patch approval policies",false))%>.">
                  <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchPolicy" value="checked" <%=usePatchPolicy%>>
                  <%Response.Write(xlate("Use Patch Policy",true))%>&nbsp;)
              </span>
            </p>
            <p title="<%Response.Write(xlate("List machines that currently have a patch scan scheduled or not",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchScanPending" value="checked" <%=usePatchScanPending%>>
              <%Response.Write(xlate("Patch scan",false))%>
              <b><input type="radio" onclick="javascript:needToSave=true;" name="patchScanPending" value=1>&nbsp;<%Response.Write(xlate("scheduled",false))%>&nbsp;&nbsp;
              <input type="radio" onclick="javascript:needToSave=true;" name="patchScanPending" value=2>&nbsp;<%Response.Write(xlate("not scheduled",false))%></b>
            </p>
            <p title="<%Response.Write(xlate("List machines based on default patch scan source (offline vs online)",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="useDefaultPatchScanSource" value="checked" <%=useDefaultPatchScanSource%>>
              <%Response.Write(xlate("Default patch scan source",false))%>
              <b><input type="radio" onclick="javascript:needToSave=true;" name="defaultPatchScanSource" value=1>&nbsp;<%Response.Write(xlate("Offline",false))%>&nbsp;&nbsp;
              <input type="radio" onclick="javascript:needToSave=true;" name="defaultPatchScanSource" value=2>&nbsp;<%Response.Write(xlate("Online",false))%></b>
            </p>
            <p title="<%Response.Write(xlate("List machines that have run a patch scan at least once and whose result was either success or failure",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchScanResult" value="checked" <%=usePatchScanResult%>>
              <%Response.Write(xlate("Last execution status for patch scan",false))%>&nbsp;&nbsp;
              <b><input type="radio" onclick="javascript:needToSave=true;" name="patchScanResult" value=1>&nbsp;<%Response.Write(xlate("success",false))%>&nbsp;&nbsp;
              <input type="radio" onclick="javascript:needToSave=true;" name="patchScanResult" value=2>&nbsp;<%Response.Write(xlate("failed",false))%></b>
            </p>
            <p title="<%Response.Write(xlate("List machines that have or have not executed a patch scan in the given period of time",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchScanSince" value="checked" <%=usePatchScanSince%>>
              <%Response.Write(xlate("Patch scan",false))%>
              <b><input type="radio" onclick="javascript:needToSave=true;" name="patchScanSince" value=1>&nbsp;<%Response.Write(xlate("has",false))%>&nbsp;&nbsp;
              <input type="radio" onclick="javascript:needToSave=true;" name="patchScanSince" value=2>&nbsp;<%Response.Write(xlate("has not",false))%></b>&nbsp;&nbsp;
              <!-- XSS-SCRUB # Prince # Encoded Input To Avoid Cross-Site Scripting Injection-->
              <%Response.Write(xlate("executed in the last",false))%> <input type="text" name="patchScanMin" value="<%=EncodeHTMLAttribForXSS(patchScanMin)%>" size=2 onchange="javascript:needToSave=true;">
              <select size=1 name="patchScanMinUnit" class="small9pt">
                <option value="Min"><%Response.Write(xlate("Min",true))%></option>
                <option value="Hr"><%Response.Write(xlate("Hr",true))%></option>
                <option value="Day"><%Response.Write(xlate("Day",true))%></option>
              </select>
            </p>
            <p title="<%Response.Write(xlate("List machines that have Reboot Pending for patch installations",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchRebootPending" value="checked" <%=usePatchRebootPending%>>
              <%Response.Write(xlate("Machines with Reboot Pending for patch installations",false))%>
            </p>
            <p title="<%Response.Write(xlate("List machines that have patch installation failures",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchInstallFailures" value="checked" <%=usePatchInstallFailures%>>
              <%Response.Write(xlate("Machines with patch installation failures",false))%>
            </p>
            <p title="<%Response.Write(xlate("List machines that have Windows service WUAUSERV not running",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchWuauservFailures" value="checked" <%=usePatchWuauservFailures%>>
              <%Response.Write(xlate("Machines with Windows service WUAUSERV not running",false))%>
            </p>
            <p title="<%Response.Write(xlate("List machines that have a specific Patch Test Result",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchTestStatus" value="checked" <%=usePatchTestStatus%>>
              <%Response.Write(xlate("Machines with Patch Test Result",false))%>
              <select size=1 name="patchTestStatus" class="small9pt" onchange="document.UserForm.usePatchTestStatus.checked=true;needToSave=true;">
                <option value=-2><%Response.Write(xlate("Pending",true))%></option>
                <option value=-1><%Response.Write(xlate("Untested",true))%></option>
                <option value=0><%Response.Write(xlate("Passed",true))%></option>
                <option value=1><%Response.Write(xlate("Failed-All",true))%></option>
                <option value=2><%Response.Write(xlate("Failed-Credential",true))%></option>
                <option value=3><%Response.Write(xlate("Failed-Other",true))%></option>
              </select>
            </p>
            <p title="<%Response.Write(xlate("List machines that have a specific Automatic Update configuration",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchAutoUpdateConfig" value="checked" <%=usePatchAutoUpdateConfig%>>
              <%Response.Write(xlate("Machines with Patch Automatic Update configuration",false))%>
              <select size=1 name="patchAutoUpdateConfig" class="small9pt" onchange="document.UserForm.usePatchAutoUpdateConfig.checked=true;needToSave=true;">
                <option value=0><%Response.Write(xlate("None",true))%></option>
                <option value=1><%Response.Write(xlate("Daily",true))%></option>
                <option value=2><%Response.Write(xlate("Weekly",true))%></option>
                <option value=3><%Response.Write(xlate("Monthly",true))%></option>
                <option value=4><%Response.Write(xlate("Run Once",true))%></option>
              </select>
            </p>
            <p title="<%Response.Write(xlate("List machines that have a specific Patch Reboot Action configuration",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchRebootConfig" value="checked" <%=usePatchRebootConfig%>>
              <%Response.Write(xlate("Machines with Patch Reboot Action configuration",false))%>
              <select size=1 name="patchRebootConfig" class="small9pt" onchange="document.UserForm.usePatchRebootConfig.checked=true;needToSave=true;">
                <option value=0><%Response.Write(xlate("Reboot Immediately",true))%></option>
                <option value=6><%Response.Write(xlate("Reboot at Time",true))%></option>
                <option value=4><%Response.Write(xlate("Warn User",true))%></option>
                <option value=5><%Response.Write(xlate("Skip",true))%></option>
                <option value=7><%Response.Write(xlate("Ask until Reboot",true))%></option>
                <option value=3><%Response.Write(xlate("Ask - Reboot",true))%></option>
                <option value=1><%Response.Write(xlate("Ask - Do Nothing",true))%></option>
                <option value=2><%Response.Write(xlate("Do Not Reboot",true))%></option>
              </select>
            </p>
            <p title="<%Response.Write(xlate("List machines that have a specific File Source configuration",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchFileSrcConfig" value="checked" <%=usePatchFileSrcConfig%>>
              <%Response.Write(xlate("Machines with Patch File Source configuration",false))%>
              <select size=1 name="patchFileSrcConfig" class="small9pt" onchange="document.UserForm.usePatchFileSrcConfig.checked=true;needToSave=true;">
                <option value='0,4'><%Response.Write(xlate("Internet",true))%></option>
                <option value='1,5'><%Response.Write(xlate("System Server",true))%></option>
                <option value='2,3,6,7'><%Response.Write(xlate("File Server",true))%></option>
                <option value='8,9'><%Response.Write(xlate("LAN Cache",true))%></option>
              </select>
            </p>
            <p title="<%Response.Write(xlate("List machines that have a specific patch missing (use KB Article ID)",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchMissingKB" value="checked" <%=usePatchMissingKB%>>
              <%Response.Write(xlate("Machines missing patch (use KB Article ID - digits only)",false))%>
              <input type="text" name="patchMissingKB" value="<%=EncodeHTMLAttribForXSS(patchMissingKB)%>" maxlength="10" style="width:100px" onchange="document.UserForm.usePatchMissingKB.checked=true;needToSave=true;">
            </p>
            <p title="<%Response.Write(xlate("List machines that have a specific patch installed (use KB Article ID)",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchInstalledKB" value="checked" <%=usePatchInstalledKB%>>
              <%Response.Write(xlate("Machines with installed patch (use KB Article ID - digits only)",false))%>
              <input type="text" name="patchInstalledKB" value="<%=EncodeHTMLAttribForXSS(patchInstalledKB)%>" maxlength="10" style="width:100px" onchange="document.UserForm.usePatchInstalledKB.checked=true;needToSave=true;">
            </p>
            <p title="<%Response.Write(xlate("List machines that are being used as a file share",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchFileShare" value="checked" <%=usePatchFileShare%>>
              <%Response.Write(xlate("Machines being used as file share",false))%>
            </p>
            <p title="<%Response.Write(xlate("List machines where file share is located at",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchFileShareSet" value="checked" <%=usePatchFileShareSet%>>
              <%Response.Write(xlate("Machines with file share located at",false))%>
              <a href='javascript:pickMach()'><span id="machLabel"
               title="<%Response.Write(xlate("Click to select a machine used as a file share",true)+".")%>"><%=xlate("select a machine",true)%></span></a>
              <input type="hidden" name="machName" value="<%=EncodeHTMLAttribForXSS(patchFileShareAgentDisplayName)%>">
              <input type="hidden" name="machGuid" value="<%=EncodeHTMLAttribForXSS(patchFileShareAgentGuid)%>">
            </p>
            <p title="<%Response.Write(xlate("List machines with patch scan source set to online currently but the last successful scan ran using offline scan source",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="usePatchOnlineScanFail" value="checked" <%=usePatchOnlineScanFail%>>
              <%Response.Write(xlate("Machines with patch scan source set to online but offline scan ran last",false))%>
            </p>
            <p title="<%Response.Write(xlate("List machines that have Windows Automatic Update disabled or not",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="useWuaDisabled" value="checked" <%=useWuaDisabled%>>
              <%Response.Write(xlate("Windows Automatic Update",false))%>
              <b><input type="radio" onclick="javascript:needToSave=true;" name="wuaDisabled" value=1>&nbsp;<%Response.Write(xlate("is disabled",false))%>&nbsp;&nbsp;
              <input type="radio" onclick="javascript:needToSave=true;" name="wuaDisabled" value=2>&nbsp;<%Response.Write(xlate("is not disabled",false))%></b>
            </p>
        </div>
    </div>
</fieldset>
<fieldset id="fsMonitor" class="x-fieldset<%= (sectionMonitorOn ? "" : " x-panel-collapsed") %>" style="width: 550px;">
    <legend id="Legend5" class="x-fieldset-header x-unselectable" style="-moz-user-select: none;">
        <a href="javascript:toggleSection('Monitor');"><span id="Span10" class="x-tool x-tool-toggle"></span></a>
        <span id="Span4" class="x-fieldset-header-text"><%=xlate("Monitoring", false)%></span>
    </legend>
    <div id="divMonitor" class="x-fieldset-bwrap" style="display: block; padding-left: 5px;">
        <div id="Div11" class="x-fieldset-body" style="display: block; width: 550px; height: auto;">
            <p title="<%Response.Write(xlate("Only show machines with monitorset assigned",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="useMonitorset" value="checked" <%=useMonitorset%>>
              <%Response.Write(xlate("Only show machines with monitorset assigned",false))%>
            <select size="1" name="useMonitorsetID" class="small9pt" style="width:210px;"
                onchange="document.UserForm.useMonitorset.checked=true; changeCtlValue(this,false); needToSave=true;" onmousedown="expandCtlWidth(this)" onblur="resetCtlWidth(this)">
                    <option value='0'>&lt; <%Response.Write(xlate("Select a Monitorset ...",true))%> &gt;</option>
            <%
            monsetSQL = "";
            thisAdminType = 1;
            // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
            sql ="select a.adminType from administrators a left outer join adminIdTab ait on a.adminName = ait.adminName where ait.adminId = ?";
            cmd = createAdoCommand(dbConn,sql,adCmdText);
            cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
            recSet.CursorType = adOpenStatic;
            recSet.Open(cmd);
            if(recSet.EOF == false) {
                thisAdminType = recSet["adminType"];
            }
            recSet.Close();

            var retrieveSet = Server.CreateObject("ADODB.Recordset");

            var adminActiveRole = "2";
            // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
            sSQL ="select isnull(admingroupid,2) adminGroupid from appSession where adminID = ? and adminScopeFK = ?";
            cmd = createAdoCommand(dbConn,sSQL,adCmdText);
            cmd.Parameters.Append( createAdoInputParamInteger(cmd, "@adminId", sessionAdminId));
            cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@adminScopeFK", sessionScope));
            retrieveSet.CursorType = adOpenStatic;
            retrieveSet.Open(cmd);
            adminActiveRole = String(retrieveSet("adminGroupid"));
            retrieveSet.Close();

            // SQL-SCRUB # Prince # Changed Concatenated Query To Parameterized Query
            monsetSQL = "SELECT ms.name, ms.description, ms.monitorsetid, ISNULL(TRN.TreeFullPath, '') TreeFullPath  FROM monitorset ms  WITH(NOLOCK) " +
                        " Join Tree.getExpandedTreeContents (20,?,?,?) TRN" +
                        " ON ms.MonitorsetID = TRN.treeNodeObjectFK  and TRN.canexecute = 1 and TRN.treeNodeTypeFK = 20101 and MS.PartitionID = ? ORDER BY ms.name";
            cmd = createAdoCommand(dbConn, monsetSQL, adCmdText);
            cmd.Parameters.Append(createKaseyaNumericAdoInputParameter(cmd, "@adminId", sessionAdminId));
            cmd.Parameters.Append(createKaseyaNumericAdoInputParameter(cmd, "@roleId", adminActiveRole));
            cmd.Parameters.Append(createKaseyaNumericAdoInputParameter(cmd, "@partitionId", sessionPartition));
            cmd.Parameters.Append(createKaseyaNumericAdoInputParameter(cmd, "@PartitionID", sessionPartition));
            recSet.CursorType = adOpenStatic;
            recSet.Open(cmd);
            while (recSet.EOF == false) {
                Response.Write("<option value='"+EncodeHTMLAttribForXSS(String(recSet("MonitorsetID")))+"'>"+
                    EncodeHTMLForXSS(String(recSet("Name")))+"(" + EncodeHTMLForXSS(String(recSet("MonitorsetID"))) + ")" + "</option>");
                recSet.MoveNext();
            }
            recSet.Close();
            %>
            </select>
            </p>
            <p title="<%Response.Write(xlate("Only show machines with SNMPset assigned",true))%>.">
              <input type="checkbox" onclick="javascript:needToSave=true;" name="useSNMPMonitorset" value="checked" <%=useSNMPMonitorset%>>
              <%Response.Write(xlate("Only show machines with monitorset assigned",false))%>
            <select size="1" name="useSNMPMonitorsetID" class="small9pt" style="width:210px;"
                onchange="document.UserForm.useSNMPMonitorset.checked=true; changeCtlValue(this,false); needToSave=true;" onmousedown="expandCtlWidth(this)" onblur="resetCtlWidth(this)">
                    <option value='0'>&lt; <%Response.Write(xlate("Select a SNMPset ...",true))%> &gt;</option>
            <%
            monsetSQL = "";
            if(thisAdminType == 2) {
                // SQL-SCRUB # Prince # Changed concatenated query string to parametrized query
                monsetSQL =" select distinct  MS.name, MS.monitorsnmpSetId from monitorSnmpSetAgentXref  MXF with (nolock) Join Monitorsnmpset MS WITH (NOLOCK)  " +
                     " on MXF.Monitorsnmpsetid = MS.Monitorsnmpsetid and MS.partitionId = ?  ORDER BY MS.Name";;
                cmd = createAdoCommand(dbConn,monsetSQL,adCmdText);
                cmd.Parameters.Append( createKaseyaNumericAdoInputParameter(cmd, "@partitionId", sessionPartition));
            } else {
                // SQL-SCRUB # Prince # Changed Concatenated Query To Parameterized Query
                monsetSQL = "SELECT ms.name, ms.description, ms.monitorsnmpsetid, ISNULL(TRN.TreeFullPath, '') TreeFullPath  FROM monitorsnmpset ms  WITH(NOLOCK) " +
                            " Join Tree.getExpandedTreeContents (21,?,?,?) TRN" +
                            " ON ms.MonitorsnmpsetID = TRN.treeNodeObjectFK  and TRN.treeNodeTypeFK = 21101"+
                            " ORDER BY ms.name";
            cmd = createAdoCommand(dbConn, monsetSQL, adCmdText);
            cmd.Parameters.Append(createKaseyaNumericAdoInputParameter(cmd, "@adminId", sessionAdminId));
            cmd.Parameters.Append(createKaseyaNumericAdoInputParameter(cmd, "@roleId", sessionScope));
            cmd.Parameters.Append(createKaseyaNumericAdoInputParameter(cmd, "@partitionId", sessionPartition));
            }
            recSet.CursorType = adOpenStatic;
            recSet.Open(cmd);
            while (recSet.EOF == false) {
                Response.Write("<option value='"+EncodeHTMLAttribForXSS(String(recSet("monitorsnmpSetId")))+"'>"+
                    EncodeHTMLForXSS(String(recSet("Name")))+"(" + EncodeHTMLForXSS(String(recSet("monitorsnmpSetId"))) + ")" + "</option>");
                recSet.MoveNext();
            }
            recSet.Close();
            %>
            </select>
            </p>
        </div>
    </div>
</fieldset>
<div style="padding-left: 15px;">
    <input type="checkbox" onclick="javascript:needToSave=true;" name="advFilter" value="checked" <%=advFilter%> ID="Checkbox5">
    <%Response.Write(xlate("Advanced agent data filter",false))%>
        <input type="button" value="<%Response.Write(xlate("Define Filter",true))%>..."
            class="tinyButton" onclick="openAdvanced(<%=advFilterId%>)" <% = (Number(activeViewId) > 0 ? "":"disabled='disabled'") %> />
            <% if (Number(activeViewId) == 0) { %>
            <span style="font-size: 11px;"></span><i><% = xlate("Save view before defining filter",true) %></i>
            <% } %>
                <input type="hidden" name="advFilterId" value="<%=EncodeHTMLAttribForXSS(advFilterId)%>">
</div>
</div>

</form>

<script language="javascript">
Ext.onReady(function() {
    Ext.QuickTips.init();
    var saveToolbar = new Ext.Toolbar({
        renderTo: 'actionIcon',
        cls: 'toolbarCls',
        items: [
                    {
                        id: 'saveButton',
                        text: '<%Response.Write(xlate("Save",true))%>',
                        icon: '/vsaPres/App_Themes/0/images/SIZE16/Actions/Save.png',
                        iconCls: 'x-btn-text-icon',
                        <%=(activeViewId == 0 || shareDisabled.length > 0 ? "disabled:true,":"")%>
                        handler: function(){ buttonClick('1');}
                    },

                    {
                        id: 'saveAsButton',
                        text: '<%Response.Write(xlate("Save As",true))%>',
                        icon: '/vsaPres/App_Themes/0/images/SIZE16/Actions/SaveAs.png',
                        handler: function(){ buttonClick('2');}
                    },
                    {
                        id: 'deleteButton',
                        text: '<%Response.Write(xlate("Delete",true))%>',
                        icon: '/vsaPres/App_Themes/0/images/SIZE16/Actions/Delete.png',
                        <%=(activeViewId == 0 || shareDisabled.length > 0 ? "disabled:true,":"")%>
                        handler: function(){ buttonClick('3');}
                    },
                    {
                        id: 'cancelButton',
                        text: '<%Response.Write(xlate("Cancel",true))%>',
                        icon: '/vsaPres/App_Themes/0/images/SIZE16/Actions/Cancel.png',
                        <%=(activeViewId == 0?"disabled:true,":"")%>
                        handler: function(){ javascript:self.close();}
                    },
                    {
                        id: 'shareButton',
                        text: '<%Response.Write(xlate("Share",true))%>',
                        icon: '/vsaPres/App_Themes/0/images/SIZE16/Actions/Recipients.png',
                        <%=(activeViewId == 0 || shareDisabled.length > 0 ? "disabled:true,":"")%>
                        handler: function(){ setShare();}
                    }
                ]
    });


    var helpToolbar = new Ext.Toolbar({
        renderTo: 'helpIcon',
        cls: 'toolbarCls',
        items: [
                    {
                        id: 'helpButton',
                        text: '<%Response.Write(xlate("Help",true))%>',
                        icon: '/vsaPres/App_Themes/0/images/SIZE16/Actions/Help.png',
                        iconCls: 'x-btn-text-icon',
                        handler: getHelp
                    }
                ]
    });
});
showScript();
setSelector("activeViewId","<%=activeViewId%>");
with (document.UserForm) {
    <% =radioSet %>
    if ("<%=shareDisabled%>".length > 0) {
        //saveBut.disabled = true;
        //deleteBut.disabled = true;
        editTitle.disabled = true;
        //shareButton.disabled = true;
    }
    setSelector("onLineMinUnit","<%=onLineMinUnit%>");
    setSelector("rebootMinUnit","<%=rebootMinUnit%>");
    setSelector("agentCredentialStatus","<%=agentCredentialStatus%>");
    setSelector("scriptMinUnit","<%=scriptMinUnit%>");
    setSelector("patchScanMinUnit","<%=patchScanMinUnit%>");
    setSelector("patchTestStatus","<%=patchTestStatus%>");
    setSelector("patchAutoUpdateConfig","<%=patchAutoUpdateConfig%>");
    setSelector("patchRebootConfig","<%=patchRebootConfig%>");
    setSelector("patchFileSrcConfig","<%=patchFileSrcConfig%>");
    setSelector("useMonitorsetID","<%=useMonitorsetID%>");
    setSelector("useSNMPMonitorsetID","<%=useSNMPMonitorsetID%>");
    setSelector("groupIdFil","<%=groupIdFil%>");
<% if (showCollections == true) { %>
    setSelector("colIdFil","<%=colIdFil%>");
<% } %>
    setSelector("osType","<%=osType%>");
}
try {
    <%
    var checkPostBack = new String(getRequestServerVariable("REQUEST_METHOD"))
    if (checkPostBack == "POST")
        {
    %>
    if(opener.document.location.href.indexOf('#') > 1)
    {
        if(opener.document.location.href.indexOf('?') > 1)
        {
            opener.document.location = opener.document.location.href.replace('#', '&reload=true#');
        }
        else
        {
            opener.document.location = opener.document.location.href.replace('#', '?reload=true#');
        }
    }
    else
    {
        if(opener.document.location.href.indexOf('?') > 1)
        {
            opener.document.location = opener.document.location.href+'&reload=true';

        }
        else
        {
            opener.document.location = opener.document.location.href+'?reload=true';
        }
    }
    <% } %>
}
catch(err) { }
showMach();
setTimeout("self.focus();",1500);
</script>
<!-- #include virtual = "/inc/selectExpand.js" -->
<%
}
%>
<!-- #include virtual = "/inc/xlate.inc" -->
</body>
</HTML>