000038334 - How to get the list of Access Control Groups and Creation Date from RSA Archer using SQL script

Document created by RSA Customer Support Employee on Jul 30, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038334
Applies ToRSA Product Set:  Archer
RSA Product/Service Type: Administration, Access Control, Groups
RSA Version/Condition: 6.x
O/S Version: Windows

IssueThe Access Control Reports ( Administration > Access Control  >Access Control Reports) only provide the Last Updated Date and not the Creation Date of the existing Groups.
ResolutionPlease coordinate with your local Database Administrator and request to run the following query against the Archer Instance Database in order to get the Groups Creation Date:

SELECT group_id,group_name,create_date FROM dbo.tblGroup