Solved

SCCM 2012 Collection Query

Posted on 2014-04-16
2
351 Views
Last Modified: 2014-04-17
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
Comment
Question by:mdmcq5
2 Comments
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 40005831
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
 

Author Closing Comment

by:mdmcq5
ID: 40006566
Fantastic! Exactly what I asked for.
0

Featured Post

Don't lose your head updating email signatures!

Do your end users still have the wrong email signature? Do email signature updates bore you or fill you with a sense of dread? You can make this a whole lot easier on yourself by trusting an Exclaimer email signature management solution. Over 50 million users do...so should you!

Join & Write a Comment

##the calculator has been updated to version 1.6 please download the use the updated version## Hi there, After the previous post of the original version of the calculator here : http://www.experts-exchange.com/articles/OS/Microsoft_Operatin…
My previous article  (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html)detailed one possible method to get SCCM 2007 installed an…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now