BernhardSchecke (Customer) asked a question.
RSA all token report
Dear all,
any idea how I can create/run a report that shows me ALL token on the system. The templates are only for user and token or only Soft-Token.
Related Questions
Nothing found
Loading
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) How to factory reset an RSA Authentication Manager 8.x hardware appliance without a factory reset button from the Operatio… Deploying RSA Authenticator 6.2.2 for Windows Using DISM Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?
@BernhardSchecke (Customer)
If the report templates do not provide you with the information you need, you can open an SSH session to your primary server and run a report directly in SQL to get a list of all the token son the system.
First, follow the steps to access the database and run a SQL query. the article references Authentication Manager 8.0 and 8.1, but is applicable for any Authentication Manager 8.x version.
Now that you are in the database you will need to run the following query to list all of your tokens:
SELECT * FROM am_token;
To exit the database the command is \q.
Strange output...but I got the list/report.
Thanks
@BernhardSchecke (Customer) ,
That SELECT statement that I provided brings back all of the data stored in the table. Now that you have that, you can customize it with mention of various fields you want to see. WHEREs and LIKEs make a more powerful statement. This page lists SQL example statements for retrieving data from a table. Playing around with SELECT statements should not negatively impact the database, but until you are confident in your SQL query skills, take a backup first.
You will notice that there are common SQL queries that you will find online, like ALTER TABLE, DROP TABLE, UPDATE and DELETE. DO NOT USE ANY OF THESE COMMANDS WITHOUT A TECHNICAL SUPPORT ENGINEER ON THE PHONE WITH YOU. Running these commands on your database can cause irreparable data loss.