Monday, May 16, 2016

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"  


No comments:

Post a Comment