I need some help creating a report in the web-based report creator. I have an existing report that I created in report writer using the following: but it is not updating so I can trying to write the same report in web-base and can not even find half of this stuff.
SELECT
Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, APM_HardwareSensorAlertData.CategoryName AS Hardware_Type_Name, APM_HardwareSensorAlertData.SensorOrionStatus AS Hardware_Sensor_Status, APM_HardwareSensorAlertData.SensorMessage AS Hardware_Sensor_Message
FROM
Nodes INNER JOIN APM_HardwareSensorAlertData ON (Nodes.NodeID = APM_HardwareSensorAlertData.NodeId)
WHERE
(
(APM_HardwareSensorAlertData.SensorOrionStatus <> 'Warning')
)
ORDER BY 2 ASC
