Find the missing VMs and Hosts - VMware

After the vCenter discovery, if the VMs and Hosts are missing, query the below table and check

select * from vwentitymomapping where entity_type = 'VirtualMachine';

select * from vwentitymomapping where entity_type = 'HostSystem';

When the MOID is -3, Virtual machines have not been selected by the user to be monitored. By clicking on 'Update inventory' option in vCenter device snapshot page, list of virtual machines and hosts which are available will be listed. Select the VM's which have to be monitored.

When the MOID is -4, check whether their DNS resolves, if not update it from vSphere client › host property

When the MOID is -5, that's marked as "deleted by user" so OpManager won't be mapping it.

We have to run this update query manually and restart OpManager service.

update vwentitymomapping set moid = -4 where moid = -5;

Now automatic discovery will initiate during every restart.  

Video Zone
OpManager Customer Videos
Altaleb Alshenqiti - Ministry of National Guard - Health Affairs
  
  •  IT Admin from "Royal flying doctor service", Australia
     Jonathan ManageEngine Customer
  •  Michael - Network & Tech, ManageEngine Customer
     Altaleb Alshenqiti - Ministry of National Guard - Health Affairs
  •  David Tremont, Associate Directory of Infrastructure,USA
     Todd Haverstock Administrative Director
  •  Donald Stewart, IT Manager from Crest Industries
     John Rosser, MIS Manager - Yale Chase Equipment & Services
 Pricing  Get Quote