SCCM Collection How can I Create systems ending with S or R

SCCM WQL Collection to Create systems ending with S or R in Computer Name

 

 

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.Name like "_____________E" or SMS_R_System.Name like "_____________R"

 

 

 

Each _ is treated as one character… So you can replace whereever you want with your target name based like … "______E______E