Folks,
Has anyone come up with a good method for dumping out all details of a Rule Set
and it's Rule(s) defined in EM12c? For example, let's say I have on 1 EM12c
(12.1.0.4 in the US) installation an Incident Rule Set SYSDBA_DATABASE_SYSTEM
for "Database System" target types. This Rule Set has a Rule for 20 or so
metrics and another for Target Availability. I'd like to create the exact same
configuration on a 2nd EM12c (say in the UK). I believe that 13c has the
ability to export/import Rule Sets but 12c doesn't.
This isn't a frequent activity (other than perhaps a monthly comparison to make
sure everything is configured as we intended) but even for a one-time deal it's
quite a pain. As far as I can tell metrics for a Rule can't be sorted, whether
viewing or editing. I can copy-paste the metrics into Excel and sort them
there but that's rather lame. "emcli" doesn't have a function for this
unfortunately.
I did find in EM_RULES.RL_EXPRESSION what looks like the detail of the rule
although it's all 1 CLOB of code that looks like "function ... &&
ew.asve("metric_group" , "dataguard") && ew.asve("metric_column" ,
"dg_status"))...". I could try to REGEXP... details out of it or wrap a cursor
in bash and awk/grep/sed the details out but that all seems way too
labor-intensive for something that shouldn't be, at least in my opinion.
Thx.
Regards,
Dave
