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')
The date and time when the Manageable Entity record was first loaded (in the time zone of the Management Repository)
Please use this query from the repository database as SYSMAN.
The discovery time for the agent target or any other target can be determined using:
SQL> SELECT entity_name, creation_date discovered
WHERE entity_name='<name of the target as seen in the console UI>';