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
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 How to create Oracle SQL profile for a SQL_ID query used in RSA Governance & Lifecycle Number of Views
Trending Articles
Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update Authentication Manager How to Retrieve the LDAPS Certificate and Configure an External Identity Source to Use LDAPS
Don't see what you're looking for?
