Query Non Extendable Tokens and Get Associated User Name to Serial Number of Token
I have query to find tokens that are non extendable (AKA Issued before upgrade to 8.2) and this works great. What I am looking to do now is take the 3500 token serial numbers and return the associated loginuid, lastname ,firstname and email address that is assigned to that token serial number.
My query for tokens that cannot be extended, 'SELECT * from am_token WHERE terminate_date is null'.
I believe that the user information is stored in the IMS_PRINCIPAL table, I am just not sure how to proceed from here.
- Auth Manager
- Authentication Manager
- authentication manager 8.2
- Community Thread
- Database Query
- Forum Thread
- RSA Authentication Manager
- RSA SecurID
- RSA SecurID Access
I would create 2 reports:
1 report with all Serial numbers of expiring tokens that cannot be extended (Report A)
1 report with all information (Report B)
In Excel, you can run a vlookup for all serial numbers that you got in Report A within Report B.
Then you just need to Filter Report B for the results of the vlookup.
It's not really what you are looking for, but it's a quick workaround