• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

SCCM 2012 Collection Query

All created machines appear in "All Systems".  There are additional Device Collections created for each tester.  Each collection then has a query to locate machines that contain the tester's initials.  Example: Tester name CC.

The collection criteria is System.Name is like "CC%"

The query is only adding machines to the collection that contain a client.  The machines do appear in All Systems with no client.

I would like machines, whether they do or do not have a client installed, and have System.Name is like "CC%" to get added.

I have attempted to include SMS_R_System.Client = % but it doesn't work...
0
mdmcq5
Asked:
mdmcq5
1 Solution
 
merowingerCommented:
I assume that Query you use contains Information which is only available when the Client has an agent.
So please use this one:

select * from SMS_R_System where SMS_R_System.Name like "CC%"
0
 
mdmcq5Author Commented:
Fantastic! Exactly what I asked for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now