INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64468','32329','1','21','var v_range = [
      [[0, 18], [12, 15, 11.5, 15.5]],
      [[18, 36], [24, 30, 23, 31]],
      [[36, 99], [48, 60, 46, 62]],
  ],
  result = [];

for (var idx in v_range) {
    if (v_range[idx][0][0] < value && value <= v_range[idx][0][1]) {
        result = [{
            ''{#VOLTAGE.MIN.WARN}'': parseInt({$VOLTAGE.MIN.WARN}) || v_range[idx][1][0],
            ''{#VOLTAGE.MAX.WARN}'': parseInt({$VOLTAGE.MAX.WARN}) || v_range[idx][1][1],
            ''{#VOLTAGE.MIN.CRIT}'': parseInt({$VOLTAGE.MIN.CRIT}) || v_range[idx][1][2],
            ''{#VOLTAGE.MAX.CRIT}'': parseInt({$VOLTAGE.MAX.CRIT}) || v_range[idx][1][3],
            ''{#SINGLETON}'': ''''
        }];
        break;
    }
}

return JSON.stringify(result);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64469','32332','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64470','32332','2','21',E'var FIELDS = [
  ''rtsOpen'',
  ''rtsShorted'',
  ''rtsDisconnected'',
  ''heatsinkTempSensorOpen'',
  ''heatsinkTempSensorShorted'',
  ''heatsinkTempLimit'',
  ''currentLimit'',
  ''currentMeasurementError'',
  ''batterySenseOutOfRange'',
  ''batterySenseDisconnected'',
  ''uncalibrated'',
  ''batteryTempOutOfRange'',
  ''fp10SupplyOutOfRange'',
  ''mosfetOpen'',
  ''arrayCurrentOffset'',
  ''loadCurrentOffset'',
  ''p33SupplyOutOfRange'',
  ''p12SupplyOutOfRange'',
  ''hightInputVoltageLimit'',
  ''controllerReset'',
  ''loadLvd'',
  ''logTimeout'',
  ''eepromAccessFailure''
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No alarms'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64471','32335','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64472','32336','1','1','0.01','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64473','32337','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64474','32337','2','21',E'var FIELDS = [
  ''externalShortCircuit'',
  ''overcurrent'',
  ''mosfetShorted'',
  ''software'',
  ''loadHvd'',
  ''highTempDisconnect'',
  ''dipSwitchChanged'',
  ''customSettingsEdit'',
  ''p3Fault''
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64475','32338','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64476','32338','2','21',E'var FIELDS = [
  ''overcurrent'',
  ''mosfetSShorted'',
  ''software'',
  ''batteryHvd'',
  ''arrayHvd'',
  ''customSettingsEdit'',
  ''rtsShorted'',
  ''rtsNoLongerValid'',
  ''localTempSensorDamaged'',
  ''batteryLowVoltageDisconnect'',
  ''slaveTimeout'',
  ''dipSwitchChanged'',
  ''p3Fault'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64477','32341','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64478','32343','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64479','32345','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64480','32346','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64481','32349','1','21','var v_range = [
      [[0, 18], [12, 15, 11.5, 15.5]],
      [[18, 36], [24, 30, 23, 31]],
      [[36, 99], [48, 60, 46, 62]],
  ],
  result = [];

for (var idx in v_range) {
    if (v_range[idx][0][0] < value && value <= v_range[idx][0][1]) {
        result = [{
            ''{#VOLTAGE.MIN.WARN}'': parseInt({$VOLTAGE.MIN.WARN}) || v_range[idx][1][0],
            ''{#VOLTAGE.MAX.WARN}'': parseInt({$VOLTAGE.MAX.WARN}) || v_range[idx][1][1],
            ''{#VOLTAGE.MIN.CRIT}'': parseInt({$VOLTAGE.MIN.CRIT}) || v_range[idx][1][2],
            ''{#VOLTAGE.MAX.CRIT}'': parseInt({$VOLTAGE.MAX.CRIT}) || v_range[idx][1][3],
            ''{#SINGLETON}'': ''''
        }];
        break;
    }
}

return JSON.stringify(result);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64482','32351','1','1','0.01509857178','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64483','32351','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64484','32352','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64485','32355','1','1','0.003051757813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64486','32355','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64487','32356','1','1','0.01','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64488','32357','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64489','32357','2','21',E'var FIELDS = [
  ''externalShortCircuit'',
  ''overcurrent'',
  ''mosfetShorted'',
  ''software'',
  ''loadHvd'',
  ''highTempDisconnect'',
  ''customSettingsEdit'',
  ''unknownLoadFault''
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64490','32358','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64491','32358','2','21',E'var FIELDS = [
  ''overcurrent'',
  ''mosfetSShorted'',
  ''softwareFault'',
  ''batteryHvd'',
  ''arrayHvd'',
  ''customSettingsEdit'',
  ''rtsShorted'',
  ''rtsNoLongerValid'',
  ''localTempSensorDamaged'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64492','32359','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64493','32359','2','21',E'var FIELDS = [
  ''rtsOpen'',
  ''rtsShorted'',
  ''rtsDisconnected'',
  ''heatsinkTempSensorOpen'',
  ''heatsinkTempSensorShorted'',
  ''sspptHot'',
  ''currentLimit'',
  ''currentOffset'',
  ''undefined'',
  ''undefined1'',
  ''uncalibrated'',
  ''rtsMiswire'',
  ''undefined12'',
  ''undefined123'',
  ''systemMiswire'',
  ''mosfetSOpen'',
  ''p12VoltageReferenceOff'',
  ''highVaCurrentLimit'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No alarms'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64494','32360','1','1','0.003051757813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64495','32360','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64496','32361','1','1','0.002415771484','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64497','32361','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64498','32362','1','1','0.003051757813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64499','32362','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64500','32363','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64501','32365','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64502','32366','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64503','32367','1','1','0.002415771484','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64504','32367','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64505','32368','1','1','0.003051757813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64506','32369','1','1','0.003051757813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64507','32369','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64508','32370','1','1','0.003051757813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64509','32370','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64510','32372','1','21','var v_range = [
      [[0, 18], [12, 15, 11.5, 15.5]],
      [[18, 36], [24, 30, 23, 31]],
      [[36, 99], [48, 60, 46, 62]],
  ],
  result = [];

for (var idx in v_range) {
    if (v_range[idx][0][0] < value && value <= v_range[idx][0][1]) {
        result = [{
            ''{#VOLTAGE.MIN.WARN}'': parseInt({$VOLTAGE.MIN.WARN}) || v_range[idx][1][0],
            ''{#VOLTAGE.MAX.WARN}'': parseInt({$VOLTAGE.MAX.WARN}) || v_range[idx][1][1],
            ''{#VOLTAGE.MIN.CRIT}'': parseInt({$VOLTAGE.MIN.CRIT}) || v_range[idx][1][2],
            ''{#VOLTAGE.MAX.CRIT}'': parseInt({$VOLTAGE.MAX.CRIT}) || v_range[idx][1][3],
            ''{#SINGLETON}'': ''''
        }];
        break;
    }
}

return JSON.stringify(result);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64511','32373','1','1','0.003051757813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64512','32373','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64513','32374','1','1','2.581787109375E-4','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64514','32374','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64515','32375','1','1','1.953125E-4','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64516','32375','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64517','32376','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64518','32377','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64519','32377','2','21',E'var FIELDS = [
  ''heatsinkTempSensorOpen'',
  ''heatsinkTempSensorShort'',
  ''unknownAlarm'',
  ''suresineHot''
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No alarms'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64520','32378','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64521','32378','2','21',E'var FIELDS = [
  ''reset'',
  ''overcurrent'',
  ''unknownFault'',
  ''software'',
  ''highVoltageDisconnect'',
  ''suresineHot'',
  ''dipSwitchChanged'',
  ''customSettingsEdit''
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64522','32379','1','1','0.01','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64523','32381','1','21','var v_range = [
      [[0, 18], [12, 15, 11.5, 15.5]],
      [[18, 36], [24, 30, 23, 31]],
      [[36, 99], [48, 60, 46, 62]],
  ],
  result = [];

for (var idx in v_range) {
    if (v_range[idx][0][0] < value && value <= v_range[idx][0][1]) {
        result = [{
            ''{#VOLTAGE.MIN.WARN}'': parseInt({$VOLTAGE.MIN.WARN}) || v_range[idx][1][0],
            ''{#VOLTAGE.MAX.WARN}'': parseInt({$VOLTAGE.MAX.WARN}) || v_range[idx][1][1],
            ''{#VOLTAGE.MIN.CRIT}'': parseInt({$VOLTAGE.MIN.CRIT}) || v_range[idx][1][2],
            ''{#VOLTAGE.MAX.CRIT}'': parseInt({$VOLTAGE.MAX.CRIT}) || v_range[idx][1][3],
            ''{#SINGLETON}'': ''''
        }];
        break;
    }
}

return JSON.stringify(result);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64524','32382','1','1','2.581787109375E-4','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64525','32382','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64526','32386','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64527','32387','1','1','0.01','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64528','32388','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64529','32388','2','21',E'var FIELDS = [
  ''overcurrent'',
  ''fetShort'',
  ''softwareFault'',
  ''batteryHvd'',
  ''arrayHvd'',
  ''dipSwitchChange'',
  ''customSettingsEdit'',
  ''rtsShorted'',
  ''rtsDisconnected'',
  ''eepromRetryLimit'',
  ''controllerWasReset'',
  ''chargeSlaveControlTimeout'',
  ''rs232SerialToMeterBridge'',
  ''batteryLvd'',
  ''fault14Undefined'',
  ''powerboardCommunicationFault'',
  ''fault16Software'',
  ''fault17Software'',
  ''fault18Software'',
  ''fault19Software'',
  ''fault20Software'',
  ''fault21Software'',
  ''fpgaVersion'',
  ''currentSensorReferenceOutOfRange'',
  ''ia-refSlaveModeTimeout'',
  ''blockbusBoot'',
  ''hscommMaster'',
  ''hscomm'',
  ''slave'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64530','32389','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64531','32389','2','21',E'var FIELDS = [
  ''rtsOpen'',
  ''rtsShorted'',
  ''rtsDisconnected'',
  ''heatsinkTempSensorOpen'',
  ''heatsinkTempSensorShorted'',
  ''highTemperatureCurrentLimit'',
  ''currentLimit'',
  ''currentOffset'',
  ''batterySense'',
  ''batterySenseDisconnected'',
  ''uncalibrated'',
  ''rtsMiswire'',
  ''highVoltageDisconnect'',
  ''undefined'',
  ''systemMiswire'',
  ''mosfetSOpen'',
  ''p12VoltageOutOfRange'',
  ''highArrayVCurrentLimit'',
  ''maxAdcValueReached'',
  ''controllerWasReset'',
  ''alarm21Internal'',
  ''p3VoltageOutOfRange'',
  ''derateLimit'',
  ''arrayCurrentOffset'',
  ''ee-i2cRetryLimit'',
  ''ethernetAlarm'',
  ''lvd'',
  ''software'',
  ''fp12VoltageOutOfRange'',
  ''extflashFault'',
  ''slaveControlFault'',
  ''alarm32Undefined''
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No alarms'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64532','32391','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64533','32400','1','21','var v_range = [
      [[0, 18], [12, 15, 11.5, 15.5]],
      [[18, 36], [24, 30, 23, 31]],
      [[36, 99], [48, 60, 46, 62]],
  ],
  result = [];

for (var idx in v_range) {
    if (v_range[idx][0][0] < value && value <= v_range[idx][0][1]) {
        result = [{
            ''{#VOLTAGE.MIN.WARN}'': parseInt({$VOLTAGE.MIN.WARN}) || v_range[idx][1][0],
            ''{#VOLTAGE.MAX.WARN}'': parseInt({$VOLTAGE.MAX.WARN}) || v_range[idx][1][1],
            ''{#VOLTAGE.MIN.CRIT}'': parseInt({$VOLTAGE.MIN.CRIT}) || v_range[idx][1][2],
            ''{#VOLTAGE.MAX.CRIT}'': parseInt({$VOLTAGE.MAX.CRIT}) || v_range[idx][1][3],
            ''{#SINGLETON}'': ''''
        }];
        break;
    }
}

return JSON.stringify(result);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64534','32402','1','1','0.00244140625','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64535','32402','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64536','32403','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64537','32405','1','1','0.005493164063','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64538','32405','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64539','32406','1','1','0.01','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64540','32407','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64541','32407','2','21',E'var FIELDS = [
  ''overcurrent'',
  ''fetShort'',
  ''softwareFault'',
  ''batteryHvd'',
  ''arrayHvd'',
  ''dipSwitchChange'',
  ''customSettingsEdit'',
  ''rtsShorted'',
  ''rtsDisconnected'',
  ''eepromRetryLimit'',
  ''fault11Undefined'',
  ''slaveControlTimeout'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64542','32408','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64543','32408','2','21',E'var FIELDS = [
  ''rtsOpen'',
  ''rtsShorted'',
  ''rtsDisconnected'',
  ''heatsinkTempSensorOpen'',
  ''heatsinkTempSensorShorted'',
  ''highTemperatureCurrentLimit'',
  ''currentLimit'',
  ''currentOffset'',
  ''batterySense'',
  ''batterySenseDisconnected'',
  ''uncalibrated'',
  ''rtsMiswire'',
  ''highVoltageDisconnect'',
  ''undefined'',
  ''systemMiswire'',
  ''mosfetSOpen'',
  ''p12VoltageReferenceOff'',
  ''highArrayVCurrentLimit'',
  ''maxAdcValueReached'',
  ''controllerWasReset'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No alarms'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64544','32410','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64545','32411','1','1','0.1098632813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64546','32411','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64547','32412','1','1','0.1098632813','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64548','32412','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64549','32413','1','1','0.00244140625','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64550','32413','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64551','32414','1','1','0.005493164063','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64552','32415','1','1','0.005493164063','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64553','32415','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64554','32416','1','1','0.005493164063','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64555','32416','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64556','32417','1','1','0.005493164063','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64557','32417','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64558','32419','1','21','var v_range = [
      [[0, 18], [12, 15, 11.5, 15.5]],
      [[18, 36], [24, 30, 23, 31]],
      [[36, 99], [48, 60, 46, 62]],
  ],
  result = [];

for (var idx in v_range) {
    if (v_range[idx][0][0] < value && value <= v_range[idx][0][1]) {
        result = [{
            ''{#VOLTAGE.MIN.WARN}'': parseInt({$VOLTAGE.MIN.WARN}) || v_range[idx][1][0],
            ''{#VOLTAGE.MAX.WARN}'': parseInt({$VOLTAGE.MAX.WARN}) || v_range[idx][1][1],
            ''{#VOLTAGE.MIN.CRIT}'': parseInt({$VOLTAGE.MIN.CRIT}) || v_range[idx][1][2],
            ''{#VOLTAGE.MAX.CRIT}'': parseInt({$VOLTAGE.MAX.CRIT}) || v_range[idx][1][3],
            ''{#SINGLETON}'': ''''
        }];
        break;
    }
}

return JSON.stringify(result);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64559','32420','1','1','0.005493164063','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64560','32420','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64561','32421','1','1','0.002950042725','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64562','32423','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64563','32424','1','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64564','32424','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64565','32425','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64566','32425','2','21',E'var FIELDS = [
  ''rtsOpen'',
  ''rtsShorted'',
  ''rtsDisconnected'',
  ''heatsinkTempSensorOpen'',
  ''heatsinkTempSensorShorted'',
  ''tristarHot'',
  ''currentLimit'',
  ''currentOffset'',
  ''batterySense'',
  ''batterySenseDisconnected'',
  ''uncalibrated'',
  ''rtsMiswire'',
  ''highVoltageDisconnect'',
  ''diversionLoadNearMax'',
  ''systemMiswire'',
  ''mosfetSOpen'',
  ''p12VoltageReferenceOff'',
  ''loadDisconnectState'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No alarms'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64567','32426','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64568','32426','2','21',E'var FIELDS = [
  ''externalShort'',
  ''overcurrent'',
  ''mosfetSShorted'',
  ''softwareFault'',
  ''highVoltageDisconnect'',
  ''tristarHot'',
  ''dipSwitchChange'',
  ''customSettingsEdit'',
  ''reset'',
  ''systemMiswire'',
  ''rtsShorted'',
  ''rtsDisconnected'',
];

var flags = parseInt(value.replace(/\\x20/g, ''''), 16),
  result = [];

for (var i = 0, f = 1 << 31 >>> 0, l = FIELDS.length; i < l; i++, f >>>= 1) {
    if (flags & f) {
        result.push(FIELDS[i]);
    }
}

return result.length ? result.join(''\\n'') : ''No faults'';
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64569','32427','1','1','0.01','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64570','32430','1','21','var v_range = [
      [[0, 18], [12, 15, 11.5, 15.5]],
      [[18, 36], [24, 30, 23, 31]],
      [[36, 99], [48, 60, 46, 62]],
  ],
  result = [];

for (var idx in v_range) {
    if (v_range[idx][0][0] < value && value <= v_range[idx][0][1]) {
        result = [{
            ''{#VOLTAGE.MIN.WARN}'': parseInt({$VOLTAGE.MIN.WARN}) || v_range[idx][1][0],
            ''{#VOLTAGE.MAX.WARN}'': parseInt({$VOLTAGE.MAX.WARN}) || v_range[idx][1][1],
            ''{#VOLTAGE.MIN.CRIT}'': parseInt({$VOLTAGE.MIN.CRIT}) || v_range[idx][1][2],
            ''{#VOLTAGE.MAX.CRIT}'': parseInt({$VOLTAGE.MAX.CRIT}) || v_range[idx][1][3],
            ''{#SINGLETON}'': ''''
        }];
        break;
    }
}

return JSON.stringify(result);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64571','32431','1','21','var mode = parseInt(value);
return JSON.stringify((mode === 0 || mode === 2) ? [{''{#SINGLETON}'': ''''}] : []);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64572','32432','1','21','return JSON.stringify(parseInt(value) === 0 ? [{''{#SINGLETON}'': ''''}] : []);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64573','32433','1','21','return JSON.stringify(parseInt(value) === 2 ? [{''{#SINGLETON}'': ''''}] : []);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64574','32434','1','21','var mode = parseInt(value);
return JSON.stringify((mode === 1 || mode === 2) ? [{''{#SINGLETON}'': ''''}] : []);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64575','32435','1','21','return JSON.stringify(parseInt(value) === 1 ? [{''{#SINGLETON}'': ''''}] : []);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64576','32436','1','1','0.002950042725','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64577','32436','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64578','32437','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64579','32438','1','1','0.002950042725','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64580','32438','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64581','32439','1','1','0.004246520996','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64582','32439','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64583','32440','1','1','0.002034515381','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64584','32440','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64585','32441','1','1','0.3921568627','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64586','32441','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64587','32442','1','1','0.009664001465','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64588','32442','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64589','32443','1','1','0.004246520996','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64590','32443','2','5',E'^(\\d+)(\\.\\d{1,2})?
\\1\\2','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64591','32444','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64592','27930','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64593','27931','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64594','27936','1','5',E'60 Secs \\( ([0-9\\.]+)%\\).+300 Secs
\\1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64595','30121','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64596','27967','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64597','27968','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64598','27970','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64599','27971','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64600','30125','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64601','27997','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64602','27998','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64603','27999','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64604','28000','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64605','28026','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64606','28027','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64607','30132','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64608','30133','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64609','30134','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64610','30135','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64611','29087','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64612','29089','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64613','29102','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64614','29111','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64615','29113','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64616','29114','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64617','29116','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64618','29117','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64619','29120','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64620','29121','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64621','29122','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64622','29123','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64623','29124','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64624','29126','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64625','29139','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64626','29148','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64627','29150','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64628','29151','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64629','29153','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64630','29154','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64631','29157','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64632','29158','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64633','29159','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64634','29160','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64635','29161','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64636','29163','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64637','29176','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64638','29185','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64639','29187','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64640','29188','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64641','29190','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64642','29191','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64643','29194','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64644','29195','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64645','29196','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64646','29197','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64647','29198','1','21','//Calculate utilization
return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64648','31270','1','21','return (100-value);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64649','29199','1','21','//Calculate utilization
return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64650','31271','1','21','return (100-value);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64651','29200','1','21','//Calculate utilization
return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64652','31272','1','21','return (100-value);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64653','31273','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64654','31274','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64655','31275','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64656','29216','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64657','29216','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64658','29217','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64659','29217','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64660','29218','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64661','29219','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64662','29220','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64663','29221','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64664','29222','1','21','var newvalue;
switch(value) {
  case "up":
    newvalue = 1;
    break;
  case "down":
    newvalue = 2;
    break;
  case "testing":
    newvalue = 4;
    break;
  case "unknown":
    newvalue = 5;
    break;
  case "dormant":
    newvalue = 6;
    break;
  case "notPresent":
    newvalue = 7;
    break;
  default:
    newvalue = "Problem parsing interface operstate in JS";
}
return newvalue;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64665','29223','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64666','31278','1','21','return JSON.stringify(value.trim().split(/ +/));','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64667','29230','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64668','29230','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64669','29231','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64670','29231','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64671','29232','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64672','29233','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64673','29234','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64674','29235','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64675','29236','1','21','var newvalue;
switch(value) {
  case "up":
    newvalue = 1;
    break;
  case "down":
    newvalue = 2;
    break;
  case "testing":
    newvalue = 4;
    break;
  case "unknown":
    newvalue = 5;
    break;
  case "dormant":
    newvalue = 6;
    break;
  case "notPresent":
    newvalue = 7;
    break;
  default:
    newvalue = "Problem parsing interface operstate in JS";
}
return newvalue;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64676','29237','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64677','31281','1','21','return JSON.stringify(value.trim().split(/ +/));','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64678','29244','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64679','29244','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64680','29245','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64681','29245','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64682','29246','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64683','29247','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64684','29248','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64685','29249','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64686','29250','1','21','var newvalue;
switch(value) {
  case "up":
    newvalue = 1;
    break;
  case "down":
    newvalue = 2;
    break;
  case "testing":
    newvalue = 4;
    break;
  case "unknown":
    newvalue = 5;
    break;
  case "dormant":
    newvalue = 6;
    break;
  case "notPresent":
    newvalue = 7;
    break;
  default:
    newvalue = "Problem parsing interface operstate in JS";
}
return newvalue;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64687','29251','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64688','31284','1','21','return JSON.stringify(value.trim().split(/ +/));','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64689','31285','1','12','$[10]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64690','31285','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64691','31285','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64692','31286','1','12','$[0]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64693','31286','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64694','31287','1','12','$[3]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64695','31287','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64696','31287','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64697','31288','1','12','$[9]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64698','31288','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64699','31288','3','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64700','31289','1','12','$[4]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64701','31289','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64702','31290','1','12','$[7]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64703','31290','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64704','31290','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64705','31291','1','12','$[10]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64706','31291','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64707','31291','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64708','31292','1','12','$[0]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64709','31292','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64710','31293','1','12','$[3]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64711','31293','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64712','31293','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64713','31294','1','12','$[9]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64714','31294','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64715','31294','3','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64716','31295','1','12','$[4]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64717','31295','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64718','31296','1','12','$[7]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64719','31296','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64720','31296','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64721','31297','1','12','$[10]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64722','31297','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64723','31297','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64724','31298','1','12','$[0]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64725','31298','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64726','31299','1','12','$[3]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64727','31299','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64728','31299','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64729','31300','1','12','$[9]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64730','31300','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64731','31300','3','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64732','31301','1','12','$[4]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64733','31301','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64734','31302','1','12','$[7]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64735','31302','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64736','31302','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64737','29273','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64738','29275','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64739','29288','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64740','29297','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64741','29299','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64742','29300','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64743','29302','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64744','29303','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64745','29306','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64746','29307','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64747','29308','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64748','29309','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64749','29310','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64750','29312','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64751','29325','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64752','29334','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64753','29336','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64754','29337','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64755','29339','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64756','29340','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64757','29343','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64758','29344','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64759','29345','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64760','29346','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64761','29347','1','21','//Calculate utilization
return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64762','31303','1','21','return (100-value);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64763','29348','1','21','//Calculate utilization
return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64764','31304','1','21','return (100-value);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64765','31305','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64766','31306','1','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64767','29361','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64768','29361','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64769','29362','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64770','29362','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64771','29363','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64772','29364','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64773','29365','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64774','29366','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64775','29367','1','21','var newvalue;
switch(value) {
  case "up":
    newvalue = 1;
    break;
  case "down":
    newvalue = 2;
    break;
  case "testing":
    newvalue = 4;
    break;
  case "unknown":
    newvalue = 5;
    break;
  case "dormant":
    newvalue = 6;
    break;
  case "notPresent":
    newvalue = 7;
    break;
  default:
    newvalue = "Problem parsing interface operstate in JS";
}
return newvalue;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64776','29368','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64777','31309','1','21','return JSON.stringify(value.trim().split(/ +/));','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64778','29375','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64779','29375','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64780','29376','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64781','29376','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64782','29377','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64783','29378','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64784','29379','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64785','29380','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64786','29381','1','21','var newvalue;
switch(value) {
  case "up":
    newvalue = 1;
    break;
  case "down":
    newvalue = 2;
    break;
  case "testing":
    newvalue = 4;
    break;
  case "unknown":
    newvalue = 5;
    break;
  case "dormant":
    newvalue = 6;
    break;
  case "notPresent":
    newvalue = 7;
    break;
  default:
    newvalue = "Problem parsing interface operstate in JS";
}
return newvalue;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64787','29382','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64788','31312','1','21','return JSON.stringify(value.trim().split(/ +/));','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64789','31313','1','12','$[10]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64790','31313','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64791','31313','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64792','31314','1','12','$[0]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64793','31314','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64794','31315','1','12','$[3]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64795','31315','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64796','31315','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64797','31316','1','12','$[9]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64798','31316','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64799','31316','3','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64800','31317','1','12','$[4]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64801','31317','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64802','31318','1','12','$[7]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64803','31318','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64804','31318','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64805','31319','1','12','$[10]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64806','31319','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64807','31319','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64808','31320','1','12','$[0]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64809','31320','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64810','31321','1','12','$[3]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64811','31321','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64812','31321','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64813','31322','1','12','$[9]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64814','31322','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64815','31322','3','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64816','31323','1','12','$[4]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64817','31323','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64818','31324','1','12','$[7]','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64819','31324','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64820','31324','3','1','0.001','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64821','29398','1','22','{__name__=~"^node_time(?:_seconds)?$"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64822','29399','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="steal"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64823','29399','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64824','29399','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64825','29399','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64826','29400','1','22','{__name__=~"node_memory_SwapFree"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64827','29401','1','22','{__name__=~"node_memory_SwapTotal"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64828','29402','1','22','{__name__=~"node_memory_MemAvailable"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64829','29403','1','22','{__name__=~"node_memory_MemTotal"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64830','29404','1','22','{__name__=~"^node_boot_time(?:_seconds)?$"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64831','29405','1','22','{__name__=~"node_context_switches"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64832','29405','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64833','29406','1','22','{__name__=~"node_intr"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64834','29406','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64835','29407','1','23','{__name__=~"^node_cpu(?:_guest_seconds_total)?$",cpu=~".+",mode=~"^(?:nice|guest_nice)$"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64836','29407','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64837','29407','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64838','29407','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64839','29408','1','23','{__name__=~"^node_cpu(?:_guest_seconds_total)?$",cpu=~".+",mode=~"^(?:user|guest)$"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64840','29408','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64841','29408','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64842','29408','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64843','29409','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="irq"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64844','29409','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64845','29409','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64846','29409','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64847','29410','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="iowait"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64848','29410','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64849','29410','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64850','29410','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64851','29411','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="nice"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64852','29411','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64853','29411','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64854','29411','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64855','29412','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="softirq"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64856','29412','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64857','29412','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64858','29412','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64859','29413','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="user"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64860','29413','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64861','29413','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64862','29413','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64863','29414','1','22','node_uname_info
nodename','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64864','29414','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64865','29415','1','22','node_exporter_build_info
version','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64866','29415','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64867','29416','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="idle"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64868','29416','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64869','29416','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64870','29416','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64871','29417','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="idle"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64872','29417','2','21','//count the number of cores
return JSON.parse(value).length
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64873','29418','1','22','node_load15
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64874','29419','1','22','node_load5
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64875','29420','1','22','node_load1
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64876','29421','1','22','{__name__=~"^node_boot_time(?:_seconds)?$"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64877','29421','2','21','//use boottime to calculate uptime
return (Math.floor(Date.now()/1000)-Number(value));','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64878','29422','1','22','node_uname_info
machine','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64879','29422','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64880','29423','1','22','node_filefd_allocated
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64881','29424','1','22','node_filefd_maximum
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64882','29424','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64883','29425','1','23','node_uname_info','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64884','29425','2','21','var info = JSON.parse(value)[0];
   return info.labels.sysname+'' version: ''+info.labels.release+'' ''+info.labels.version','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64885','29425','3','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64886','29426','1','23','{__name__=~"^node_cpu(?:_seconds_total)?$",cpu=~".+",mode="system"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64887','29426','2','21','//calculates average, all cpu utilization
var valueArr = JSON.parse(value);
return valueArr.reduce(function(acc,obj){
   return acc + parseFloat(obj[''value''])
},0)/valueArr.length;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64888','29426','3','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64889','29426','4','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64890','29427','1','21','//Calculate utilization
return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64891','29428','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64892','29429','1','23','{__name__=~"^node_network_info$"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64893','29430','1','23','{__name__=~"^node_filesystem_size(?:_bytes)?$", mountpoint=~".+"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64894','29431','1','23','node_disk_io_now{device=~".+"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64895','29436','1','22','node_network_receive_bytes_total{device="{#IFNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64896','29436','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64897','29436','3','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64898','29437','1','22','node_network_transmit_bytes_total{device="{#IFNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64899','29437','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64900','29437','3','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64901','29438','1','22','node_network_transmit_errs_total{device="{#IFNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64902','29438','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64903','29439','1','22','node_network_receive_errs_total{device="{#IFNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64904','29439','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64905','29440','1','22','node_network_receive_drop_total{device="{#IFNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64906','29440','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64907','29441','1','22','node_network_transmit_drop_total{device="{#IFNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64908','29441','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64909','29442','1','22','node_network_speed_bytes{device="{#IFNAME}"}
','2','0');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64910','29442','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64911','29443','1','22','node_network_protocol_type{device="{#IFNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64912','29444','1','22','node_network_info{device="{#IFNAME}"}
operstate','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64913','29444','2','21','var newvalue;
switch(value) {
  case "up":
    newvalue = 1;
    break;
  case "down":
    newvalue = 2;
    break;
  case "testing":
    newvalue = 4;
    break;
  case "unknown":
    newvalue = 5;
    break;
  case "dormant":
    newvalue = 6;
    break;
  case "notPresent":
    newvalue = 7;
    break;
  default:
    newvalue = "Problem parsing interface operstate in JS";
}
return newvalue;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64914','29445','1','22','{__name__=~"^node_filesystem_avail(?:_bytes)?$", mountpoint="{#FSNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64915','29446','1','22','{__name__=~"^node_filesystem_size(?:_bytes)?$", mountpoint="{#FSNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64916','29447','1','23','{__name__=~"node_filesystem_files.*",mountpoint="{#FSNAME}"}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64917','29447','2','21','//count vfs.fs.inode.pfree
var inode_free;
var inode_total;
JSON.parse(value).forEach(function(metric) {
  if (metric[''name''] == ''node_filesystem_files''){
      inode_total = metric[''value''];
  } else if (metric[''name''] == ''node_filesystem_files_free''){
      inode_free = metric[''value''];
  }
});
return (inode_free/inode_total)*100;','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64918','29448','1','22','node_disk_reads_completed_total{device="{#DEVNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64919','29448','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64920','29449','1','22','node_disk_writes_completed_total{device="{#DEVNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64921','29449','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64922','29450','1','22','node_disk_read_time_seconds_total{device="{#DEVNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64923','29450','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64924','29451','1','22','node_disk_write_time_seconds_total{device="{#DEVNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64925','29451','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64926','29452','1','22','node_disk_io_time_weighted_seconds_total{device="{#DEVNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64927','29452','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64928','29453','1','22','node_disk_io_time_seconds_total{device="{#DEVNAME}"}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64929','29453','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64930','29453','3','1','100','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64931','28979','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64932','28980','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64933','28981','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64934','28982','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64935','28984','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64936','28985','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64937','28990','1','21','//count the number of cores
return JSON.parse(value).length;
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64938','28991','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64939','28992','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64940','28994','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64941','28995','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64942','28996','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64943','28997','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64944','28999','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64945','29000','1','1','1024','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64946','29005','1','21','//count the number of cores
return JSON.parse(value).length;
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64947','29006','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64948','29007','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64949','29009','1','21','//count the number of CPU cores
return JSON.stringify([{"{#CPU.COUNT}": value, "{#SNMPINDEX}": 0, "{#SINGLETON}":""}])
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64950','29012','1','21','//count the number of CPU cores
return JSON.stringify([{"{#CPU.COUNT}": value, "{#SNMPINDEX}": 0, "{#SINGLETON}":""}])
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64951','29014','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64952','29015','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64953','29017','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64954','29017','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64955','29018','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64956','29018','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64957','29019','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64958','29019','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64959','29020','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64960','29020','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64961','29021','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64962','29021','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64963','29022','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64964','29022','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64965','29023','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64966','29023','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64967','29024','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64968','29024','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64969','29025','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64970','29025','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64971','29026','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64972','29026','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64973','29027','1','1','{#ALLOC_UNITS}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64974','29028','1','1','{#ALLOC_UNITS}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64975','29030','1','21','return (100-value);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64976','29031','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64977','29032','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64978','29034','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64979','29034','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64980','29035','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64981','29035','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64982','29036','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64983','29036','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64984','29037','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64985','29037','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64986','29038','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64987','29038','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64988','29039','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64989','29039','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64990','29040','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64991','29040','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64992','29041','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64993','29041','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64994','29042','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64995','29042','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64996','29043','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64997','29043','2','21','//to get utilization in %, divide by N, where N is number of cores.
return value/{#CPU.COUNT}
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64998','29044','1','1','{#ALLOC_UNITS}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('64999','29045','1','1','{#ALLOC_UNITS}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65000','29047','1','21','return (100-value);','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65001','29048','1','21','//Calculate utilization
return (100 - value)
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65002','29049','1','21','//Calculate utilization
return (100 - value)
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65003','29474','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65004','29475','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65005','29478','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65006','29500','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65007','29501','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65008','29504','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65009','31331','1','21','return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65010','31332','1','21','return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65011','31333','1','25','{#INSTANCE}
{#DEVNAME}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65012','31457','1','21','output = JSON.parse(value).map(function(net){
    return {
        "{#IFNAME}": net.Name,
        "{#IFDESCR}": net.Description,
        "{#IFALIAS}" : net.NetConnectionID
    }})
return JSON.stringify({"data": output})','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65013','31457','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65014','31334','1','25','{#INSTANCE}
{#DEVNAME}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65015','31458','1','21','output = JSON.parse(value).map(function(net){
    return {
        "{#IFNAME}": net.Name,
        "{#IFDESCR}": net.Description,
        "{#IFALIAS}" : net.NetConnectionID
    }})
return JSON.stringify({"data": output})','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65016','31458','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65017','31459','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65018','31460','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65019','31461','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65020','31461','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65021','31462','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65022','31463','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65023','31464','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65024','31464','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65025','31465','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65026','31466','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65027','31467','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65028','31467','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65029','31468','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65030','31469','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65031','31470','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65032','31470','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65033','31471','1','12','$[?(@.Name == "{#IFNAME}")].Speed.first()','2','0');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65034','31471','2','21','return (value==''9223372036854775807'' ? 0 : value)
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65035','31471','3','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65036','31472','1','12','$[?(@.Name == "{#IFNAME}")].NetConnectionStatus.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65037','31472','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65038','31473','1','12','$[?(@.Name == "{#IFNAME}")].AdapterTypeId.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65039','31473','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65040','31474','1','12','$[?(@.Name == "{#IFNAME}")].Speed.first()','2','0');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65041','31474','2','21','return (value==''9223372036854775807'' ? 0 : value)
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65042','31474','3','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65043','31475','1','12','$[?(@.Name == "{#IFNAME}")].NetConnectionStatus.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65044','31475','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65045','31476','1','12','$[?(@.Name == "{#IFNAME}")].AdapterTypeId.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65046','31476','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65047','29581','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65048','29582','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65049','29585','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65050','29607','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65051','29608','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65052','29611','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65053','31349','1','21','return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65054','31350','1','21','return (100 - value)','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65055','31351','1','25','{#INSTANCE}
{#DEVNAME}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65056','31479','1','21','output = JSON.parse(value).map(function(net){
    return {
        "{#IFNAME}": net.Name,
        "{#IFDESCR}": net.Description,
        "{#IFALIAS}" : net.NetConnectionID
    }})
return JSON.stringify({"data": output})','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65057','31479','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65058','31352','1','25','{#INSTANCE}
{#DEVNAME}','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65059','31480','1','21','output = JSON.parse(value).map(function(net){
    return {
        "{#IFNAME}": net.Name,
        "{#IFDESCR}": net.Description,
        "{#IFALIAS}" : net.NetConnectionID
    }})
return JSON.stringify({"data": output})','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65060','31480','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65061','31481','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65062','31482','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65063','31483','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65064','31483','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65065','31484','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65066','31485','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65067','31486','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65068','31486','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65069','31487','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65070','31488','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65071','31489','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65072','31489','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65073','31490','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65074','31491','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65075','31492','1','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65076','31492','2','1','8','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65077','31493','1','12','$[?(@.Name == "{#IFNAME}")].Speed.first()','2','0');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65078','31493','2','21','return (value==''9223372036854775807'' ? 0 : value)
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65079','31493','3','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65080','31494','1','12','$[?(@.Name == "{#IFNAME}")].NetConnectionStatus.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65081','31494','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65082','31495','1','12','$[?(@.Name == "{#IFNAME}")].AdapterTypeId.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65083','31495','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65084','31496','1','12','$[?(@.Name == "{#IFNAME}")].Speed.first()','2','0');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65085','31496','2','21','return (value==''9223372036854775807'' ? 0 : value)
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65086','31496','3','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65087','31497','1','12','$[?(@.Name == "{#IFNAME}")].NetConnectionStatus.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65088','31497','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65089','31498','1','12','$[?(@.Name == "{#IFNAME}")].AdapterTypeId.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65090','31498','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65091','30688','1','12','$.[?(@.id==''{#SENSOR_ID}'')].state.text.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65092','30688','2','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65093','30689','1','12','$.[?(@.id==''{#SENSOR_ID}'')].value.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65094','30689','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65095','30073','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65096','30074','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65097','30079','1','1','1048576','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65098','30082','1','1','1048576','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65099','28342','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65100','28344','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65101','28345','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65102','30141','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65103','28354','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65104','28356','1','1','0.1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65105','28367','1','1','1048576','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65106','28372','1','1','1048576','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65107','28390','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65108','28391','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65109','28422','1','1','1048576','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65110','28425','1','1','1048576','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65111','28466','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65112','28467','1','20','1d','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65113','28479','1','5',E'(\\d{1,3}) *%( of maximum)?
\\1','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65114','32461','1','12','$.pjsip.available','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65115','32462','1','12','$.iax.online','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65116','31969','1','20','10m','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65117','31971','1','21',E'var Ami = {
    params: {
        url: ''{$AMI.URL}'',
        trunk: ''{$AMI.TRUNK_REGEXP}''
    },
    api_request: new CurlHttpRequest(),

    request: function (url, action) {
        url += action;
        Zabbix.Log(4, ''[ Asterisk ] Sending request: '' + url);
        try {
            response = Ami.api_request.Get(url);
        } catch (error) {
            Zabbix.Log(4, ''[ Asterisk ] Get request returned error '' + error);
            throw ''Get request returned error '' + error + ''. Check debug log for more information.'';
        }
        Zabbix.Log(4, ''[ Asterisk ] Received response with status code '' +
            Ami.api_request.Status() + ''\\n'' + response);

        if (Ami.api_request.Status() !== 200) {
            var message = ''Request failed with status code '' + Ami.api_request.Status();
            if (response !== null) {
                if (typeof response.message === ''string'') {
                    message += '': '' + response.message;
                }
            }

            throw message + '' Check debug log for more information.'';
        }

        var match = response.match(''Response: (.+)\\r\\n'');
        if (match !== null && match[1] !== ''Success'' && match[1] !== ''Goodbye'' && match[1] !== ''Follows'') {
            var message = ''Request failed with message '' + match[1];

            match = response.match(''Message: (.+)\\r\\n'');
            if (match !== null && match[1]) {
                message += '': '' + match[1];
            }

            throw message + ''. Check debug log for more information.'';
        }

        return {
            status: Ami.api_request.Status(),
            body: response
        };
    }
};

var asterisk = {
    version: '''',
    uptime: 0,
    uptime_reload: 0,
    active_channels: 0,
    active_calls: 0,
    calls_processed: 0,
    sip: {
        trunks: [],
        monitored_online: 0,
        monitored_offline: 0,
        unmonitored_online: 0,
        unmonitored_offline: 0,
        total: 0
    },
    iax: {
        trunks: [],
        online: 0,
        offline: 0,
        unmonitored: 0,
        total: 0
    },
    pjsip: {
        trunks: [],
        available: 0,
        unavailable: 0,
        total: 0
    },
    queue: {
        queues: [],
        total: 0
    }
};

function block2Object(text) {
    var fields = [],
        dict = {};

    text.split(''\\r\\n'').forEach(function (line) {
        fields = line.split('': '');
        dict[fields[0]] = fields[1];
    })

    return dict;
}

function text2Object(text) {
    var blocks = text.split(''\\r\\n\\r\\n''),
        arr = [],
        i = 1,
        j = blocks.length - 2;

    for (i; i < j; i++) {
        arr.push(block2Object(blocks[i]));
    }

    return arr;
}

function getSipPeers() {
    var response = Ami.request(url, ''SIPpeers''),
        elements = text2Object(response.body);
    asterisk.sip.total = elements.length;
    asterisk.sip.trunks = elements.filter(function (element) {
        return element.ObjectName.search(Ami.params.trunk) != -1;
    });
    elements.forEach(function (element) {
        if (element.IPaddress === ''-none-'') {
            switch (element.Status) {
                case ''Unmonitored'':
                    asterisk.sip.unmonitored_offline++;
                    break;

                case ''UNKNOWN'':
                    asterisk.sip.monitored_offline++;
                    break;
            }
        }
        else {
            if (element.Status === ''Unmonitored'') {
                asterisk.sip.unmonitored_online++;
            }
            else {
                asterisk.sip.monitored_online++;
                if (element.Status.search(''^OK'') != -1) {
                    element.Status = element.Status.split('' '')[0];
                }
            }
        }
    });
    asterisk.sip.trunks.forEach(function (trunk) {
        var active_channels = channels.match(new RegExp('' SIP/'' + trunk.ObjectName.split(''/'')[0], ''g''));
        trunk.active_channels = (active_channels === null) ? 0 : active_channels.length;
    });
}

function getIaxPeerList() {
    response = Ami.request(url, ''IAXpeerlist'');
    elements = text2Object(response.body);
    asterisk.iax.total = elements.length;
    asterisk.iax.trunks = elements.filter(function (element) {
        return element.ObjectName.search(Ami.params.trunk) != -1;
    });
    elements.forEach(function (element) {
        if (element.Status.search(''^OK'') != -1) {
            element.Status = element.Status.split('' '')[0];
        }
        switch (element.Status) {
            case ''Unmonitored'':
                asterisk.iax.unmonitored++;
                break;

            case ''UNKNOWN'':
                asterisk.iax.offline++;
                break;
        }
    });
    asterisk.iax.online = asterisk.iax.total - asterisk.iax.offline;
    asterisk.iax.trunks.forEach(function (trunk) {
        var active_channels = channels.match(new RegExp(''( IAX2/'' + trunk.ObjectName.split(''/'')[0] +
            ''| IAX2/'' + trunk.ObjectUsername + '')'', ''g''));
        trunk.active_channels = (active_channels === null) ? 0 : active_channels.length;
    });
}

function getPjsipShowEndpoints() {
    response = Ami.request(url, ''PJSIPShowEndpoints'');
    elements = text2Object(response.body);
    asterisk.pjsip.total = elements.length;
    asterisk.pjsip.trunks = elements.filter(function (element) {
        return element.ObjectName.search(Ami.params.trunk) != -1;
    });

    elements.forEach(function (element) {
        if (element.DeviceState === ''Unavailable'') {
            asterisk.pjsip.unavailable++;
        }
    });
    asterisk.pjsip.available = asterisk.pjsip.total - asterisk.pjsip.unavailable;
    asterisk.pjsip.trunks.forEach(function (trunk) {
        var active_channels = channels.match(new RegExp('' PJSIP/'' + trunk.ObjectName.split(''/'')[0], ''g''));
        trunk.active_channels = (active_channels === null) ? 0 : active_channels.length;
    });
}

function getQueueSummary() {
    response = Ami.request(url, ''QueueSummary'');
    asterisk.queue.queues = text2Object(response.body);
    asterisk.queue.total = asterisk.queue.queues.length;
}

var cookie = value.match(/mansession_id="([0-9A-z]+)"/);
if (cookie == null) {
    throw ''Cannot find mansession_id with cookie in response.'';
}

var url = Ami.params.url.split(''?'')[0] + ''?action='';

Ami.api_request.AddHeader(''Cookie: mansession_id="'' + cookie[1] + ''"'');

var response = Ami.request(url, ''CoreSettings'');
var coreSettings = block2Object(response.body);
if (typeof coreSettings.AsteriskVersion !== ''undefined'') {
    asterisk.version = coreSettings.AsteriskVersion;
}

response = Ami.request(url, ''CoreStatus'');
var coreStatus = block2Object(response.body);
if (typeof coreStatus.CoreStartupDate !== ''undefined'') {
    asterisk.uptime = (Date.now() - Date.parse(coreStatus.CoreStartupDate + " " + coreStatus.CoreStartupTime)) / 1000;
}
if (typeof coreStatus.CoreReloadDate !== ''undefined'') {
    asterisk.uptime_reload = (Date.now() - Date.parse(coreStatus.CoreReloadDate + " " + coreStatus.CoreReloadTime)) / 1000;
}

response = Ami.request(url, ''command&command=core%20show%20channels'');
channels = response.body;
var fields = {
    active_channels: ''active channels?'',
    active_calls: ''active calls?'',
    calls_processed: ''calls? processed''
};

Object.keys(fields).forEach(function (field) {
    var match = channels.match(''(\\\\d+) '' + fields[field]);
    if (match !== null && typeof match[1] !== ''undefined'') {
        asterisk[field] = parseInt(match[1]);
    }
});

response = Ami.request(url, ''ListCommands'');
var list = response.body;
if (list.includes(''SIPpeers'')) {
    getSipPeers();
}
if (list.includes(''IAXpeerlist'')) {
    getIaxPeerList();
}
if (list.includes(''PJSIPShowEndpoints'')) {
    getPjsipShowEndpoints();
}
if (list.includes(''QueueSummary'')) {
    getQueueSummary();
}

try {
    response = Ami.request(url, ''Logoff'');
}
catch (e) {}

return JSON.stringify(asterisk);
','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65118','31972','1','12','$.sip.total','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65119','31973','1','12','$.version','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65120','31974','1','12','$.uptime_reload','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65121','31975','1','12','$.uptime','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65122','31976','1','12','$.queue.total','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65123','31977','1','12','$.sip.unmonitored_online','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65124','31978','1','12','$.sip.unmonitored_offline','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65125','31979','1','12','$.active_calls','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65126','31980','1','12','$.sip.monitored_online','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65127','31981','1','12','$.active_channels','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65128','31982','1','12','$.pjsip.unavailable','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65129','31983','1','12','$.pjsip.total','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65130','31984','1','12','$.iax.unmonitored','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65131','31985','1','12','$.iax.total','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65132','31986','1','12','$.iax.offline','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65133','31987','1','12','$.calls_processed','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65134','31987','2','10','','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65135','31988','1','12','$.calls_processed','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65136','31989','1','12','$.sip.monitored_offline','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65137','31990','1','12','$.iax.trunks','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65138','31990','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65139','31991','1','12','$.pjsip.trunks','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65140','31991','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65141','31992','1','12','$.queue.queues','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65142','31992','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65143','31993','1','12','$.sip.trunks','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65144','31993','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65145','31994','1','12','$.iax.trunks[?(@.ObjectName==''{#OBJECTNAME}'')].active_channels.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65146','31995','1','12','$.iax.trunks[?(@.ObjectName==''{#OBJECTNAME}'')].Status.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65147','31995','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65148','31996','1','12','$.pjsip.trunks[?(@.ObjectName==''{#OBJECTNAME}'')].active_channels.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65149','31997','1','12','$.pjsip.trunks[?(@.ObjectName==''{#OBJECTNAME}'')].DeviceState.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65150','31997','2','20','1h','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65151','31998','1','12','$.queue.queues[?(@.Queue==''{#QUEUE}'')].Available.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65152','31999','1','12','$.queue.queues[?(@.Queue==''{#QUEUE}'')].Callers.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65153','32000','1','12','$.queue.queues[?(@.Queue==''{#QUEUE}'')].LoggedIn.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65154','32001','1','12','$.sip.trunks[?(@.ObjectName==''{#OBJECTNAME}'')].active_channels.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65155','32002','1','12','$.sip.trunks[?(@.ObjectName==''{#OBJECTNAME}'')].Status.first()','0','');
INSERT INTO item_preproc (item_preprocid,itemid,step,type,params,error_handler,error_handler_params) values ('65156','32002','2','20','1h','0','');
INSERT INTO sysmap_shape (sysmap_shapeid,sysmapid,type,x,y,width,height,text,font,font_size,font_color,text_halign,text_valign,border_type,border_width,border_color,background_color,zindex) values ('1','1','0','0','0','680','15','{MAP.NAME}','9','11','000000','0','0','0','0','000000','','0');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('1','29429','{#IFNAME}','$.labels.device');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('2','29429','{#HELP}','$.help');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('3','29429','{#IFALIAS}','$.labels.ifalias');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('4','29429','{#IFOPERSTATUS}','$.labels.operstate');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('5','29430','{#FSTYPE}','$.labels.fstype');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('6','29430','{#FSNAME}','$.labels.mountpoint');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('7','29430','{#FSDEVICE}','$.labels.device');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('8','29430','{#HELP}','$.help');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('9','29431','{#DEVNAME}','$.labels.device');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('10','29431','{#HELP}','$.help');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('38','29703','{#QUEUE}','$.name');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('39','29703','{#VHOST}','$.vhost');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('40','29703','{#NODE}','$.node');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('41','29785','{#EXCHANGE}','$.name');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('42','29785','{#TYPE}','$.type');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('43','29785','{#VHOST}','$.vhost');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('44','29786','{#QUEUE}','$.name');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('45','29786','{#VHOST}','$.vhost');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('46','29786','{#NODE}','$.node');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('47','30026','{#EXCHANGE}','$.name');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('48','30026','{#TYPE}','$.type');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('49','30026','{#VHOST}','$.vhost');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('50','30193','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('51','30193','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('52','30194','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('53','30194','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('54','30195','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('55','30195','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('56','30236','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('57','30236','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('58','30237','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('59','30237','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('60','30238','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('61','30238','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('62','30678','{#DATABASE}','$.Database');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('63','30679','{#MASTER_HOST}','$.Master_Host');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('64','30686','{#SENSOR_ID}','$.id');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('65','30686','{#SENSOR_READING_TYPE}','$.reading.text');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('66','30686','{#SENSOR_TYPE}','$.sensor.text');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('67','30686','{#SENSOR_UNIT}','$.units');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('68','30687','{#SENSOR_ID}','$.id');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('69','30687','{#SENSOR_READING_TYPE}','$.reading.text');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('70','30687','{#SENSOR_TYPE}','$.sensor.text');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('71','30687','{#SENSOR_UNIT}','$.units');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('72','30687','{#SENSOR_LO_WARN}','$.threshold.lower.non_crit');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('73','30687','{#SENSOR_LO_CRIT}','$.threshold.lower.crit');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('74','30687','{#SENSOR_LO_DISAST}','$.threshold.lower.non_recover');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('75','30687','{#SENSOR_HI_WARN}','$.threshold.upper.non_crit');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('76','30687','{#SENSOR_HI_CRIT}','$.threshold.upper.crit');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('77','30687','{#SENSOR_HI_DISAST}','$.threshold.upper.non_recover');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('78','30713','{#ES.NODE}','$..name.first()');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('79','30759','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('80','30759','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('81','30759','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('82','30760','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('83','30760','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('84','30760','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('85','30761','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('86','30761','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('87','30761','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('88','30193','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('89','30194','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('90','30195','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('91','30791','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('92','30791','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('93','30791','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('94','30792','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('95','30792','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('96','30792','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('97','30793','{#PXNAME}','$.pxname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('98','30793','{#SVNAME}','$.svname');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('99','30793','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('100','30236','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('101','30237','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('102','30238','{#MODE}','$.mode');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('103','30874','{#NAME}','$.name');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('104','30875','{#DB}','$.database');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('105','30875','{#TABLE}','$.table');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('106','30876','{#DB}','$.database');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('107','30876','{#TABLE}','$.table');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('108','30962','{#ETCD.PEER}','$.labels.To');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('109','31005','{#APPPOOL}','$.Name');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('110','31047','{#APPPOOL}','$.Name');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('111','31990','{#OBJECTNAME}','$.ObjectName');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('112','31991','{#OBJECTNAME}','$.ObjectName');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('113','31992','{#QUEUE}','$.Queue');
INSERT INTO lld_macro_path (lld_macro_pathid,itemid,lld_macro,path) values ('114','31993','{#OBJECTNAME}','$.ObjectName');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('34','30961','trigger','1','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('35','28306','trigger THRESHOLD_LO_WARN','1','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('36','28306','trigger THRESHOLD_LO_CRIT','2','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('37','28306','trigger THRESHOLD_HI_WARN','3','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('38','28306','trigger THRESHOLD_HI_CRIT','4','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('39','28307','trigger THRESHOLD_LO_WARN','1','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('40','28307','trigger THRESHOLD_LO_CRIT','2','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('41','28307','trigger THRESHOLD_HI_WARN','3','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('42','28307','trigger THRESHOLD_HI_CRIT','4','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('43','32306','trigger THRESHOLD_LO_WARN','1','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('44','32306','trigger THRESHOLD_LO_CRIT','2','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('45','32306','trigger THRESHOLD_HI_WARN','3','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('46','32306','trigger THRESHOLD_HI_CRIT','4','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('47','30687','trigger SENSOR_LO_WARN','1','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('48','30687','trigger SENSOR_LO_CRIT','2','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('49','30687','trigger SENSOR_LO_DISAST','3','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('50','30687','trigger SENSOR_HI_WARN','4','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('51','30687','trigger SENSOR_HI_CRIT','5','0','','0');
INSERT INTO lld_override (lld_overrideid,itemid,name,step,evaltype,formula,stop) values ('52','30687','trigger SENSOR_HI_DISAST','6','0','','0');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('14','34','8','{#GRPC.CODE}','{$ETCD.GRPC_CODE.TRIGGER.MATCHES}');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('15','35','8','{#THRESHOLD_LO_WARN}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('16','36','8','{#THRESHOLD_LO_CRIT}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('17','37','8','{#THRESHOLD_HI_WARN}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('18','38','8','{#THRESHOLD_HI_CRIT}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('19','39','8','{#THRESHOLD_LO_WARN}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('20','40','8','{#THRESHOLD_LO_CRIT}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('21','41','8','{#THRESHOLD_HI_WARN}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('22','42','8','{#THRESHOLD_HI_CRIT}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('23','43','8','{#THRESHOLD_LO_WARN}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('24','44','8','{#THRESHOLD_LO_CRIT}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('25','45','8','{#THRESHOLD_HI_WARN}','^$');
INSERT INTO lld_override_condition (lld_override_conditionid,lld_overrideid,operator,macro,value) values ('26','46','8','{#THRESHOLD_HI_CRIT}','^$');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('34','34','1','2','Too many failed gRPC requests');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('35','35','1','8','Temperature is below the warning threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('36','36','1','8','Temperature is below the critical threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('37','37','1','8','Temperature is above the warning threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('38','38','1','8','Temperature is above the critical threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('39','39','1','8','Fan speed is below the warning threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('40','40','1','8','Fan speed is below the critical threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('41','41','1','8','Fan speed is above the warning threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('42','42','1','8','Fan speed is above the critical threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('43','43','1','8','Voltage is below the warning threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('44','44','1','8','Voltage is below the critical threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('45','45','1','8','Voltage is above the warning threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('46','46','1','8','Voltage is above the critical threshold');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('47','47','1','2','{#SENSOR_LO_WARN}');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('48','48','1','2','{#SENSOR_LO_CRIT}');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('49','49','1','2','{#SENSOR_LO_DISAST}');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('50','50','1','2','{#SENSOR_HI_WARN}');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('51','51','1','2','{#SENSOR_HI_CRIT}');
INSERT INTO lld_override_operation (lld_override_operationid,lld_overrideid,operationobject,operator,value) values ('52','52','1','2','{#SENSOR_HI_DISAST}');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('34','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('35','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('36','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('37','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('38','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('39','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('40','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('41','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('42','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('43','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('44','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('45','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('46','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('47','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('48','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('49','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('50','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('51','0');
INSERT INTO lld_override_opstatus (lld_override_operationid,status) values ('52','0');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('34','0');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('35','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('36','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('37','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('38','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('39','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('40','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('41','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('42','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('43','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('44','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('45','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('46','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('47','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('48','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('49','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('50','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('51','1');
INSERT INTO lld_override_opdiscover (lld_override_operationid,discover) values ('52','1');
INSERT INTO dashboard (dashboardid,name,userid,private) values ('1','Global view','1','0');
INSERT INTO dashboard (dashboardid,name,userid,private) values ('2','Zabbix server health','1','1');
INSERT INTO dashboard_usrgrp (dashboard_usrgrpid,dashboardid,usrgrpid,permission) values ('1','2','7','3');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('1','1','systeminfo','','0','0','8','4','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('2','1','hostavail','','8','0','12','2','1');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('3','1','problemsbysv','','8','2','12','2','1');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('4','1','clock','','20','0','4','4','1');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('5','1','problems','','0','4','20','10','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('6','1','favmaps','','20','4','4','5','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('7','1','favgraphs','','20','9','4','5','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('8','2','problems','Zabbix server problems','0','0','20','4','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('9','2','clock','Local time','20','0','4','4','1');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('10','2','svggraph','Values processed per second','0','4','8','5','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('11','2','svggraph','Utilization of data collectors','8','4','8','5','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('12','2','svggraph','Utilization of internal processes','16','4','8','5','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('13','2','svggraph','Cache usage','0','9','8','5','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('14','2','svggraph','Value cache effectiveness','8','9','8','5','0');
INSERT INTO widget (widgetid,dashboardid,type,name,x,y,width,height,view_mode) values ('15','2','svggraph','Queue size','16','9','8','5','0');
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('1','2','0','interface_type','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('2','3','0','show_type','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('3','5','0','show','3','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('4','5','0','show_tags','3','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('5','8','3','hostids','0','',NULL,'10084',NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('6','10','0','ds.axisy.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('7','10','0','ds.fill.0','3','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('8','10','0','ds.missingdatafunc.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('9','10','0','ds.transparency.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('10','10','0','ds.type.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('11','10','0','ds.width.0','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('12','10','0','graph_item_problems','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('13','10','0','legend','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('14','10','0','righty','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('15','10','0','show_problems','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('16','10','1','ds.color.0','0','00BFFF',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('17','10','1','ds.hosts.0.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('18','10','1','ds.items.0.0','0','Number of processed *values per second',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('19','10','1','ds.timeshift.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('20','10','1','lefty_min','0','0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('21','10','1','problemhosts.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('22','11','0','ds.axisy.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('23','11','0','ds.fill.0','3','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('24','11','0','ds.missingdatafunc.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('25','11','0','ds.transparency.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('26','11','0','ds.type.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('27','11','0','ds.width.0','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('28','11','0','graph_item_problems','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('29','11','0','legend','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('30','11','0','righty','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('31','11','0','show_problems','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('32','11','1','ds.color.0','0','E57373',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('33','11','1','ds.hosts.0.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('34','11','1','ds.items.0.0','0','Utilization of * data collector *',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('35','11','1','ds.timeshift.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('36','11','1','lefty_max','0','100',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('37','11','1','lefty_min','0','0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('38','11','1','problemhosts.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('39','12','0','ds.axisy.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('40','12','0','ds.fill.0','3','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('41','12','0','ds.missingdatafunc.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('42','12','0','ds.transparency.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('43','12','0','ds.type.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('44','12','0','ds.width.0','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('45','12','0','graph_item_problems','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('46','12','0','legend','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('47','12','0','righty','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('48','12','0','show_problems','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('49','12','1','ds.color.0','0','E57373',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('50','12','1','ds.hosts.0.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('51','12','1','ds.items.0.0','0','Utilization of * internal *',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('52','12','1','ds.timeshift.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('53','12','1','lefty_max','0','100',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('54','12','1','lefty_min','0','0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('55','12','1','problemhosts.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('56','13','0','ds.axisy.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('57','13','0','ds.fill.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('58','13','0','ds.missingdatafunc.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('59','13','0','ds.transparency.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('60','13','0','ds.type.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('61','13','0','ds.width.0','2','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('62','13','0','graph_item_problems','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('63','13','0','legend','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('64','13','0','righty','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('65','13','0','show_problems','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('66','13','1','ds.color.0','0','4DB6AC',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('67','13','1','ds.hosts.0.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('68','13','1','ds.items.0.0','0','Zabbix*cache*% used',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('69','13','1','ds.timeshift.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('70','13','1','lefty_max','0','100',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('71','13','1','lefty_min','0','0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('72','13','1','problemhosts.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('73','14','0','ds.axisy.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('74','14','0','ds.axisy.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('75','14','0','ds.fill.0','3','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('76','14','0','ds.fill.1','3','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('77','14','0','ds.missingdatafunc.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('78','14','0','ds.missingdatafunc.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('79','14','0','ds.transparency.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('80','14','0','ds.transparency.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('81','14','0','ds.type.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('82','14','0','ds.type.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('83','14','0','ds.width.0','2','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('84','14','0','ds.width.1','2','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('85','14','0','graph_item_problems','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('86','14','0','legend','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('87','14','0','righty','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('88','14','0','show_problems','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('89','14','1','ds.color.0','0','9CCC65',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('90','14','1','ds.color.1','0','FF465C',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('91','14','1','ds.hosts.0.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('92','14','1','ds.hosts.1.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('93','14','1','ds.items.0.0','0','Zabbix value cache hits',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('94','14','1','ds.items.1.0','0','Zabbix value cache misses',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('95','14','1','ds.timeshift.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('96','14','1','ds.timeshift.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('97','14','1','lefty_min','0','0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('98','14','1','problemhosts.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('99','15','0','ds.axisy.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('100','15','0','ds.axisy.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('101','15','0','ds.axisy.2','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('102','15','0','ds.fill.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('103','15','0','ds.fill.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('104','15','0','ds.fill.2','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('105','15','0','ds.missingdatafunc.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('106','15','0','ds.missingdatafunc.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('107','15','0','ds.missingdatafunc.2','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('108','15','0','ds.transparency.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('109','15','0','ds.transparency.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('110','15','0','ds.transparency.2','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('111','15','0','ds.type.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('112','15','0','ds.type.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('113','15','0','ds.type.2','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('114','15','0','ds.width.0','2','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('115','15','0','ds.width.1','2','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('116','15','0','ds.width.2','2','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('117','15','0','graph_item_problems','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('118','15','0','legend','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('119','15','0','righty','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('120','15','0','show_problems','1','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('121','15','1','ds.color.0','0','B0AF07',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('122','15','1','ds.color.1','0','E53935',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('123','15','1','ds.color.2','0','0275B8',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('124','15','1','ds.hosts.0.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('125','15','1','ds.hosts.1.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('126','15','1','ds.hosts.2.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('127','15','1','ds.items.0.0','0','Zabbix queue',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('128','15','1','ds.items.1.0','0','Zabbix queue over 10 minutes',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('129','15','1','ds.items.2.0','0','Zabbix preprocessing queue',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('130','15','1','ds.timeshift.0','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('131','15','1','ds.timeshift.1','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('132','15','1','ds.timeshift.2','0','',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('133','15','1','lefty_min','0','0',NULL,NULL,NULL,NULL,NULL);
INSERT INTO widget_field (widget_fieldid,widgetid,type,name,value_int,value_str,value_groupid,value_hostid,value_itemid,value_graphid,value_sysmapid) values ('134','15','1','problemhosts.0','0','Zabbix server',NULL,NULL,NULL,NULL,NULL);