000027753 - Get a list of groups that are assigned to Data Driven Event actions in RSA Archer system.

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000027753
IssueGet 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.
Notes/*

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.

*/

Select
ea.event_action_type_id,
eat.event_action_type_name,
ea.event_action_name,
eag.event_action_id,
eag.group_id,
g.group_name
from
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 IDa64801

Attachments

    Outcomes