Report showing Nodes with Hardware Problems.
Thank You for this! If I can ask one more thing... Can it show what's failed on the device as well?
Here ya go trilobite rex
Replace with this query. You can uncomment (2 sections) the Sensors_With_Status if you want the entire status
Select NodeName
, IP_Address
, Hardware_Model
, Hardware_Service_Tag
, Cast(Hardware_Status_Description As nvarchar(250)) as Hardware_Status_Description
, Sensors_With_Problems
--, Sensors_With_Status
, NodeID
From ( SELECT
Nodes.Caption AS NodeName
, Nodes.IP_Address AS IP_Address
, APM_HardwareAlertData.Model AS Hardware_Model
, APM_HardwareAlertData.ServiceTag AS Hardware_Service_Tag
, APM_HardwareAlertData.HardwareStatusDescription AS Hardware_Status_Description
, APM_HardwareAlertData.SensorsWithProblems AS Sensors_With_Problems
--,APM_HardwareAlertData.SensorsWithStatus AS Sensors_With_Status
, Nodes.NodeID AS NodeID
FROM Nodes INNER JOIN APM_HardwareAlertData ON (Nodes.NodeID = APM_HardwareAlertData.NodeId)
WHERE
(
(APM_HardwareAlertData.HardwareStatus <> 'Up') AND
(APM_HardwareAlertData.HardwareStatusDescription <> 'Could Not Poll') AND
(APM_HardwareAlertData.HardwareStatusDescription <> 'Unknown') AND
(APM_HardwareAlertData.IsPollingDisabled<>'1')
)
) As r ORDER BY 1 ASC, 3 ASC
This is great! How would i add event times to this? As in, hardware sensor memory on xyz node went critical on march 3rd 2:10PM. Idealy, with a downtime duration, like alert active for 3 days.
@rebelezna
ewwwwww.....
Don't know if I can add to this query because the "Sensors_With_Problems" has multiple results...not listed out by Sensor.
Maybe would have to rewrite to get that. Not sure.
