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 … Read More