Article Number
000015494
Applies To
RSA Product Set: SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
Issue
This article provides information on how to query the RSA Authentication Manager 8.x users and tokens from the command line.
Resolution
Use the following SELECT statement along with article
000016923 - How to run a SQL query for Authentication Manager 8.0 or 8.1 and write the output to a file for support.
Ensure that the query is written on one line.
'SELECT ims_principal.loginuid, am_token.serial_number, ims_principal.first_name, ims_principal.last_name FROM rsa_rep.ims_principal, rsa_rep.ims_principal_data, rsa_rep.am_token WHERE ims_principal.loginuid = ims_principal_data.loginuid AND ims_principal_data.id = am_token.principal_id;'