Group Status View

I want to create a group availability view with a custom query and would like to show group name, status (UP/Down/Critical,etc ) and also display the Status icon.

Something similar to below screenshot. Consider HTTP(s) URL as a group name. Can anyone help me achieve this ??

grop.PNG

  • 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.

    ssss.PNG

    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

  • max348

    Have a look at this post - Possible to get Status Icons in Web Report?

    And you should be able to sort it.

    Good luck emoticons_wink.png

  • 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.. is it possible to combine the SQL query and HTML/CSS to show the SQL output with some font colors or backgroud colors??

    For example i want to change the Font and color of column "Name " header for the below query. How can i achieve this??

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

    FROM Orion.Container

  • If you use the custom SWQL to feed into a custom table/report then there s an option in those that would allow you to process html,. but the basic custom query resources would ignore any formatting you try to put into it. See this thread

    Text colour to display alerts using custom query

    -Marc Netterfield

        Loop1 Systems: SolarWinds Training and Professional Services

  • 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