Relevance - computer group membership

I’m trying to add a column to this query that will return the list of all computer groups each system is a member of. I’m struggling…

(td of (item 0 of it) & td of (item 1 of it) & td of (item 2 of it) & td of (item 3 of it) & td of (item 4 of it) & td of (item 5 of it)) of (
    name of it | "n/a",
    concatenation "; " of (names of bes computer groups of computer of it as string) | "n/a",
    concatenation "; " of (ip addresses of it as string) | "n/a",
    operating system of it | "n/a",
    relay server of it as string | "n/a",
    last report time of it as string | "n/a"
) of (
    elements of intersection of ((sets of items 0 of (computers of it , values whose (it as lowercase contains "site1") of it) of results of bes property "Subscribed Sites")))

‘it’ seems to already refer to the ‘bes computer’, so you should just need bes computer groups of it instead of bes computer groups of computer of it

1 Like

that works… i was actually pretty close this time. I’m gonna call this a win. Thanks for your help Jason.

1 Like