Report to give for each action computer group targeted

Reporting
1

Hi,
I’m doing some BigFix Group clean-up in our environment and want to get report using session relevance that list all actions (Open) that are targeted by group including the group name. I will create 2nd report with all my groups and if I combine these it should list the groups that have not been used for any actions and they should be eligibile to be deleted (will include creator of the group) and send email to validate and delete accordingly.
I found several session relevance queries but nothing that would list something like
actionID, actionName, TargetGroup
1, Install 7-Zip, 7ZipComputers
2, Install AdobeReader, AdobeReaderComputers

Session relevance I found below
names of computers of results of bes actions whose (id of it = 6296594)
this would return list of computers targeted by this action

(names of it, targeting methods of it) of bes actions whose (state of it = “Open” and name of it starts with “PC1”)
this is closest I get but it would return following
Install 7-Zip, By Property

If it can be done in 1 report listing groups with no action associated to it that would be perfect, if I need to create 2 reports and perform some merging that’s good alterative also

Thx!

2

You’re almost there! Use the following query to retrieve details of open actions targeting groups. Once you have the group IDs, you can cross-reference them with your known groups:

(names of it, targeting methods of it, targeting relevance of it) of bes actions whose (state of it = "Open" AND targeting relevance of it contains "member of group")

However, keep in mind that open actions aren’t the only place where groups may be referenced. Group targeting can also occur during the creation of Fixlets, Tasks, or Custom RPs. So, be sure to consider those as well for a comprehensive view.

1 Like