Exporting Full User Account Details from Archer
The User Accounts All report in the UI is a bit limited in the data it provides. Can anyone assist with a SQL query that would provide the general account information (First Name, Last Name, User Name, Domain, Default Email, Title, Company, Phone (1, 2 3), Last Login Date, Last Updated, Account Status), and if possible, also include each account's group membership? Any help would be appreciated.
- archer adminstration
- Community Thread
- custom report
- Forum Thread
- Generalized Content
- RSA Archer
- RSA Archer Suite
- Specialized Content
- user account table
Hi Chad -
If you click the "Export Account Data" link in the top from from within the Access Control Reports you should find what you are looking for in the 'Users' report. Triggering the action will send a link in email to then access the account information from within Archer once the data is ready for download.
Depending on how your user accounts are created in Archer, you might also be able to leverage the domain server for user account information.
You can make this REST API call to get all users, and it returns a majority, if not all, of the information you're looking for.
Then given the ID returned from the first call, you can make this subsequent call to get all the contact information.
As I'm sure someone else(RSA Support) could explain in further details if needed, it's generally not advised to query the Instance Database directly.