SYSMAN views - Looking for Configuration Extension SQL Rule Definitions SQL
We develop multiple reports from SYSMAN views/tables. I have focused on Compliance Standards in OEM, and now I am trying to generate a report that shows:
Compliance Standard
Compliance Standard Rule
SQL Rule Definition SQL
Configuration extension
Configuration extension alias
I have looked in the schema, and I think they are stored in a CLOB, but I haven't found it yet. Plus I am sure it requires 1 or more join keys to get the result I require.
i need this report to check and validate the rule definition to make sure it correctly reports a violation for each compliance rule we have created, and we have created over 240 of them, so going through OEM displays 1 rule at a time is totally inconvenient.