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")))