How to query users and tokens from the command line for RSA Authentication Manager 8.x
Originally Published: 2013-10-17
Last Modified: 2023-10-06
Article Number
Applies To
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
Issue
Resolution
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;'
Related Articles
Change On-Demand Tokencode length from command line interface on RSA Authentication Manager 8.x Number of Views How to generate a token statistics report from the command line for RSA Authentication Manager 8.x Number of Views Determine SUSE Linux version from the command line in RSA Authentication Manager 8.x Number of Views Services will not start after changing IP address of RSA Authentication Manager 8.x from command line Number of Views How to stop, start and restart RSA Authentication Manager 8.x services at the command line Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.1 Quick Setup Fails with "Failed to Attach Replica Instance" User Application Portal How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device The RSA Identity Governance & Lifecycle AD Collector and AD ADC authentication source fail to establish a TLS 1.2 SSL conn…
Don't see what you're looking for?
