My group uses OEM Compliance Standards, rules, configuration extensions that we have authored to customize compliance for our company. We have not customized up to the compliance framework level. We have created several compliance standards, 250+ configuration extension aliases, and 250+ compliance rules. With this we have found that there are some duplicate rules being applied to our OEM targets.
I need to develop a SQL query to show me complaince standards, rules associated with the standards, configuration extensions aliases that make the rule, and either the SQL rule definition or script that is the configuration alias rule definition. I have found several SYSMAN tables/views that have the information I seek. However, it appears that the tables/views I have found so far do not have the join keys I require to get the report I need.
So far I have:
SYSMAN.EM_CCS_DATA_SOURCE : EXPR_VALUE which has the SQL rule definition
: DATA_SOURCE_NAME & EXPR_NAME which have the configuration extension
SYSMAN.CS_RULE_EVAL_SUMMARY : ROOT_CS_NAME which is the compliance standard
: RULE_NAME which is the rule name
SYSMAN.EM_CS_RULE_CCS_MAP : ALIAS which is the configuration extension alias
I am not sure these are the correct tables / view to bring this information together. I will be submitting this message to Oracle Support and the the Oracle Support Community for help. But if anyone know the SYSMAN schema pertaining to compliance standards, compliance rules, configuration extensions, configuration extension aliases, and SQL Rule definition, and how to join them to get a report, and you are willing to share, I would sure appreciate it.