cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 11

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

0 Kudos
7 Replies
Level 11

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

0 Kudos

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

- Marc Netterfield, Github

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

0 Kudos

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

- Marc Netterfield, Github
0 Kudos

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 ??

0 Kudos

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

- Marc Netterfield, Github
0 Kudos

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

0 Kudos