000025727 - How to list RSA SecurID tokens updated and assigned in last X days using custom SQL query

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 Number000025727
Applies ToRSA ACE/Server 5.2.1
Custom SQL
IssueHow to list RSA SecurID tokens updated and assigned in last X days using custom SQL query
ResolutionAdd a new Query in Database Administration and go to Reports --> Custom Queries and add the following query:

SELECT chDefaultLogin, chLastName, chFirstName, chSerialNum, dateenabled FROM SDUser JOIN SDToken ON SDUser.iUserNum = SDToken.iUserNum WHERE SDToken.Dateenabled >= (GMTDateNow - ARG01)

Be sure to define arguments, and set ARG01 to be a "number". Running the report will first query for the number of days to go back.
Legacy Article IDa28374