Query Non Extendable Tokens and Get Associated User Name to Serial Number of Token

[GaryStefancyk]

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. 

[MartinSawczyn]

Hi Gary, 

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

[EdwardDavis]

Do a join with am_token, and ims_principal, and ims_principal_data tables and select the columns you need.