need to create a oem report for nay new database created in the envrionment

Hello,

I need to create a oem report for any new database created in the environment. Please advise what sql should I use in the report generation.

I am using something like this whihc is not giving me correct results

select distinct first_value(first_metadata_load_time) over (partition by property_value),first_value(target_name) over (partition by property_value), property_name, property_value from MGMT_TARGETS T, MGMT_TARGET_PROPERTIES TP ,sysman.MGMT_TARGETS_LOAD_TIMES LT where T.target_guid=TP.target_guid and target_type='oracle_database'  and property_name IN ('MachineName', 'DBVersion', 'OracleHome','host','Boottime') and T.target_guid=LT.target_guid and FIRST_METADATA_LOAD_TIME>=sysdate-60  order by 1,2