SWQL Custom Query - Group Container Status Icons

Without looking it up, either there's often a statusLED or something simmilar column that can be used, or you can JOIN on status to the orion.statusinfo table. I think statusdescription can have a little extra verbiage on there which doesnt allign to the filename.

If that doesnt get you there message back (or someone else will get there first)

Hi, glad you found my article at  SWQL Custom Query – Status Icons easy 

Groups are called Containers behind the GUI. So a working query looks like this:

SELECT 
    G.StatusDescription AS Status,
    G.Name AS Name,
    G.DetailsUrl AS [_LinkFor_Name],
    G.CustomProperties.Group_test_CP
    ,CONCAT('/Orion/StatusIcon.ashx?entity=Orion.Container&status=',G.Status) AS [_IconFor_Status]
FROM Orion.Groups AS G

You can see I changed your "Orion.Group" in the url to "Orion.Container". Also status should be a numeric value, status, not statusdescription. I'll update my article with some more info. (...not, that was locked for editing now....)

Also, you don't have to JOIN in CustomProperties as SWQL already know how to join them. Instead just "jump" from table to table, like I did with my test-customproperty: G.CustomProperties.Group_Test_CP

(Update the custom properties to they match your need)

Good luck!

I looked at this option too, however, for the Orion.Groups and Orion.Container tables the StatusLED columns have NULL entries so that wasn't an option.

Thanks everyone for the feedback!  The below CONCAT worked perfectly as I had hoped.

CONCAT('/Orion/StatusIcon.ashx?entity=Orion.Container&status=',G.Status) AS [_IconFor_Status]