Re: How-To Manually Test Probes
Posted: Mon Jan 30, 2023 3:25 pm
Thanks for the quick resolution.
I'll be updating the plug-in today.
I'll be updating the plug-in today.
Code: Select all
REPLACE INTO `plugin_p4l_vmware_healthmon_types` VALUES (1,'hp',0,'Unknown','Good'),(2,'hp',1,'Other','Good'),(3,'hp',2,'OK','Good'),(4,'hp',3,'Degraded','Critical'),(5,'hp',4,'Stressed','Critical'),(6,'hp',5,'OK','Good'),(7,'hp',6,'Error','Critical'),(8,'hp',7,'Non-Recoverable Error','Critical'),(9,'hp',8,'Starting','Good'),(10,'hp',9,'Stopping','Warning'),(11,'hp',10,'Stopped','Warning'),(12,'hp',11,'In Service','Good'),(13,'hp',12,'No Contact','Warning'),(14,'hp',13,'Lost Communication','Critical'),(15,'hp',14,'Aborted','Critical'),(16,'hp',15,'Minor Failure','Critical'),(17,'hp',16,'Supporting Entity in Error','Critical'),(18,'hp',17,'Completed','Good'),(19,'hp',18,'Power Mode','Good'),(20,'hp',19,'DTMF Reserved','Good'),(21,'hp',20,'Major Failure','Critical'),(22,'dell',0,'Not Available','Good'),(23,'dell',1,'Other','Good'),(24,'dell',2,'OK','Good'),(25,'dell',3,'Degraded','Critical'),(26,'dell',4,'Stressed','Critical'),(27,'dell',5,'Predictive Failure','Warning'),(28,'dell',6,'Error','Critical'),(29,'dell',7,'Non-Recoverable Error','Critical'),(30,'dell',8,'Starting','Good'),(31,'dell',9,'Stopping','Good'),(32,'dell',10,'Stopped','Good'),(33,'dell',11,'In Service','Good'),(34,'dell',12,'No Contact','Warning'),(35,'dell',13,'Lost Communication','Critical'),(36,'dell',14,'Aborted','Critical'),(37,'dell',15,'Dormant','Good'),(38,'dell',16,'Supporting Entity in Error','Critical'),(39,'dell',17,'Completed','Good'),(40,'dell',18,'Power Mode','Good'),(41,'dell',19,'DTMF Reserved','Good'),(42,'dell',20,'Vender Reserved','Good'),(43,'intel',0,'Not Available','Good'),(44,'intel',1,'Other','Good'),(45,'intel',2,'OK','Good'),(46,'intel',3,'Degraded','Critical'),(47,'intel',4,'Stressed','Critical'),(48,'intel',5,'Predictive Failure','Warning'),(49,'intel',6,'Error','Critical'),(50,'intel',7,'Non-Recoverable Error','Critical'),(51,'intel',8,'Starting','Good'),(52,'intel',9,'Stopping','Warning'),(53,'intel',10,'Stopped','Warning'),(54,'intel',11,'In Service','Good'),(55,'intel',12,'No Contact','Warning'),(56,'intel',13,'Lost Communication','Critical'),(57,'intel',14,'Aborted','Critical'),(58,'intel',15,'Dormant','Good'),(59,'intel',16,'Supporting Entity in Error','Critical'),(60,'intel',17,'Completed','Good'),(61,'intel',18,'Power Mode','Good'),(62,'intel',19,'DTMF Reserved','Good'),(63,'intel',20,'Vender Reserved','Good'),(64,'ibm',0,'Not Available','Good'),(65,'ibm',1,'Other','Good'),(66,'ibm',2,'OK','Good'),(67,'ibm',3,'Degraded','Critical'),(68,'ibm',4,'Stressed','Critical'),(69,'ibm',5,'Predictive Failure','Warning'),(70,'ibm',6,'Error','Critical'),(71,'ibm',7,'Non-Recoverable Error','Critical'),(72,'ibm',8,'Starting','Good'),(73,'ibm',9,'Stopping','Warning'),(74,'ibm',10,'Stopped','Warning'),(75,'ibm',11,'In Service','Good'),(76,'ibm',12,'No Contact','Warning'),(77,'ibm',13,'Lost Communication','Critical'),(78,'ibm',14,'Aborted','Critical'),(79,'ibm',15,'Dormant','Good'),(80,'ibm',16,'Supporting Entity in Error','Critical'),(81,'ibm',17,'Completed','Good'),(82,'ibm',18,'Power Mode','Good'),(83,'ibm',19,'DTMF Reserved','Good'),(84,'ibm',20,'Vender Reserved','Good'),(85,'unknown',0,'Not Available','Good'),(86,'unknown',1,'Other','Good'),(87,'unknown',2,'OK','Good'),(88,'unknown',3,'Degraded','Critical'),(89,'unknown',4,'Stressed','Critical'),(90,'unknown',5,'Predictive Failure','Warning'),(91,'unknown',6,'Error','Critical'),(92,'unknown',7,'Non-Recoverable Error','Critical'),(93,'unknown',8,'Starting','Good'),(94,'unknown',9,'Stopping','Warning'),(95,'unknown',10,'Stopped','Warning'),(96,'unknown',11,'In Service','Good'),(97,'unknown',12,'No Contact','Warning'),(98,'unknown',13,'Lost Communication','Critical'),(99,'unknown',14,'Aborted','Critical'),(100,'unknown',15,'Dormant','Good'),(101,'unknown',16,'Supporting Entity in Error','Critical'),(102,'unknown',17,'Completed','Good'),(103,'unknown',18,'Power Mode','Good'),(104,'unknown',19,'DTMF Reserved','Good'),(105,'unknown',20,'Vender Reserved','Good'),(106,'auto',0,'Not Available','Good'),(107,'auto',1,'Other','Good'),(108,'auto',2,'OK','Good'),(109,'auto',3,'Degraded','Critical'),(110,'auto',4,'Stressed','Critical'),(111,'auto',5,'Predictive Failure','Warning'),(112,'auto',6,'Error','Critical'),(113,'auto',7,'Non-Recoverable Error','Critical'),(114,'auto',8,'Starting','Good'),(115,'auto',9,'Stopping','Warning'),(116,'auto',10,'Stopped','Warning'),(117,'auto',11,'In Service','Good'),(118,'auto',12,'No Contact','Warning'),(119,'auto',13,'Lost Communication','Critical'),(120,'auto',14,'Aborted','Critical'),(121,'auto',15,'Dormant','Good'),(122,'auto',16,'Supporting Entity in Error','Critical'),(123,'auto',17,'Completed','Good'),(124,'auto',18,'Power Mode','Good'),(125,'auto',19,'DTMF Reserved','Good'),(126,'auto',20,'Major Failure','Critical'),(127, 'hp', 30, 'Non-recoverable Error', 'Critical'),(128, 'hp', 25, 'Critical Failure', 'Critical');
Code: Select all
SELECT * FROM plugin_p4l_vmware_healthmon_cimdata a LEFT JOIN plugin_p4l_vmware_healthmon_types t on a.CIM_Value = t.DataValue WHERE a.ProbeID = 'Place Agent ID here that probes ESX' and a.ESXHost = 'Place ESX IP Here' and t.DataType = 'hp'
Code: Select all
SELECT * FROM plugin_p4l_vmware_healthmon_types WHERE DataType = 'hp'
Code: Select all
SELECT * FROM plugin_p4l_vmware_healthmon_cimdata a LEFT JOIN plugin_p4l_vmware_healthmon_types t on a.CIM_Value = t.DataValue WHERE a.ProbeID = 'Place Agent ID here that probes ESX' and a.ESXHost = 'Place ESX IP Here' and t.DataType = 'hp'
Code: Select all
SELECT * FROM plugin_p4l_vmware_healthmon_types WHERE DataType = 'hp'
Code: Select all
C:\Python3\Python.exe -W ignore C:\Python3\check_esxi_hardware.py -v -H -esxi101 -U root -P blank -V hp
Element Op Status = number represents the current status which in your case is "2", so all the HP add ins we did to types table has no bearing on this as 10,15,20,30 as status codes do not match status code 2. 2 is universal for "OK" or "Good". So either the python script is not getting correct vender sent to it so it mis reads CIM data or it is misreading this CIM data.20230201 11:42:59 Element Name = Battery 1 Megacell Status: Failed
20230201 11:42:59 Element Op Status = 2