SCCM 2007 R2 collection not updating

Ok I have looked through most of these threads and found similiar problems to mine but still no solution.  Here is the scenario, I created a collection to find all clients that do not have the latest version of Adobe Reader which is 9.3.3.  I have tried different queries which I have included using the query builder or modifying the query directly when I first created the collections all the computers showed up fine, I then pushed a package to this collection which updated them all to 9.3.3.  I have verified that the clients have the latest version both by accessing the client directly and launching Adobe ->Help -> About, as well as through the SCCM resource explorer.  Also in add remove programs it shows as "Adobe eader 9.3.3".  In addition to that I have shceduled the clients hardware and client inventory agent to update every hour just to see if anything would change.  I also scheduled the collection to update every hour as well.  For some reasons once the client workstations recieve the Adobe update they are not being removed from the collection.  Here are the various queries I've tried

select *  from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "%Adobe Reader 9.3.3%"

select *  from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName != "Adobe Reader 9.3.3"

select *  from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adobe Reader%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version != "9.3.3"

When I first created the collection 72 computers were added, once I pushed the Adobe update waited an entire day and still 72 computer in this collection even though I know for a fact all but 10 got the update.

Any help is greatly appreciated, I have looked everywhere but cant figure what is worng with our configuration that doesnt allow the collectiosn to update.  I have no errors or warnings in my SCCm status.




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 inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Adobe Reader%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version != "9.3.3"

Open in new window

SMS1.jpg
cgitstAsked:
Who is Participating?
 
ExemplarConnect With a Mentor Commented:
Hello cqitst!

Yeah, please try to the following:

The new collection should be for identifying systems that DO NOT have Adobe 9.3.3.  Create a Collection with the following WQL query.  (Note:  If the Collection rule that identifies all systems with Adobe 9.3.3 is using Collection Limiting please use the same Collection Limiting on the new Collection.)

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 ResourceId not in (select ResourceID from SMS_CM_RES_COLL_????????)

Write down the Collection ID of the Collection that identifies systems WITH Adobe 9.3.3.  Insert the Collection ID data where the ????????.  Use this WQL query for the Collection that identifies systems WITHOUT Adobe 9.3.3.

Essentially what this new query does is show what systems are not in the Collection WITH Adobe 9.3.3.  I hope this makes sense.  I think this method will give you a fairly accurate account of the systems you are attempting to identify that are in need of Adobe 9.3.3

/cheers
0
 
manksterCommented:
Hi,
I Think i know what is the issue you are seeing. Queries with 'Not like' will not give you the correct results.
You need a query of the machines which have the software and then run a 'not in' statement against that.
To elaborate here are some links:
http://www.myitforum.com/articles/1/view.asp?id=2559
http://myitforum.com/cs2/blogs/dhite/archive/2007/04/08/sub-select-sql-server-query-sample.aspx

Let me know if you have any questions. Thanks.
0
 
cgitstAuthor Commented:
Thanks for the help, i followed the information in the links provided by mankster and my collection is now updating correctly
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.

All Courses

From novice to tech pro — start learning today.