Edit Resource - SWQL Syntax

Question

Does anyone know if you can apply "Group" SWQL syntax when filtering a resource?

Example I created a "group" Windows.  When we edit the NPM Summary page we would like to "filter" where group = 'windows'

I have tried the following which have not worked

group = 'windows'

Container.name = 'windows'

Orion.group = 'windows'

Orion.Container.name = 'windows'

Trying to get around the issue/bug with view limitations and selecting groups

Thanks

mockmyberet · Answer

There's a WHOLE bunch of caveats to this... and assumptions... and problems with doing it this way, but it's pretty much the only way to do it (that I can see, analyzing the SWQL and the DB).

mockmyberet · Answer

(SELECT GM.name FROM  dbo.Containers G inner join dbo.ContainerMemberSnapshots GM on G.ContainerID = GM.ContainerID WHERE GM.EntityDisplayName = 'Node' AND G.Name = 'Windows' AND substring(GM.MemberUri,35,45) = Nodes.NodeID) IS NOT NULL

-Drink me (put this in your filter)

petrf · Answer

Which resources do you want to filter? Unfortunately filter can differ resource by resource.