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
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 How to query a public database schema table for Segregation of Duties (SOD) violations in RSA Identity Governance & Lifecycle Number of Views How to use the HXTT Text (CSV) Pure Java JDBC Driver to test SQL Queries against a CSV text file data source in RSA Identi… Number of Views Restrict the Number of Active Tokens per User Number of Views Queries to detect workflows and change requests that could overload the Workpoint Server in RSA Identity Governance & Life… Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA MFA Agent 2.5 for Microsoft Windows Release Notes RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Setup and Configuration Guide Account collection failing with ORA-12899: value too large for column "AVUSER"."STX_ACC_122_266"."CAS17" in RSA Via Lifecy…
Don't see what you're looking for?
