SQL command to list all token serial numbers in Authentication Manager 8.x and their associated security domains
Originally Published: 2024-03-07
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
How to Mask Token Serial Numbers in RSA Authentication Manager 8.X Logs 26Number of Views Mask Token Serial Numbers in Logs 14Number of Views Serial number is the only field visible when searching for tokens using Where search in RSA Authentication Manager 8.x 69Number of Views Serial Number Mismatch 57Number of Views SCIM API for User Creation 153Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Release Notes for RSA Authentication Manager 8.8 RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Authentication Manager Supported Hardware and Upgrade Paths Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?