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
Hosted AWS Manual Login Invalid Credentials If used SSO in same day Number of Views RSA Governance & Lifecycle Recipes: Chart - AD Days Since Last Logon Number of Views Adding an additional Operations Console administrator fails with the error message Encrypted data could not be updated in … 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 RSA Governance & Lifecycle Recipes: Report - AD Days Since Last Logon Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators
Don't see what you're looking for?
