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

    OEM Target promoted and discovered date - Repository Views?

    ArunBavera

      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)