Simple Computer Name Query not working - need help

[ckuntzman]

We are a smaller school district and I'm trying to organize all my computers into collections based on their school building. Example HS collection would be all High School Computers.

All of our high school computers have a naming scheme of THSXXXXXXXXX. So I should be able to query any computers starting with THS -> should go into my HS Collection.

 

Here is my query statement: select SMS_R_System.Name from SMS_R_System where SMS_R_System.Name = "THS%"

It has All Systems as the limiting collection.

 

It will not update/add those computers to my HS Collections.

The computers are showing up in All Systems, so I know they are being seen/found by SCCM.

 

Any suggestions??

I had it running in my testing lab, but I can't seem to get it to work in my newly created production system.

 

 

 

FYI:

Server 2008R2 w/ SQL 2012 SP1 running SCCM 2012 SP1. (new installs -> less than 24 hours old)

 

[GarthMJ]

First off, I would do Select * ...

Secondly, Change the = to Like and everything will be good.

[ckuntzman]

What do you mean select *....????

 

I did change the = to Like and it did start working correctly.

 

Thank You Garth

 

We can mark this problem fixed.

[GarthMJ]

The Select * will allow you to see more information about the PC, instead of just the PC name as you have it now.. either way I’m glad it is working for you.