000033181 - 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.1

1. In the Operations Console, click Administration > Operating System Access.
2. In the SSH Settings section, select the checkbox for each NIC on which SSH needs to be enabled.
3. If multiple NICs are configured, SSH can be enabled on more than one NIC.
4. Click Save.

1. Logon to the Authentication Manager server, either with an SSH session or directly on the server using the rsaadmin account.
2. Navigate to the /opt/rsa/am/utils directory as the rsaadmin user.
3. 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

4. Upon successful creation of the readonly database user, create a text file in /opt/rsa/am/utils with an appropriate name, for example; AutoregAgentlist.sql.
5. 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';

6. 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

7. When prompted enter the password created for the read-only database user from Step 3.
8. Review the AutoregAgentlist.csv output file.