|Issue||Get a list of groups that are assigned to Data Driven Event actions in RSA Archer system.|
Customer is going to perform a clean up on User Groups in RSA Archer and would to know all the Group assignments within Data Driven Events.
Applicable to RSA Archer 5.x versions.
Query below will give a list of user groups against whom actions are applied via ACL type of DDE.
Note: User group assignment are only found under ACL type of action.
tblEventAction ea with (NOLOCK)
join tblEventActionType eat with (NOLOCK) on ea.event_action_type_id = eat.event_action_type_id
join tblXEventActionGroup eag with (NOLOCK) on ea.event_action_id = eag.event_action_id
join tblGroup g with (NOLOCK) on eag.group_id = g.group_id
-- where g.group_name ='SOC: Solution Administrator'
order by ea.event_action_name ASC
|Legacy Article ID||a64801|