Generating a report to list unassigned tokens in RSA Authentication Manager 8.x
Originally Published: 2015-10-14
Article Number
Applies To
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
Issue
Resolution
- Connect to the Authentication Manager server with an SSH session, through vSphere or a direct connection.
- Login as the rsaadmin user.
- Note that during Quick Setup another user name may have been selected. Use that user name to login.
- Using WinSCP or FileZilla, copy the attached unassigned_tokens.sql file to /home/rsaadmin.
- Run the command rsautil manage-secrets -a get com.rsa.db.dba.password to obtain the com.rsa.db.dba.password.
rsaadmin@am81p:~> cd /opt/rsa/am/utils/ rsaadmin@am81p:/opt/rsa/am/utils> ./rsautil manage-secrets -a get com.rsa.db.dba.password Please enter OC Administrator username: <enter Operations Console admin user name> Please enter OC Administrator password: <enter Operations Console admin password> com.rsa.db.dba.password: <output of the com.rsa.db.dba.password for your instance>
- Connect to the PostgreSQL database and run the script:
rsaadmin@am81p:~> cd /opt/rsa/am/pgsql/bin rsaadmin@am81p:~> ./psql -h localhost -p 7050 -d db -U rsa_dba -f ~/unassigned_tokens.sql > ~/unassigned_tokens.html Password for user rsa_dba: <enter the com.rsa.db.dba.password captured above>
- Use WinSCP or FileZilla to copy the unassigned_tokens.html from /home/rsaadmin to your local Windows machine.
Notes
SELECT serial_number,token_type,token_subtype,token_shutdown_date FROM rsa_rep.am_token WHERE principal_id is NULL;
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).
Related Articles
Enable unassigned RSA SecurID tokens in bulk for RSA Authentication Manager 8.1 SP1 or later 168Number of Views A custom query to show assigned or unassigned software tokens 36Number of Views Groups are unassigned in User Access Review for RSA Identity Governance and Lifecycle 38Number of Views Unable To Delete Unassigned Expired Token 113Number of Views Generic REST Collector fails with 'Access token has expired' error in RSA Identity Governance & Lifecycle 295Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA-2026-10: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA SecurID Desktop Token 5.0.3 for Windows Administrator's Guide RSA SecurID Software Token 4.2.1 for Mac OS X Administrator's Guide
Don't see what you're looking for?