The customer needs a report that lists all data sets that should not be in their Master Catalog (MCAT).
As a starting point, they would review all entries in the Master Catalog which are not for SYS1.** data sets.
They probably have other data sets, other than SYS1.**, that are okay to be there,
but if they can start with that list, then they would be able to pare it down.
How to create a report on data sets that should not be in the Master Catalog?
1) User View
Create a corresponding User View based on the BCS Data Set Entries (CATALOGF) object in the Vantage GUI:
=> Catalog Mangament
=> BCS Data Set Entries
and apply the following filter:
CATNAVN = mastercat.name AND CATDSN EXCL (SYS1./) AND CATVOL EXCL ?ALIAS
This will list all data sets cataloged in the Master Catalog not being SYS1.** data sets.
Save the filter and check the result.
Refine the filter as needed.
Finally, save the view as a User View, e.g. MCATLIST.
2) GOA Script
If you want to schedule this report, create a corresponding GOA script (e.g. MCATLIST) via the GOA Wizard:
=> right-click on "BCS Data Set Entries" in the GUI tree
=> select "General Object Automation" to start the GOA Wizard
=> apply the filter used in the user view
=> Choose to submit a job to print the report from the GOA script,
or choose sending an email e.g. with message text:
BCS filter mastercat
=> at the end, "save, activate and execute the script"