on Jun 16, 2016Article 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 |