Some times it will be very hard to List down what are the Incident rules we defined in our OEM Application. Particularly, during IT Audit, we may need to provide the list of Incident Rulesets and details about individual rules.

Copy and paste Incident Rulesets/Rules from OEM 12c is not possible.

OEM 13c has an export/import option, but that will give you an xml file. You need to run the show by converting it to your favorite document.

This script will come in handy to get all details about OEM Incident rules.

SELECT

  *

FROM

  (

    SELECT

      r.RULESET_ID,

      r.RULE_ID,

      r.RULE_NAME,

      r.RULE_NAME_NLSID,

      r.CREATED_BY,

      r.DESCRIPTION,

      r.DESCRIPTION_NLSID,

      r.RESOURCE_BUNDLE,

      r.RULE_TYPE,

      r.RULE_ORDER,

      r.IS_REFERED_ACTION,

      r.REFERED_RULE_ID,

      r.IS_ENABLED,

      r.IS_BROKEN,

      r.CREATED_DATE,

      r.LAST_UPDATED_BY,

      r.LAST_UPDATED_DATE,

      r.RL_EXPRESSION,

      r.Event_Class,

      r.PRIV_MODE,

      r.Display_Order,

      ru.Subscribed_Users

    FROM

      (

        SELECT

          EmRulesEO.RULESET_ID,

          EmRulesEO.RULE_ID,

          EmRulesEO.RULE_NAME,

          EmRulesEO.RULE_NAME_NLSID,

          EmRulesEO.CREATED_BY,

          EmRulesEO.DESCRIPTION,

          EmRulesEO.DESCRIPTION_NLSID,

          EmRulesEO.RESOURCE_BUNDLE,

          EmRulesEO.RULE_TYPE,

          EmRulesEO.RULE_ORDER,

          EmRulesEO.IS_REFERED_ACTION,

          EmRulesEO.REFERED_RULE_ID,

          EmRulesEO.IS_ENABLED,

          EmRulesEO.IS_BROKEN,

          EmRulesEO.CREATION_DATE AS CREATED_DATE,

          EmRulesEO.LAST_UPDATED_BY,

          EmRulesEO.LAST_UPDATED_DATE,

          EmRulesEO.RL_EXPRESSION,

          EmrulesEO.Event_Class,

          EmrulesEO.PRIV_MODE,

          To_Number(EmRuleSetsEO.ruleset_order                   + (row_number() over (partition

          BY EmRulesEO.RULESET_ID order by EmRulesEO.RULE_ORDER))/1000) AS

          Display_Order

        FROM

          Em_Rules Emruleseo,

          (

            SELECT

              RULESET_ID,

              rownum AS RULESET_ORDER

            FROM

              (

                SELECT

                  RULESET_ID

                FROM

                  EM_RULE_SETS

                WHERE

                  IS_VISIBLE=1

                ORDER BY

                  Ruleset_Order

              )

          )

          EmRuleSetsEO

        WHERE

          Emrulesetseo.Ruleset_Id = Emruleseo.Ruleset_Id

        ORDER BY

          ruleset_order ASC,

          RULE_ORDER ASC

      )

      r

    LEFT OUTER JOIN

      (

        SELECT

          acts.rule_id AS rule_id,

          em_incident_rules.table_to_string(CAST(COLLECT(notif.recipient) AS SMP_EMD_LONG_STRING_ARRAY)) AS Subscribed_Users

        FROM

          sysman.em_rule_cond_actions acts,

          sysman.em_rule_basic_notifications notif

        WHERE

          acts.COND_ACTION_ID = notif.COND_ACTION_ID

        GROUP BY

          rule_id

      )

      ru

    ON

      r.rule_id = ru.rule_id

  )

  QRSLT

WHERE

  RULESET_ID = 7

ORDER BY

  RULE_ORDER ASC