Hi All,
Any View or internal table which can provide OEM Target promoted and discovered date?
Tried this but not correct info:
select * from MGMT$MANAGEABLE_ENTITIES
where LOAD_TIMESTAMP> sysdate -35
and ENTITY_TYPE in ('oracle_database','oracle_pdb')
and MANAGE_STATUS=2
and PROMOTE_STATUS=3;
LOAD_TIMESTAMP | The date and time when the Manageable Entity record was first loaded (in the time zone of the Management Repository) |