SCCM Collection Query for Virtual Machines

Last updated on February 25th, 2024 at 04:40 pm

Read Time:25 Second

Just a quick post to add to our list of SCCM collection queries. We needed one today for a collection of virtual machines only.

This query you can use to create a collection to do this:

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 = "1"

You can check out our other SCCM collection queries by following this link.

About Post Author

Andrew Armstrong

Founder of TechyGeeksHome and Head Editor for over 15 years! IT expert in multiple areas for over 23 years. Sharing experience and knowledge whenever possible! Making IT Happen.

techygeeks@outlook.com

https://techygeekshome.info

administrator