Display agent version from Grid Control repository

Run this query in your Grid Control repository (from user SYSMAN) to get the list of Grid Control agents with OS and Version infomation:

SELECT tar.target_name,  tar.type_qualifier1 target_os, mp.property_value version

  FROM mgmt$target tar, mgmt$target_properties mp

WHERE tar.target_guid = mp.target_guid AND

      tar.target_type = 'oracle_emd' AND

      mp.property_name = 'Version' AND

      tar.type_qualifier1 IN ('SunOS', 'Linux' ) AND

      ( tar.target_name NOT LIKE '%enta%' AND tar.target_name NOT LIKE '%abnet%')

ORDER BY tar.target_name;