I'm having trouble with an SCCM query not returning the correct information.
I'm trying to do a dynamic collection of computers based on their hostname. My computers are named LIB-<Building>-<number>
Examples: LIB-HSS-01, LIB-BUS-15
What I am trying to do is get a list of all computers in a building. So I've run the SMS query below but I don't get any results. Can someone please point me in the right direction fo where I am going wrong.
The criteria I set up to generate the query was "System Resource.Name uppercase is equal to "%BUS%""
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 UPPER(SMS_R_System.Name) = "%BUS%"