I’m pretty new to this whole bigfix and relevance stuff, so please be kind 
I have this analysis I built, that acts on a particular bigfix group… it grabs all the local groups and their members.
I’d like to produce a report of the same data but find that using the API to pull analysis data is quite clumsy. Is there a better approach to get what I am looking for?
The analysis relevance I have is:
(name of it, (if (number of members of it > 0) then (concatenations “%0A%0D” of (members of it as string)) else (“No Members”)) ) of local groups
Welcome!
If you created an Analysis that showing the Information - you can use Web Reports and add that information.
Let’s say you created the following Analysis:
Windows Information
And added there property “Local Users - Windows”
Open Web Reports > Explore Data > Edit Columns - add “Local Users - Windows”
Does it help you?
yes! Thank you so much!
One more thing… now that I can export this to a CSV, it’s hard to slice and dice in excel. each computer is one row only, and the local groups row is something like:
group1, member member member…
group2, member, member,member…
Is there a better way to do this?
I’d like to have ultimately a separate cell for each group with its members
computer ip os group1 group2 group3…
@paulhlee If you click on Edit Columns… you can click on the + sign of the property