The out-of-the-box resource is just too big. It takes up almost quarter of the screen. I need something compact.
select
concat(count(*),' Nodes') as [Nodes]
,sum(case when hhi.Status=1 then 1 else 0 end) as [Up]
,'/Orion/HardWareHealth/Images/Server_Small_Up.png' as [_IconFor_Up]
,'/Orion/HardwareHealth/Resources/HardwareHealthDetails.aspx?SelectedStatus=Up' as [_Linkfor_Up]
,sum(case when hhi.Status=3 then 1 else 0 end) as [Warning]
,'/Orion/HardWareHealth/Images/Server_Small_Warning.png' as [_IconFor_Warning]
,'/Orion/HardwareHealth/Resources/HardwareHealthDetails.aspx?SelectedStatus=Warning' as [_Linkfor_Warning]
,sum(case when hhi.Status=14 then 1 else 0 end) as [Critical]
,'/Orion/HardWareHealth/Images/Server_Small_Critical.png' as [_IconFor_Critical]
,'/Orion/HardwareHealth/Resources/HardwareHealthDetails.aspx?SelectedStatus=Critical' as [_Linkfor_Critical]
,sum(case when hhi.Status=2 then 1 else 0 end) as [Down]
,'/Orion/HardWareHealth/Images/Server_Small_Down.png' as [_IconFor_Down]
,'/Orion/HardwareHealth/Resources/HardwareHealthDetails.aspx?SelectedStatus=Critical' as [_Linkfor_Down]
,sum(case when hhi.Status=17 then 1 else 0 end) as [Unknown]
,'/Orion/HardWareHealth/Images/Server_Small_Unknown.png' as [_IconFor_Unknown]
,'/Orion/HardwareHealth/Resources/HardwareHealthDetails.aspx?SelectedStatus=Other' as [_Linkfor_Unknown]
from Orion.HardwareHealth.HardwareInfo hhi
order by [Nodes]
Thank you,
Amit
Loop1 systems
