SCCM Task Sequence

[josedecember]

Can any one correct this, is this correct? i want to deploy it in SCCM Task Sequency. My requirement is to install the particular application only to this hostname starting.

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.NetbiosName like "AMON%" or "BMON%" or "CMON%" or "DMON%" or "EMON%" or "FMON%"

[imDarshanGK]

Hi @josedecember,

It looks like your query might have a syntax issue with the OR conditions. In SQL, each condition needs to be evaluated separately. Try using this corrected version:

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.NetbiosName like "AMON%"
or SMS_R_System.NetbiosName like "BMON%"
or SMS_R_System.NetbiosName like "CMON%"
or SMS_R_System.NetbiosName like "DMON%"
or SMS_R_System.NetbiosName like "EMON%"
or SMS_R_System.NetbiosName like "FMON%"