How to list RSA SecurID tokens updated and assigned in last X days using custom SQL query
Originally Published: 2005-10-26
Last Modified: 2023-10-06
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
Guidelines for writing Report Chart SQL Queries in RSA Identity Governance & Lifecycle Number of Views Add a Persistent IPv4 Static Route Number of Views 'ORA-00942: Table or View does not exist' error when referencing a custom table/view in a report query in RSA Identity Gov… Number of Views How to run a SQL query for Authentication Manager 8.0 or 8.1 and write the output to a file for support Number of Views Data runs show error: Exception while executing filter query RSA Identity Governance & Lifecycle 6.8 and above Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?
