000035521 - RSA Authentication Manager 8.1 Authentication Bit Flag Report (Licensing)

Document created by RSA Customer Support Employee on Nov 29, 2017Last modified by RSA Customer Support Employee on Jan 3, 2020
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000035521
Applies ToRSA Product Set: SecurID
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.1 SP1
IssueThe output from the SQL statement or /opt/rsa/am/pgsql/bin/psql command from RSA article 000030005 requires a large amount of work to process the data.
ResolutionThe shell script abf-report.sh attached to this RSA knowledge article will generate a report showing the count of the different number of combinations associated to the authentication bit flags.

Installation & Usage



  1. Create a working folder on the Authentication Manager primary instance, for example:


mkdir /tmp/abfreport


  1. Download and copy the attached abf-report.sh shell script into this working folder.
  2. Change the permissions of abf-report.sh so it can be executed at the command line e.g.


chmod 755 /tmp/abfreport/abf-report.sh


  1. Copy the output from the SQL statement (SELECT loginuid, authenticator_bit_flags FROM rsa_rep.IMS_PRINCIPAL_DATA ipd WHERE authenticator_bit_flags IS NOT NULL;) into the working directory.  Alternatively, use the following command: /opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U rsa_dba -c "COPY ( SELECT loginuid, authenticator_bit_flags FROM rsa_rep.IMS_PRINCIPAL_DATA ipd WHERE authenticator_bit_flags IS NOT NULL ) TO STDOUT WITH CSV HEADER" > /tmp/abfreport/output.csv to generate output data. 

NOTE: The command ./rsautil manage-secrets -a get com.rsa.db.dba.password run from /opt/rsa/am/utils provides the password for when you are prompted when using the /opt/rsa/am/pgsql/bin/psql command.

Example of CSV output:

trustedapp,1000000000
@PROXYUSER@,100
jsmith,0001000
mjones,0001000
mbell,0001000

Example of SQL output:


trustedapp                 | 1000000000
@PROXYUSER@                | 100
jsmith                     | 0001000
mjones                     | 0001000
mbell                      | 0001000



  1. Navigate to the working folder and run the shell script to generate the report.  Usage as follows:


abf-report.sh {-sql | -csv} {filename}


For example,



rsaadmin@app82p:/tmp/abfreport> ./abf-report.sh -csv output.csv

Processing file output.csv

     77 0000000
  12649 0001000
    152 0100000
    180 0101000
      1 100
      4 1000000
      1 1000000000
      3 1001000

done!

rsaadmin@app82p:/tmp/abfreport>


Where the output data came from the SQL statement use the -sql parameter and where the output data came from the /opt/rsa/am/pgsql/bin/psql command then use the -csv parameter.

Attachments

Outcomes