Virtual Systems Collection

I have many collections around different system types as I am sure you do. Specifcally for platforms I have many such as:

• All Workstations
• All Servers
• All Systems
• All Desktops
• All Mobile Devices

This simple query will identify the virtual systems. By using the relevant above collection as the limiting collection you can see whats virtual.

• All Workstations
• All Workstations - Virtual
• All Servers
• All Servers - Virtual
• All Systems
• All Systems - Virutal
• All Desktops
• All Desktops - Virtual
• All Mobile Devices
• All Mobile Devices - Virtual

Even change the query to a not equal (!= or use 'False') in order to collect all physical systems on their own.

 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 where SMS_R_System.IsVirtualMachine = "True"