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. 98Number of Views How to generate a report of registered users in RSA Authentication Manager 8.x database 92Number of Views Enable SSH from CLI console conncetion 95Number of Views Generating a report to list unassigned tokens in RSA Authentication Manager 8.x 120Number 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
Downloading RSA Authentication Manager license files or RSA Software token seed records Unable to login to RSA Authentication Manager Security Console as super admin RSA Authentication Manager 8.9 Release Notes (January 2026) How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Connection fails to Cloud Authentication Service when connecting through a proxy server from RSA Authentication Manager to…
Don't see what you're looking for?