I am trying to create a collection in SCCM to segregate the VDI (static, Dynamic, etc ).

Using below query I am able to create a collection of all the Virtual systems. However, need to create a collection for Static VDI systems and Dynamic VDI System.

Kindly provide your assitance.

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”