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"
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?