Find the missing VMs and Hosts - HyperV and Xen

Find the missing VMs and Hosts - HyperV and Xen


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

select * from hyperventitymomap where entity_type = 'HyperV-VM';

select * from hyperventitymomap where entity_type = 'HyperV-Host';

When the MOID is -4, check whether their DNS resolves, if not update it from hyperv server manager

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

We have run this update query manually and restart opmanager service.

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

Now automatic discovery will initiate during every restart.  


For Xen, it is xenentitymomap table.

Entity_type column will be VirtualMachine for VMs and HostSystem for Hosts.
          • Related Articles

          • 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 -4, ...
          • Xen VMs Tab will be empty due to disk name is lengthy

            Xen discovery issue:  Virtual Machines tab will be empty in the host snapshot page due to the Disk name is exceeded more than 100, and the below exception will be found in stderr log Caused by: java.sql.SQLException: Batch entry 21 INSERT INTO ...
          • To test Xen connectivity

            If xen discovery is failed,  Follow the steps: 1. Download the attached XenSessionCheck.zip file and extract here in \OpManager\ 2. Open the command prompt, go to \OpManager\ and execute VirtualXenExe.bat file by giving xen master details. For ...
          • Where can I find my OpManager database information?

            Question: Where can I find my OpManager database  information? Solution:  OpManager database information is stored  in the file "database_params.conf"  under OpManager/conf folder. The database server name/IP , database name, database type   and user ...
          • How to find Database & PolledData table & data size

            Queries to check database size and polleddata table size: Please connect the database and execute the below queries to get the results. SELECT pg_size_pretty(pg_database_size('<databasename>')); SELECT ...