Ok, so that’s a bit misleading. The actual issue is that ConfigMgr’s detection routine for some virtual machines is broken. This apparently started around May 2014 but I noticed it for the first time on a new ConfigMgr v1511 installation.
Nicolas Pilon of System Center Dudes has a great technical write up on the issue: Is_Virtual_Machine in v_R_System is not showing properly with a virtual machine under VMWare ESXI 5.1 https://www.systemcenterdudes.com/is_virtual_machine-in-v_r_system-is-not-showing-properly-with-a-virtual-machine-under-vmware-esxi-5-1/
He also posted a bug on Microsoft Connect which needs to be up-voted by more people to get any attention from Microsoft: Is_Virtual_Machine in v_R_System is not showing properly with a virtual machine under VMWare ESXI 5.1 https://connect.microsoft.com/ConfigurationManagervnext/feedback/details/878316/is-virtual-machine-in-v-r-system-is-not-showing-properly-with-a-virtual-machine-under-vmware-esxi-5-1
The purpose of this blog is to provide a workaround until there is a patch.
[read-more-redirect urltext=”CatapultSystems.com” url=”https://www.catapultsystems.com/blogs/when-vmware-started-making-physical-computers”]
ConfigMgr Queries
Systems | Virtual
select distinct SMS_R_System.Name, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client, SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Version, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan, SMS_R_System.ResourceType, SMS_R_System.ResourceId, SMS_R_System.IsVirtualMachine from SMS_R_System left join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_COMPUTER_SYSTEM_PRODUCT on SMS_G_System_COMPUTER_SYSTEM_PRODUCT.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where SMS_R_System.IsVirtualMachine = "True" or SMS_G_System_COMPUTER_SYSTEM.Model like "%virtual%"
Systems | Physical
select distinct SMS_R_System.Name, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client, SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Version, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan, SMS_R_System.ResourceType, SMS_R_System.ResourceId, SMS_R_System.IsVirtualMachine from SMS_R_System left join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_COMPUTER_SYSTEM_PRODUCT on SMS_G_System_COMPUTER_SYSTEM_PRODUCT.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_SYSTEM_ENCLOSURE on SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where SMS_R_System.IsVirtualMachine = "False" and SMS_G_System_COMPUTER_SYSTEM.Model not like "%virtual%"
ConfigMgr Collections
Note: A hardware inventory must be performed to gather the required data to determine if a system is physical or virtual.
Systems | Virtual
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.IsVirtualMachine = "True" or SMS_G_System_COMPUTER_SYSTEM.Model like "%virtual%"
Systems | Physical
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.IsVirtualMachine = "False" and SMS_G_System_COMPUTER_SYSTEM.Model not like "%virtual%"
ConfigMgr Report
A SSRS Report can be found on my public OneDrve at https://onedrive.live.com/redir?resid=E3B0C73435A2F778%212827 / Computers by Hardware Type and Model.rdl.
Enjoy!
[/read-more-redirect]