Skip to content

Simple Computer Name Query not working - need help

Featured Replies

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)

 

  • Author

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.

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.