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

 

Click on CREATE:

 

ON GENERAL TAB:

CATEGORY - Compliance

SUBCATEGORY - Database Targets

TARGETS -   Select the repository database

PRIVILEGES - Run with SYSMAN privilege

ELEMENTS TAB:

Select ADD :

SELECT TABLE FROM SQL:


 

Here paste the sql query,

COMPLETE QUERY:

 SELECT A.HOST_NAME,
        A.DATABASE_NAME,
		TO_CHAR(A.STARTUP_TIME,'DD-MON-YYYY') "STARTUP_DATE" ,
        TO_CHAR(A.creation_date,'DD-MON-YYYY') "CREATION_DATE",
        A.LOG_MODE,A.CHARACTERSET,A.DBVERSION,
        AVAILABILITY_STATUS,E.SGASIZE,
		G.HOME_LOCATION "ORACLE_HOME",
		F.property_value "PORT",
		C.cpu_count,
		C.CPU_CORE_COUNT,
		SUBSTR(D.OS_SUMMARY,1,40) "OS PLATFORM" 
		FROM  SYSMAN.MGMT$DB_DBNINSTANCEINFO A, 
				SYSMAN.MGMT$AVAILABILITY_CURRENT B,
				SYSMAN.MGMT$DB_CPU_USAGE C ,  
				sysman.mgmt$os_hw_summary D,
				sysman.mgmt$db_sga_all E ,
				SYSMAN.MGMT$TARGET_PROPERTIES F  , 
				SYSMAN.MGMT$ORACLE_SW_ENT_TARGETS G 
	WHERE B.TARGET_TYPE='oracle_database' and
	A.TARGET_NAME=B.TARGET_NAME AND
	A.TARGET_NAME=C.TARGET_NAME AND 
	A.HOST_NAME=D.HOST_NAME and 
	a.target_name=E.target_name  AND 
	E.SGANAME='Total SGA (MB)'  AND
   A.TARGET_NAME=F.TARGET_NAME AND
   a.target_name=G.TARGET_NAME and  
   F.PROPERTY_NAME='Port' 
ORDER BY host_name desc;

 

This query you can customize as per your requirement:

 

Now schedule it:

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.

cloudCLOUD CONTROLOEM CLOUD


Related Topics

Apply database patch from OEM Cloud control
Blackout targets in OEM 12c cloud control
EMCLI command - OEM 12C
Upgrade database using OEM 12C cloud control
How to change sysman password for oracle 12c cloud control
Install oracle enterprise manager cloud control 12c
Add database as target oracle 12c cloud control
Generate custom report from OEM cloud control
Change dbsnmp password for target db in oem 12c
Deinstall Management Agents Oracle 12c cloud control

You May Also Like

Important views in For Oracle DBA in daily usage
Find user commits per minute in oracle database
oraversion utility in oracle 18c - New feature
Hive Installation with derby
Shell script to monitor goldengate process
How to recreate MGMT database in ORACLE 12C GRID
How to move spfile from file system to ASM in RAC
Query clause in oracle datapump expdp
How to move controlfile to a new location in oracle
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT

From This Website

How to create encrypted tablespace in PDB( oracle 12c)
Shell script to report failed login attempt in oracle
Oswatcher tool for collecting server diagnostic information
REUSE_DUMPFILES parameter in EXPDP
How to disable enable log shipping in standby using dgmgrl
How to enable active dataguard in physical standby database
How to keep or delete columns/Variable of a data frame in R
COLS & COLSEXCEPT FILTER in goldengate
How to start MySQL on Linux and Windows
Apply patch on oracle 12.2 database ( Release update)