CLOUD CONTROL Archives - DBACLASS https://dbaclass.com/article-tag/cloud-control/ database administration Fri, 17 Mar 2017 10:20:45 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.5 Generate custom report from OEM cloud control https://dbaclass.com/article/generate-custom-report-from-oem-cloud-control/ https://dbaclass.com/article/generate-custom-report-from-oem-cloud-control/#comments Fri, 17 Mar 2017 10:20:45 +0000 http://dbaclass.com/?post_type=article&p=2312 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 […]

The post Generate custom report from OEM cloud control appeared first on DBACLASS.

]]>
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:

 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:

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.

The post Generate custom report from OEM cloud control appeared first on DBACLASS.

]]>
https://dbaclass.com/article/generate-custom-report-from-oem-cloud-control/feed/ 15