A SWQL version of the health details. The advantage is that we can filter in custom properties to direct the issue to regions
SELECT
TOUPPER(SUBSTRING(hi.node.caption,1,case when charindex('.',hi.node.caption,1) <=4 then length(hi.node.caption) else (charindex('.',hi.node.caption,1)-1) end)) AS [Node Name]
,DetailsUrl AS [_LinkFor_Node Name]
,concat('/Orion/images/StatusIcons/Small-',hi.node.StatusIcon) AS [_IconFor_Node Name]
,hi.HardwareCategory.Name as [Category]
,concat('/Orion/HardwareHealth/Images/Categories/',replace(hi.HardwareCategory.Name,' ',''),'.png') as [_iconfor_Category]
,Name as [Sensor Name]
,DetailsUrl as [_linkfor_Sensor Name]
,concat('/Orion/HardwareHealth/Images/StatusIcons/Object-Sensor_',replace(hi.HardwareCategory.Name,' ',''),'-',si.StatusName,'.png') as [_iconfor_Sensor Name]
,Value as [Value]
,si.StatusName as [Status]
FROM Orion.HardwareHealth.HardwareItem hi
join orion.statusinfo si on si.StatusId=hi.Status
Thank you,
Amit Shah
Loop1 Systems
