Reports: Powered On VMs Without VMWare Tools or Outdated VMWare Tools

File uploaded by robert.coppersmith on Nov 7, 2016Last modified by robert.coppersmith on Apr 12, 2017
Version 4Show Document
  • View in full screen mode

Hi All,

 

Here is a report that will show you any VMs that are powered on but are missing VMWare Tools or have outdated VMWare tools.

 

Sample Output:

 

 

Best,

 

Bobby

 

Query:

 

select

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

inner join

  (

  select

  n2.uuid

  , 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

Outcomes