SQL command to list all token serial numbers in Authentication Manager 8.x and their associated security domains
2 years ago
Originally Published: 2024-03-07
Article Number
000072054
Applies To
RSA Product Set: SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
Tasks
The following PSQL command will provide a list of all token serial numbers in Authentication Manager and their associated security domain.
  1. First, SSH to your Authentication Manager primary server.
  2. Connect to the PostgreSQL database as documented in the article on how to connect to SQL in RSA Authentication Manager 8.x.
  3. Once at the db=# prompt, run the following command:
SELECT am_token.serial_number, ims_security_domain.name
FROM am_token
INNER JOIN ims_security_domain ON am_token.owner_id = ims_security_domain.id;