SQL command to list all token serial numbers in Authentication Manager 8.x and their associated security domains
Originally Published: 2024-03-07
Last Modified: 2024-03-08
Article Number
Applies To
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.x
Tasks
- First, SSH to your Authentication Manager primary server.
- Connect to the PostgreSQL database as documented in the article on how to connect to SQL in RSA Authentication Manager 8.x.
- 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;
FROM am_token
INNER JOIN ims_security_domain ON am_token.owner_id = ims_security_domain.id;
Related Articles
Mask Token Serial Numbers in Logs Number of Views How to verify the serial number of the certificate used for an LDAPS connection in RSA Authentication Manager 8.x Number of Views Java client auto-enrollment fails if certificate in the pool on server has a large serial number Number of Views Serial number is the only field visible when searching for tokens using Where search in RSA Authentication Manager 8.x Number of Views This token type is not allowed error in RSA Authentication Manager 8.x Self-Service Console Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?
