How to generate a report from CLI for the Last Updated Auto Reg status for Agents with Auto Registration enabled in RSA Authentication Manager 8.X
Originally Published: 2016-05-23
Article Number
Applies To
RSA Product/Service Type: RSA Authentication Manager
RSA Version/Condition: 8.X
Issue
Tasks
Enable SSH to log on to the appliance operating system using Secure Shell (SSH), using the steps below:
- In the Operations Console, click Administration > Operating System Access.
- In the SSH Settings section, select the checkbox for each NIC on which SSH needs to be enabled.
- If multiple NICs are configured, SSH can be enabled on more than one NIC.
- Click Save.
Resolution
- Logon to the Authentication Manager server, either with an SSH session or directly on the server using the rsaadmin account.
- Navigate to the /opt/rsa/am/utils directory as the rsaadmin user.
- Create a read-only user for database access using the command below:
./rsautil manage-readonly-dbusers -a create -o <OC_admin_username> -u <read-only_database_user_name> -i <IP_address_of_client_machine> -n <IP_mask>
Note the following information when entering the command:
- The OC_admin_username is the Operations Console administrator's name.
- The read-only_database_user_name is the user name specified for the read-only user.
- The IP_address_of_client_machine is the IP address of the user's client machine.
- The IP_mask is the mask to include a range of IP addresses (optional).
Below is an example showing how to create a read-only database user in Authentication Manager 8.1 that can be used to run custom SQL queries:
rsaadmin@primary81:/opt/rsa/am/utils> ./rsautil manage-readonly-dbusers -a create -o <Operations Console admin user name> -u <read-only user name> -i <IP address of client machine> -n <subnet mask>
Enter Operations Console (OC) password: <enter the password for the Operations Console admin user defined above>
Enter password for the read-only database user: <enter the password for the read-only user defined above>
Confirm password for the read-only database user: <re-enter the password for the read-only user defined above>
Executing action: 'create'.
Trusted Root SSL CA certificate was copied in file '/opt/rsa/am/utils/RSAAMTrustedRootSSLCA.crt'.
'create' action complete.
As an example,
rsaadmin@primary81:/opt/rsa/am/utils> ./rsautil manage-readonly-dbusers -a create -o rsaadmin -u Testuser1 -i 86.75.30.9 -n 255.255.254.0
- Upon successful creation of the read-only database user, create a text file in /opt/rsa/am/utils with an appropriate name, for example; AutoregAgentlist.sql.
- Copy the SQL statement below into the text file and save the changes.
SELECT Shost.Name as Hostname,Shost.PRIMARY_IP as IPaddress,Sagent.LAST_UPDATED_AUTO_REG FROM AM_AGENT Sagent INNER JOIN AM_HOST Shost ON Sagent.HOST_ID = Shost.ID WHERE Sagent.LAST_UPDATED_AUTO_REG>'YYYY-MM-DD';
- In /opt/rsa/am/utils, use the following command to generate a .csv output file named AutoregAgentList.csv using SQL script named AutoregAgentlist.sql:
/opt/rsa/am/pgsql/bin/psql -h localhost -p 7050 -d db -U <read-only database user> AutoregAgentlist.sql -o AutoregAgentlist.csv
- When prompted enter the password created for the read-only database user from Step 3.
- Review the AutoregAgentlist.csv output file.
Related Articles
Enable SSH from CLI console conncetion 94Number of Views Agent Auto-Registration 92Number of Views Update to Authentication Manager 8.8 Patch 3 disables Agent Auto-registration service on TCP port 5550. 90Number of Views How to generate a report of registered users in RSA Authentication Manager 8.x database 92Number of Views Unable to register the SecurID app with the Cloud Authentication Service using the Prime Self-Service Portal 99Number of Views
Trending Articles
How to recover the Application and AFX after an unexpected database failure in RSA Identity Governance & Lifecycle RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle Provisioning-Termination Rule fails to filter on Custom Attributes that have the same Display Names across Multiple Object… RSA Release Notes for RSA Authentication Manager 8.8
Don't see what you're looking for?