000034036 - How to generate a report of registered users in the RSA Authentication Manager 8.1 database

Document created by RSA Customer Support Employee on Oct 28, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034036
Applies ToRSA Product Set:  SecurID
RSA Product/Service Type:  Authentication Manager
RSA Version/Condition:  8.1 SP 1
 
IssueThis article provides information on how to generate a report of registered users in  the Authentication Manager database.
ResolutionThe report is generated at the command line where the administrator has access to the rsaadmin account password and knows the Operations Console username and password.
  1. Logon to the SecurID Appliance either with an SSH session or at the local console with the rsaadmin account.
  2. Navigate to /opt/rsa/am/utils.
  3. Retrieve the password for the rsa_dba user using the following command:

/opt/rsa/am/utils/rsautil manage-secrets -a get com.rsa.db.dba.password


  1. Enter the Operations Console username and password when prompted. 
  2. Make a note of the returned com.rsa.db.dba.password value.
  3. Create a text file in /opt/rsa/am/utils with an appropriate name; for example, registered_users.sql.
  4. Copy the SQL statement below into the text file and save the change.

SELECT 
      ipd.loginuid,
      ipd.IDENTITY_SRC_KEY,
      iis.name,
      iis.principal_base_dn
FROM
      RSA_REP.IMS_PRINCIPAL_DATA ipd
INNER JOIN
      RSA_REP.IMS_IDENTITY_SOURCE iis
ON
      iis.id = ipd.IDENTITY_SRC_ID;


  1. From /opt/rsa/am/utils, use the following command to generate a .csv output file using registered_users.sql.

/opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba -A -F , -X -t -f registered_users.sql -o regusers_report.csv

  1. When prompted, enter the com.rsa.db.dba.password value obtained in step 3.
  2. Open the regusers_report.csv to see a list all of the registered users in the Authentication Manager 8.1 database.
NotesSee also 000030005 (How to get an accurate active user license count in Authentiaction Manager 8.1 using SQL).

Attachments

    Outcomes