Get the Properties From All Targets – Enterprise Manager

  SELECT target_name,
         target_type,
         user_comment,
         Contact,
         department,
         line_of_business,
         lifecycle_status
    FROM SYSMAN.GC$GLOBAL_TARGET_PROPERTIES
   WHERE     target_type IN ('host',
                             'oracle_instance',
                             'oracle_listener',
                             'cluster_database')
         AND line_of_business IS NULL
ORDER BY target_name;