Generate a report of users with more than one token assigned in RSA Authentication Manager 8.x
Originally Published: 2019-05-08
Last Modified: 2023-11-30
Article Number
Applies To
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
Issue
Resolution
- Launch an SSH client, such as PuTTY.
- Login to the primary Authentication Manager server as rsaadmin and enter the operating system password.
Note that during Quick Setup another user name may have been selected. Use that user name to login.
- Enter the following command to get the database password:
rsaadmin@am83p:> /opt/rsa/am/utils/rsautil manage-secrets -a get com.rsa.db.dba.password
Please enter OC Administrator username: <enter Operations Console administrator name>
Please enter OC Administrator password: <enter Operations Console administrator password>
com.rsa.db.dba.password: ckg2DBtNZLy80TADWcGqdF0NOJygAQ
Please enter OC Administrator username: <enter Operations Console administrator name>
Please enter OC Administrator password: <enter Operations Console administrator password>
com.rsa.db.dba.password: ckg2DBtNZLy80TADWcGqdF0NOJygAQ
Note that the database password will be different for each installation of Authentication Manager.
- Use the following queries to generate the desired report(s):
- Generate a report with users that have more than 1 token assigned (2 or 3)
rsaadmin@am83p:>/opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba -c "COPY ( select PD.loginuid from am_token AM join ims_principal_data PD on AM.principal_id=PD.id group by loginuid having count(*)>1) TO STDOUT WITH CSV HEADER " > /tmp/report_usertoken1.csv
Password for user rsa_dba: <enter the com.rsa.db.dba.password string from above>
- Generate a report for users that have only two tokens assigned:
rsaadmin@am83p:>/opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba -c "COPY ( select PD.loginuid from am_token AM join ims_principal_data PD on AM.principal_id=PD.id group by loginuid having count(*)=2) TO STDOUT WITH CSV HEADER " > /tmp/report_usertoken2.csv
- Generate a report for users that have exactly three tokens assigned:
rsaadmin@am83p:> /opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba -c "COPY ( select PD.loginuid from am_token AM join ims_principal_data PD on AM.principal_id=PD.id group by loginuid having count(*)=3) TO STDOUT WITH CSV HEADER " > /tmp/report_usertoken3.csv
- The reports are saved in /tmp. You can copy the reports using the WinSCP application to your local PC and view them using Excel.
Related Articles
Deployment Manager request for a token results in Auth Manager looping message 'Listed one token' and 'Listed range of tok… Number of Views View All Tokens Assigned to a User Number of Views Authentication Manager token assigned to <no access> or <unknown> after user in an external identity source is deleted fro… Number of Views Assigned token list shows tokens assigned to <UNKNOWN> for RSA Authentication Manager Number of Views Email is sending multiple variables for variable ${PreviousNode_completedBy_meu} when more than one user included under Ap… Number of Views
Trending Articles
Deploy an Identity Router Virtual Machine in Microsoft Azure How to Replace the Web Server Certificate for the RSA Identity Governance & Lifecycle Web Console How to download the RSA Authentication Manager Console Root Certificate in DER format How to Change the Token Lifetime Extension Window in Authentication Manager Using rsautil AFX Server and Remote Collection Agents fail to start after updating Java to version 1.8u241 (1.8.0_241) / 1.7u251 (1.7.0_…
Don't see what you're looking for?
