Help with SQSWL for Server Temperature (Modern Dashboard)

mickdon

Hi All,

Please, I need some assistance with creating a dashboard that displays some temperature data for my servers. I am a little new to SQL, so please pardon my errors. 

Thank you for your assistance. 

SWSQL Code Below 

SELECT COUNT(1) AS Value,
CASE
WHEN Value< 17 THEN 'Host Temp Cold'
WHEN Value> 27 THEN 'Host temp HOT'
ELSE 'Host temp is is Normal '

END as Icon,

CASE

WHEN value < 17 THEN 'BLUE'

WHEN value < 27 THEN 'RED'

ELSE 'GREEN' 

END AS color

FROM Orion.HardwareHealth.HardwareItem

WHERE HardwareCategoryID = 4 AND UniqueName like '%Inlet Ambient%' AND
FullyQualifiedName like '%hkhkjhk%'

OR HardwareCategoryID = 4 AND
UniqueName like '%2 38-Front Ambient%' AND FullyQualifiedName like
'%dfdfdfdf' 

adam.beedell

I think you actually want something like

SELECT top 1
CASE
WHEN Value< 17 THEN 'Host Temp Cold'
WHEN Value> 27 THEN 'Host temp HOT'
ELSE 'Host temp is is Normal '
END as Icon,

CASE
WHEN value < 17 THEN 'BLUE'
WHEN value < 27 THEN 'RED'
ELSE 'GREEN'
END AS color

FROM Orion.HardwareHealth.HardwareItem hi

WHERE
(
HardwareCategoryID = 4 AND UniqueName like '%Inlet Ambient%' AND
FullyQualifiedName like '%hkhkjhk%'
)
OR
(
HardwareCategoryID = 4 AND
UniqueName like '%2 38-Front Ambient%' AND FullyQualifiedName like
'%dfdfdfdf'
)

Where i've removed the count mostly, the count doesn't make sense currently