AnsweredAssumed Answered

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

Question asked by Gary Stefancyk on Jun 4, 2018
Latest reply on Jun 6, 2018 by Edward Davis

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. 


Outcomes