SCCM Collection Query for Virtual Machines

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.

SCCM Collection Query for Virtual Machines 1

About Post Author

A.J. Armstrong

Founder of TechyGeeksHome and Head Editor for over 12 years! IT expert in multiple areas for over 22 years. Sharing experience and knowledge whenever possible! Making IT Happen.
Click to rate this post!
[Total: 0 Average: 0]

Free Subscription

If you want to be notified when we post more quality guides like this one, sign up to our free subscription service and you will receive an email when a new post is live.

Join 453 other subscribers.

No need to worry, we will not be filling your inbox with spam and you can unsubscribe anytime you like.


Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.

java 8 update 261 Previous post Java 8 Update 261 MSI Installers Released
blue search image Next post Outrank your Competitors with Content Writing Techniques