Article Content
Article Number | 000025727 |
Applies To | RSA ACE/Server 5.2.1 Token Custom SQL |
Issue | How to list RSA SecurID tokens updated and assigned in last X days using custom SQL query |
Resolution | Add 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 ID | a28374 |