Group Status View

i was trying out some simple query but i am not able to display the icon. Even if i try just for group status and not group members i still don;t see the icons.. just the path.

SELECT n.Name, n.DetailsUrl AS [_LinkFor_Caption],  n.status,

CASE when status = 1 then '/Orion/images/StatusIcons/Small-Up.gif'

END as ICON

FROM Orion.Groups n left join Orion.ContainerMemberSnapshots s on n.Uri=s.MemberUri where s.ContainerID=66

Seems like you are pretty out in the weeds with this, try this

SELECT Name, DetailsUrl as [_linkfor_Name], StatusDescription as Status, '/Orion/images/StatusIcons/Small-' + statusdescription + '.gif' as [_iconfor_Status]

FROM Orion.Container

Do you have SWQL studio installed on your orion server?  It makes a huge difference in being able to put these queries together.

Releases · solarwinds/OrionSDK · GitHub

Hi mesverrum ... thank you.. it worked.. i really am not good with coding.. had been struggling to get it right for a while now.. is it possible to get something like my first image in this post where it shows availability, health and monitors in error.. My goal here is to create a business view for our critical services. I am creating a parent group and adding several sub groups under it for application, databases and URL so if my service is having a problem then it will show whether the problem is in database or application or server itself. can u help me with it please ??

Hi mesverrum ... thank you.. it worked.. i really am not good with coding.. had been struggling to get it right for a while now.. is it possible to get something like my first image in this post where it shows availability, health and monitors in error.. My goal here is to create a business view for our critical services. I am creating a parent group and adding several sub groups under it for application, databases and URL so if my service is having a problem then it will show whether the problem is in database or application or server itself. can u help me with it please ??

It's doable, I have a query i wrote before that displays counts of servers in different states, its not exactly what you need but the SQL technique would be similar, adding nested select statements into the previous query i gave and maybe joining it from the containermembers table for the status.

SELECT Count(*) as TOTAL

,'/Orion/images/StatusIcons/ContainerMembers/DefaultIcon.gif' as [_iconfor_TOTAL]

,'/orion/nodes/default.aspx' as [_linkfor_TOTAL]

,(SELECT Count(*) as UP FROM Orion.Nodes Where Status = 1) as UP

, '/Orion/images/StatusIcons/Small-Up.gif' as [_iconfor_UP]

,(SELECT Count(*) as DOWN FROM Orion.Nodes Where Status = 2) as DOWN

,'/Orion/images/StatusIcons/Small-Down.gif' as [_iconfor_DOWN]

,(SELECT Count(*) as UNMANAGED FROM Orion.Nodes Where Status = 9) as UNMANAGED

,'/Orion/images/StatusIcons/Small-Unmanaged.gif' as [_iconfor_UNMANAGED]

,(SELECT Count(*) as OTHER FROM Orion.Nodes Where Status not in (1,2,9)) as OTHER

,'/Orion/images/StatusIcons/Small-NotRunning.gif' as [_iconfor_OTHER]

FROM Orion.Nodes

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

•                 LinkedIN: Loop1 Systems
•                 Facebook: Loop1 Systems
•                 Twitter: @Loop1Systems