REPORTING module can be used in oem cloud control to generate custom reports like , database status report of all target databases.

Repository database contains all the target details and metric information . So best way is to run query against the repository database.

Here we have provided steps for generating database consolidation report

ENTERPRISE -> REPORT -> INFORMATION PUBLISHER REPORT

custom1

 

Click on CREATE:
custom2

 

ON GENERAL TAB:

CATEGORY – Compliance

SUBCATEGORY – Database Targets

TARGETS –   Select the repository database

PRIVILEGES – Run with SYSMAN privilege
custom3

ELEMENTS TAB:

Select ADD :
custom4.jpg

SELECT TABLE FROM SQL:
custom5


custom6

 

Here paste the sql query,
custom7

COMPLETE QUERY:

 

This query you can customize as per your requirement:

 

Now schedule it:

custom8

You can preview the report also. Once the preview is fine, you can save it. HTML formatted report will be sent the the mentioned email addresses.