Enterprise Manager Reports

Information Publisher Reports

Enterprise Manager reports are accessed using: 

Enterprise -> Reports -> Information Publisher Reports

The Information Publisher Reports page does not require any management packs

The following is a complete list of Information Publisher reports supplied by Oracle in EM 12.1.0.4

Reports are divided into categories and sub-categories

For example the Broken Targets report can be executed using: 

Monitoring -> Enterprise Manager Health -> Broken Targets

In the above Monitoring is the category and Enterprise Manager Health is the sub-category. Broken Targets is the report title.

Repository Tables

The following repository tables contain the Information Publisher report definitions

MGMT_IP_REPORT_DEF

Each report has a row in MGMT_IP_REPORT_DEF. This table contains the ID for the category, sub-category, report title and description.

Column Name Data Type Notes
REPORT_GUIDRAW(16) 
SCHEDULE_GUIDRAW(16) 
SCHEDULE_ENABLEDNUMBER(1) 
STORE_ENABLEDNUMBER(1) 
PURGE_POLICY_GUIDRAW(16) 
TITLE_NLSIDVARCHAR2(100) 
DESCRIPTION_NLSIDVARCHAR2(500) 
OWNERVARCHAR2(256) 
CATEGORY_NLSIDVARCHAR2(100) 
SUB_CATEGORY_NLSIDVARCHAR2(100) 
LAST_PUBLISHED_UTCDATE 
LAST_EDIT_TIME_UTCDATE 
LAST_EDIT_BYVARCHAR(256) 
IS_JIT_TARGETNUMBER(1) 
IS_JIT_MULTI_TARGETNUMBER(1) 
ADD_TOCNUMBER(1) 
PUBLISH_TO_PUBLICNUMBER(1) 
SYSTEM_REPORTNUMBER(1) 
CUSTOM_REPORT_BEAN_CLASSVARCHAR(500) 
INTERNAL_ONLYNUMBER 
PACK_NAMEVARCHAR(64) 
STYLEVARCHAR(64) 
SHOW_NAVIGATIONNUMBER(1) 
PRODUCT_NAMEVARCHAR2(100) 
COMPONENT_NAMEVARCHAR2(100) 
VERSIONVARCHAR2(100) 
GENERATE_CONTEXTNUMBER(1) 
HELP_TOPIC_IDVARCHAR2(256) 

Each row in MGMT_IP_REPORT_DEF is joined several times to MGMT_MESSAGES to select the taxt for category, sub-category, title and description in the local language.

The following query is used to extract this data (formatted for readability) 

SELECT
  report_guid,
  system_report,
  NVL
  (
    (
      SELECT message FROM mgmt_messages
      WHERE message_id = category_nls
      AND subsystem = 'REPORTS'
      AND language_code = 'en'
      AND country_code = ' '
    ),
    NVL
    (
      (
        SELECT message FROM mgmt_messages
        WHERE message_id = category_nls
        AND subsystem = 'REPORTS'
        AND language_code = 'en'
        AND country_code = ' '
      ),
      category_nls
    )
  ) category ,
  NVL
  (
    (
      SELECT message FROM mgmt_messages
      WHERE message_id = sub_category_nls
      AND subsystem = 'REPORTS'
      AND language_code = 'en'
      AND country_code = ' '
    ),
    NVL
    (
      (
        SELECT message FROM mgmt_messages
        WHERE message_id = sub_category_nls
        AND subsystem = 'REPORTS'
        AND language_code = 'en'
        AND country_code = ' '
      ), sub_category_nls
    )
  ) sub_category ,
  NVL
  (
    (
      SELECT message FROM mgmt_messages
      WHERE message_id = description_nls
      AND subsystem = 'REPORTS'
      AND language_code = 'en'
      AND country_code = ' '
    ),
    NVL
    (
      (
        SELECT message FROM mgmt_messages
        WHERE message_id = description_nls
        AND subsystem = 'REPORTS'
        AND language_code = 'en'
        AND country_code = ' '
      ), description_nls
    )
  ) description ,
  last_published_utc,
  reports_filter_title,
  reports_filter_owner
  FROM
  (
    SELECT DISTINCT
      rd.report_guid,
      rd.system_report,
      rd.category_nlsid category_nls,
      rd.sub_category_nlsid sub_category_nls,
      NVL
      (
        (
          SELECT message FROM mgmt_messages
          WHERE message_id = rd.title_nlsid
          AND subsystem = 'REPORTS'
          AND language_code = 'en'
          AND country_code = ' '
        ),
        NVL
        (
          (
            SELECT message FROM mgmt_messages
            WHERE message_id = rd.title_nlsid
            AND subsystem = 'REPORTS'
            AND language_code = 'en'
            AND country_code = ' '
          ), rd.title_nlsid
        )
      ) reports_filter_title,
      rd.description_nlsid description_nls,
      rd.owner reports_filter_owner,
      rd.last_published_utc last_published_utc
    FROM MGMT_IP_REPORT_DEF rd
    WHERE rd.internal_only = 0
  )
  ORDER BY
    category,
    sub_category,
    reports_filter_title,
    system_report DESC,
   reports_filter_owner,
    report_guid;