Article Content
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;' |
Legacy Article ID | a62804 |