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

Document created by RSA Customer Support Employee on Jun 16, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • Comment • 0
  • 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 RSA Authentication Manager 8.x users and tokens from the command line.
ResolutionUse the following SELECT statement with knowledge article on 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

Attachments

    Outcomes