After re-pointing an Autosys instance from one database to another.
The Agent Inventory is now showing all the old machines from DB2 and not what is currently in DB1.
Release : 12.0
Component : WCC
WORKLOAD CONTROL CENTER
The tnsnames.ora file needed to be changed and it was yet the AEWS was still finding its way to the old db eventhough all the TNS_ADMIN environment variables in the $AUTOUSER/autosys.<shell>.<hostname> files were pointing to the correctly updated tnsnames.ora.
There was an extra TNS_ADMIN setting in
/opt/CA/WorkloadAutomationAE/autouser.CDA/webserver/conf/wrapper.conf
set.ORACLE_HOME = /u001/app/oracle/product/19.3.0.0
set.TNS_ADMIN = /u001/app/oracle/product/19.3.0.0/network/admin
The settings above needed to be updated as they were pointing to a different/older tnsnames.ora.
Once that was done and AEWS restarted AEWS could display the correct machines.
To get WCC to reflect the update, delete the AEWS URL from the AutoSys server definition in WCC, save the changed and then add it back.