Troubleshooting agent in oem 12c

Find when is the last upload time based on hosts. Execute following query in repository database.

select mt.target_name,
(select max(mmc.collection_timestamp)
from sysman.mgmt$metric_current mmc
where mmc.target_name=mt.target_name) last_collection
from sysman.mgmt$target mt
where host_name='hmaiptmsdb2'
group by mt.target_name
order by last_collection;