plugin_proval_ilo_health_report
Purpose
This table stores health information about HP iLO devices. It is filled by the script HP iLO - Health Report - Get and is used by the dataview HP iLO Health Report.
Dependencies
- EPM - Data Collection - Script - HP iLO - Health Report - Get
- EPM - Data Collection - Agnostic - Get-HPiLOHealthReport
Tables
plugin_proval_ilo_health_report
| Column | Type | Explanation | 
|---|---|---|
| ClientID | INT | The client ID of the scanning computer. | 
| LocationID | INT | The location ID of the scanning computer. | 
| IP | VARCHAR | The IP address of the iLO device. | 
| ConnectionStatus | VARCHAR | The returned connection status of the iLO device. | 
| HostModel | VARCHAR | The model of the host of the iLO device. | 
| HostSerialNumber | VARCHAR | The serial number of the host of the iLO device. | 
| ILOModel | VARCHAR | The model of the iLO device. | 
| ILOSerialNumber | VARCHAR | The serial number of the iLO device. | 
| ILOFirmwareRevision | VARCHAR | The firmware revision of the iLO device. | 
| AgentlessManagementService | VARCHAR | Status of the AMS. | 
| BatteryStatus | VARCHAR | Health status of the battery. | 
| BIOSHardwareStatus | VARCHAR | Health status of the BIOS hardware. | 
| FanStatus | VARCHAR | Health status of the fans. | 
| FanRedundancy | VARCHAR | Redundancy status of the fans. | 
| MemoryStatus | VARCHAR | Health status of the RAM. | 
| NetworkStatus | VARCHAR | Health status of the network card(s). | 
| PowerSuppliesStatus | VARCHAR | Health status of the PSUs. | 
| PowerSuppliesRedundancy | VARCHAR | Redundancy status of the PSUs. | 
| PowerSuppliesMismatch | VARCHAR | Shows if the PSUs are improperly paired. | 
| ProcessorStatus | VARCHAR | Health status of the CPUs. | 
| StorageStatus | VARCHAR | Health status of the storage. | 
| TemperatureStatus | VARCHAR | Health status based on the temperature. | 
| Hostname | VARCHAR | Hostname of the iLO device (if available). | 
| Status | VARCHAR | Overall status of the iLO device. | 
| StatusInfo | VARCHAR | Additional information about the overall iLO status. | 
| LastRun | DATETIME | The last time the script was run. | 
| Computerid | INT | Computer ID. |