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
Reports are being sent with no data in RSA enVision 4.1 SP1 Number of Views 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 RSA Governance & Lifecycle Recipes: Report - AD Days Since Last Logon Number of Views When setting a lost password for a token and set by number of days and hours it is not applying the days only the hours Number of Views
Don't see what you're looking for?
