Hello Guys!
I need to extract a specific group of devices which i placed in custom property of said devices. Can anyone help me,
They below Query is showing all over hardware i just need display only datacenter `s equipment
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
