000013250 - Authentication Manager 7.x: Custom Report to list all users  token assigned date and date token was last used

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000013250
IssueCustom Report to list all users, token assigned date and date token was last used
Resolution

create a .sql script like this: 

===========

spool/tmp/tokens_assigned.txt

select ipd.loginuid,atk.serial_number,atk.token_assigned_date,ato.last_login_date

FROM rsa_rep.am_token atk

JOIN rsa_rep.ims_principal_data ipd

ON ipd.id = atk.principal_id

JOIN RSA_BATCHREP.AM_TOKEN_OOB ato

ON atk.id = ato.am_token_id

ORDER BY atk.token_assigned_date DESC

 spool off 

==========


Put above in a text file on the AM primary (AM_HOME/utils/tokens_assigned_date.sql for example) and execute with rsautil: 

./rsautil manage-database -a exec-sql -U com.rsa.db.root ?f tokens_assigned_date.sql ?q 

Alternatively, you can run SQL from a remote machine as described in the 7.1 SDK Dev Guide available on SCOL at https://knowledge.rsasecurity.com/scolcms/set.aspx?id=8790 

Legacy Article IDa63102

Attachments

    Outcomes