Playing with ESB Schema-1

Problem:
Need to get the list of Systems and its respective GUID's.

Solution:
The ESB schema name to connect is ORAESB. You need to have the following information to connect to this schema:
1) Password
2) Hostname
3) Port

You can get the Hostname and Port details from the datasources.xml file.

Query:
SELECT name,guid,status FROM wf_systems WHERE name != 'BPELSystem'