interesting....
I have run your raw data through the Automat script parser and this is what I get back.
( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Management Module 6:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 7:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 7:2', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:2', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:3', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:4', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:5', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:6', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 16:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 16:2', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 16:3', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Hardware Management Controller (Node 0)', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'HP Smart Array P440ar RAID Controller : Embedded : HPSA1', '20')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 1 PwrMeter Output', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 1 Power Meter', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 PS 2 Output', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 Power Supply 2: Failure status', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 Power Supply 2: Power Supply AC lost', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 PS 1 Output', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 Power Supply 1: Failure status', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 Power Supply 1: Power Supply AC lost', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 7 Fan 7 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 7 Fan 7', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 6 Fan 6 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 6 Fan 6', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 5 Fan 5 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 5 Fan 5', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 4 Fan 4 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 4 Fan 4', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 3 Fan 3 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 3 Fan 3', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 3 37-Fuse', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery 2 36-Storage Batt', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 4 35-I/O Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 6 34-HD Cntlr Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 2 32-PCI 2 Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 1 31-PCI 1 Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Management Module 1 30-iLO Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery 1 29-Battery Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 3 28-P/S 2 Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 2 27-Front Ambient', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 4 24-HD Controller', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 20-PS 2 Internal', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 19-PS 1 Internal', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Module (DC-to-DC) 4 16-VR P1 Mem', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Module (DC-to-DC) 3 15-VR P1 Mem', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Module (DC-to-DC) 1 13-VR P1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 12-PS 2 Inlet', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 11-PS 1 Inlet', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 1 10-Chipset', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 08-HD Max', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Memory Device 2 05-P1 DIMM 7-12', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Memory Device 1 04-P1 DIMM 1-6', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 1 02-CPU 1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 1 01-Inlet Ambient', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Proc 1 Level-2 Cache', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Proc 1 Level-3 Cache', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Memory', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Proc 1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'IPMI SEL', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 2 Memory Status: Uncorrectable ECC', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 2 Memory Status: Correctable ECC logging limit reached', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery 1 Megacell Status: Failed', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 8 Fans', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 3 Power Supplies', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 7 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 7', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 6 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 6', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 5 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 5', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 4 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 4', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 3 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 3', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 1 on HPSA1 : Port 1I Box 1 Bay 1 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 2 on HPSA1 : Port 1I Box 1 Bay 2 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 3 on HPSA1 : Port 1I Box 1 Bay 3 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 4 on HPSA1 : Port 1I Box 1 Bay 4 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 5 on HPSA1 : Port 2I Box 1 Bay 5 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 6 on HPSA1 : Port 2I Box 1 Bay 6 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 7 on HPSA1 : Port 2I Box 1 Bay 7 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 8 on HPSA1 : Port 2I Box 1 Bay 8 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'HP Smart Array P440ar RAID Controller : Embedded : HPSA1', '20')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Logical Volume 1 on HPSA1 : RAID 1 + 0 : 3353GB : Disk 1,2,3,4,5,6,7,8', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery on HPSA1', '0')
As you see above we have a line for the failed array going into your database as a query.
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'HP Smart Array P440ar RAID Controller : Embedded : HPSA1', '20')
So for that not to be there in the table when you go to read it out is a scratch you head moment.
But,
I suspect that its the "Ignore" in our SQL statement that would allow record to be discarded if it did not meet table requirements.
Code: Select all
INSERT IGNORE INTO `plugin_p4l_vmware_healthmon_cimdata` (`ClientID`,`LocationID`,`ProbeID`,`ESXHost`,`CIM_Item`,`CIM_Value`) VALUES @CIMSQLDATA@ ON DUPLICATE KEY UPDATE CIM_Value=VALUES(CIM_Value)
So lets try this, Place the following code block into your SQL Yog and execute the sql query, see if it yells at you for any reason. If not, go check you CIM data in the plugin now for this item to be available. otherwise I suspect you will receive an error for some reason,
Code: Select all
INSERT INTO `plugin_p4l_vmware_healthmon_cimdata` (`ClientID`,`LocationID`,`ProbeID`,`ESXHost`,`CIM_Item`,`CIM_Value`) VALUES
( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Management Module 6:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 7:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 7:2', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:2', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:3', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:4', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:5', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 11:6', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 16:1', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 16:2', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 16:3', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Hardware Management Controller (Node 0)', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'HP Smart Array P440ar RAID Controller : Embedded : HPSA1', '20')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 1 PwrMeter Output', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 1 Power Meter', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 PS 2 Output', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 Power Supply 2: Failure status', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 Power Supply 2: Power Supply AC lost', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 PS 1 Output', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 Power Supply 1: Failure status', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 Power Supply 1: Power Supply AC lost', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 7 Fan 7 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 7 Fan 7', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 6 Fan 6 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 6 Fan 6', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 5 Fan 5 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 5 Fan 5', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 4 Fan 4 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 4 Fan 4', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 3 Fan 3 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 3 Fan 3', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 3 37-Fuse', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery 2 36-Storage Batt', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 4 35-I/O Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 6 34-HD Cntlr Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 2 32-PCI 2 Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Internal Expansion Board 1 31-PCI 1 Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Management Module 1 30-iLO Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery 1 29-Battery Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 3 28-P/S 2 Zone', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 2 27-Front Ambient', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Add-in Card 4 24-HD Controller', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 20-PS 2 Internal', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 19-PS 1 Internal', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Module (DC-to-DC) 4 16-VR P1 Mem', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Module (DC-to-DC) 3 15-VR P1 Mem', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Module (DC-to-DC) 1 13-VR P1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2 12-PS 2 Inlet', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1 11-PS 1 Inlet', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 1 10-Chipset', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 08-HD Max', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Memory Device 2 05-P1 DIMM 7-12', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Memory Device 1 04-P1 DIMM 1-6', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 1 02-CPU 1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Other 1 01-Inlet Ambient', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Proc 1 Level-2 Cache', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Proc 1 Level-3 Cache', '0')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Memory', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Proc 1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'IPMI SEL', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 8 C1 P2I Bay 8: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 7 C1 P2I Bay 7: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 6 C1 P2I Bay 6: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 5 C1 P2I Bay 5: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 4 C1 P1I Bay 4: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 3 C1 P1I Bay 3: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 2 C1 P1I Bay 2: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Drive Fault', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Predictive Failure', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Parity Check In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: In Critical Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: In Failed Array', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Rebuild In Progress', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk or Disk Bay 1 C1 P1I Bay 1: Rebuild Aborted', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 2 Memory Status: Uncorrectable ECC', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'System Board 2 Memory Status: Correctable ECC logging limit reached', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery 1 Megacell Status: Failed', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan Device 8 Fans', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 3 Power Supplies', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 7 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 7', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 6 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 6', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 5 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 5', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 4 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 4', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 3 DutyCycle', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Fan 3', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 1', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Power Supply 2', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 1 on HPSA1 : Port 1I Box 1 Bay 1 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 2 on HPSA1 : Port 1I Box 1 Bay 2 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 3 on HPSA1 : Port 1I Box 1 Bay 3 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 4 on HPSA1 : Port 1I Box 1 Bay 4 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 5 on HPSA1 : Port 2I Box 1 Bay 5 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 6 on HPSA1 : Port 2I Box 1 Bay 6 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 7 on HPSA1 : Port 2I Box 1 Bay 7 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Disk 8 on HPSA1 : Port 2I Box 1 Bay 8 : 838GB : Data Disk', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'HP Smart Array P440ar RAID Controller : Embedded : HPSA1', '20')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Logical Volume 1 on HPSA1 : RAID 1 + 0 : 3353GB : Disk 1,2,3,4,5,6,7,8', '5')
,( %clientid% , %locationid% , %computerid% , '@sqlESXHost@' , 'Battery on HPSA1', '0')
ON DUPLICATE KEY UPDATE CIM_Value=VALUES(CIM_Value)
You will need to copy the above query into a text editor and globally replace the values with real actual values of your client, location, computerid and esxhost. Esxhost must be in single ticks but clientID, LocationID and ComputerID(Probe) can be without.
%clientid% , %locationid% , %computerid% , '@sqlESXHost@'