How to list RSA SecurID tokens updated and assigned in last X days using custom SQL query
Originally Published: 2005-10-26
Article Number
Applies To
Token
Custom SQL
Issue
Resolution
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.
Related Articles
RSA Governance & Lifecycle Recipes: Chart - AD Days Since Last Logon Number of Views A java.lang.RuntimeException when viewing RSA Via Lifecycle and Governance My Activities page sorted By Work Item Number of Views After an upgrade and migration, the 'Is Terminated' user attribute is not updated after unification in RSA Identity Govern… Number of Views SSOLogin=false no longer works after upgrade to 7.0.2 from 7.0.0 P03 RSA Identity Governance & Lifecycle Number of Views Review email defined with the Review URL {$reviewDetailURL} shows no review items to be monitored in RSA Identity Governan… Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA-2026-05: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities RSA Release Notes for RSA Authentication Manager 8.8 Create Account fails if previous Create Account is pending in RSA Identity Governance & Lifecycle
Don't see what you're looking for?
