Article Content
Article Number | 000038850 |
Applies To | RSA Product Set: SecurID RSA Product/Service Type: Authentication Manager RSA Version/Condition: 8.x |
Issue | RSA Authentication Manager does not have a report template that includes the following content under Online Emergency Access:
|
Resolution | To create the report:
During Quick Setup, another username may have been selected. Use that username to log in. login as: rsaadmin Using keyboard-interactive authentication. Password:<enter operating system password> Last login: Mon Apr 20 16:39:41 2020 from jumphost.vcloud.local RSA Authentication Manager Installation Directory: /opt/rsa/am
rsaadmin@primary:~> cd /opt/rsa/am/utils rsaadmin@primary:/opt/rsa/am/utils> ./rsautil manage-secrets -a get com.rsa.db.dba.password Please enter OC Administrator username: <enter Operations Console administrator name> Please enter OC Administrator password: <enter Operations Console administrator password> com.rsa.db.dba.password: ijMFjf61f2VZMA2JMBmOnJqUSYsXby
rsaadmin@primary:/opt/rsa/am/utils> cd ../pgsql/bin rsaadmin@primary:/opt/rsa/am/pgsql/bin> ./psql -h localhost -p 7050 -d db -U rsa_dba Password for user rsa_dba: <enter the com.rsa.db.dba.password captured in step 6> psql.bin (9.4.1) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-SHA, bits: 256, compression: off) Type "help" for help. db=#
db=# SELECT ipd.loginuid, TOKEN_TEMP_STATUS_EXPIRY_DATE, amt.emergency_access_mode, amt.serial_number FROM rsa_rep.ims_principal_data ipd, rsa_rep.am_token amt WHERE ipd.ID= amt.principal_id AND TOKEN_TEMP_STATUS_EXPIRY_DATE is not null; loginuid | token_temp_status_expiry_date | emergency_access_mode | serial_number ----------+-------------------------------+-----------------------+--------------- iman | 2020-05-26 21:59:00 | 2 | 000116033641 (set of one time tokencodes) camerica | 2020-05-26 21:59:00 | 1 | 000116033642 (temporary fixed tokencode) (2 rows) Where, 1 = Temporary fixed tokencode 2 = Set of one time tokencodes
db=# SELECT ipd.loginuid, TOKEN_TEMP_STATUS_EXPIRY_DATE, eac_expires_on, amt.serial_number FROM rsa_rep.ims_principal_data ipd, rsa_rep.am_token amt WHERE ipd.ID= amt.principal_id AND amt.EMERGENCY_ACCESS_MODE=1; loginuid | token_temp_status_expiry_date | eac_expires_on | serial_number ----------+-------------------------------+----------------+--------------- camerica | 2020-05-26 21:59:00 | | 000116033642 (1 row)
db=# SELECT ipd.loginuid, TOKEN_TEMP_STATUS_EXPIRY_DATE, eac_expires_on, amt.serial_number FROM rsa_rep.ims_principal_data ipd, rsa_rep.am_token amt WHERE ipd.ID= amt.principal_id AND amt.EMERGENCY_ACCESS_MODE=2; loginuid | token_temp_status_expiry_date | eac_expires_on | serial_number ----------+-------------------------------+----------------+--------------- iman | 2020-05-26 21:59:00 | | 000116033641 (1 row)
db=# SELECT ipd.loginuid, TOKEN_TEMP_STATUS_EXPIRY_DATE, eac_expires_on, amt.serial_number FROM rsa_rep.ims_principal_data ipd, rsa_rep.am_token amt WHERE ipd.ID= amt.principal_id AND amt.EMERGENCY_ACCESS_MODE=0; loginuid | token_temp_status_expiry_date | eac_expires_on | serial_number ----------+-------------------------------+---------------------+--------------- dstrange | | 2020-06-11 23:59:59 | 000116033640 dstrange | | 2019-09-20 23:59:59 | 000406113859 (2 rows) |