Here is a report that will show you any VMs that are powered on but are missing VMWare Tools or have outdated VMWare tools.
n.last_notify_time as First_Identified_Time
, e.display_name as Powered_On_VMName
, substring_index((replace(n.name, '::V', '$V')),'$',-1) as VMWare_Tools_Error
from notifications n
, max(n2.last_notify_time) as last_notify_time
from notifications n2
where n2.name like '%VMWare tools%'
group by n2.uuid
) notifications2 on n.uuid = notifications2.uuid and n.last_notify_time = notifications2.last_notify_time
join active_vms av on n.uuid = av.uuid
join entities e on av.uuid = e.uuid
where n.name like '%VMWare tools%'
group by e.display_name, n.last_notify_time, n.name
order by 2 asc