000015494 - How to query users and tokens from the command line for RSA Authentication Manager 8.x

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support on Jul 25, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000015494
Applies ToRSA Product Set: SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
IssueThis article provides information on how to query the RSA Authentication Manager 8.x users and tokens from the command line.
ResolutionUse 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 IDa62804