HWH Temperature Sensor Data Chart

Mike_Lomax

Have added that to the following "Custom Chart" widget:

And the Datasource looks like:

Query:

SELECT TOP 1000 hivs.HardwareItemID, hib.Name, hivs.ObservationTimestamp, ((hivs.AvgValue*9)/5)+32 AS AvgFValue
FROM Orion.HardwareHealth.HardwareItemValueStatistics hivs
JOIN Orion.HardwareHealth.HardwareItemBase hib ON hib.ID = hivs.HardwareItemID
WHERE hivs.HardwareItemID = 23269
ORDER BY hivs.ObservationTimestamp DESC

But am getting an error on Preview:

What do I have wrong?

Also, I would really like to add this widget only for this one Node's Node Details page.  How can I do that?

serena

Hi Mike, 

Have you tried troubleshooting the query using SWQL studio or through /orion/admin/swis.aspx in the browser? Do you get an error there?