RSA Product Set: SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
This article provides information on how to query the RSA Authentication Manager 8.x users and tokens from the command line.
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;'