000023173 - How to write a custom query to list active users who have used their token

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000023173
Applies ToCustom SQL Query
RSA Authentication Manager 6
IssueHow to write a custom query to list active users who have used their token
Resolution

SELECT chDefaultLogin, chLastName, chFirstName, dateLastLogin, todLastLogin FROM SDUser JOIN SDToken ON SDUser.iUserNum = SDToken.iUserNum WHERE SDToken.DateLastLogin > 01/01/1986

This will list all tokens where the last login is later than 1/1/1986

(the default date filled in when you don't use a token)

Legacy Article IDa32551

Attachments

    Outcomes