SCCM Collection Query for Virtual Machines

()

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.

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Leave us a message...

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