Is_Virtual_Machine in v_R_System is not showing Properly with a Virtual Machine under VMWare ESXI 5.1

Nicolas PilonSCCM, SQL4 Comments

There’s a new field in v_R_system view on SCCM 2012 SQL database named Is_Virtual_Machine. It is really easier when it’s time to target virtual machines with this field instead using manufacturer, model or v_GS_Virtual_Machine under SCCM 2007. Today, we were making a spot check in our data integrity when we found two manufacturers and models VMWare flagged as non-virtual machine. In the SCCM SQL database, the source for v_R_system view is System_DISC. The associate WMI class is SMS_R_System Server. From the MSDN website, the description of Is_Virtual_Machine in the WMI class is. 1 is a virtual machine and 0 is a physical machine. How Is_Virtual_Machine is provided? On the server itself, there’s a WMI query in the hardware inventory (InventoryAgent.log) pointing at CCM_DesktopMachine WMI class trying to find a field IsVirtual. As you can see, there’s no issue there. We can see IsVirtual at FALSE in the WMI class. Where is the problem? After few queries in the database, we … Read More