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
Update to Authentication Manager 8.8 Patch 3 disables Agent Auto-registration service on TCP port 5550. 101Number of Views Enable SSH from CLI console conncetion 95Number of Views In RSA Identity Governance & Lifecycle, what is the difference between an account's Last Collected Date and Last Collected… 34Number of Views How to generate a report of registered users in RSA Authentication Manager 8.x database 92Number of Views The WildFly server.log file is not updated on RSA Identity Governance & Lifecycle 7.1.0 and above 227Number of Views
Trending Articles
Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.9 Release Notes (January 2026) Artifacts to gather in RSA Identity Governance & Lifecycle RSA Governance & Lifecycle 8.0.0 Administrators Guide RSA Governance & Lifecycle 8.0.0 Installation Guide
Don't see what you're looking for?