Change Assistant: Not all environments are showing up when I run the viewer.
PeopleSoft environment agent uniquely identifies a particular instance based on a GUID. PeopleSoft assigns this Unique value to each PeopleSoft database instance (application if you have multiple versions installed on the same servers), so when an EM Agent notifies the Environment Management Hub that it has found a component belonging to an environment and if the GUID of the environment not recognized, the hub creates a new environment representation.
This problem occurs mostly because if you don’t update the GUID for an instance which is replicated (copied) from other instances. The simple solution is execute the following SQL by using your platform specific query tool.
UPDATE PSOPTIONS SET SHORTNAME = ‘NEW_DATABASE_NAME’, LONGNAME = ‘Your Custom Name for the instance’, GUID = ‘ ‘
Once this is done reboot the application server so this will automatically sets the new GUID in PSOPTIONS table.
Now the agent should pickup the new environment.