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;