1 Reply Latest reply on Sep 6, 2018 12:34 AM by Satya Chandan-Oracle

    OEM Target promoted and discovered date - Repository Views?


      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;



      The date and time when the Manageable Entity record was first loaded (in the time zone of the Management Repository)