myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


How to create collection not containing a specific program?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> How to create collection not containing a specific program? Page: [1]
Login
Message << Older Topic   Newer Topic >>
How to create collection not containing a specific prog... - 5/20/2008 10:48:34 AM   
Peekstra

 

Posts: 29
Score: 0
Joined: 2/7/2008
Status: offline 		I'd like to create a collection containing all clients who don't have a certain program installed.

I'd like to use the ARP values for this but I'm not sure how I can accomplish this. I've tried various queries but they don't work. So how can I solve this in SCCM?

thanks!

Peekstra.

Post #: 1
RE: How to create collection not containing a specific ... - 5/20/2008 10:57:22 AM  1 votes
jdavis375

 

Posts: 150
Score: 17
Joined: 5/1/2006
From: Minneapolis, MN
Status: offline 		Hi Peekstra -
Refer to this thread. It details how to do what you are needing to do.
http://www.myitforum.com/forums/m_178675/mpage_1/key_subselect/tm.htm#178676

_____________________________

Jarvis

My Blog: The Realm of the Verbal Processor

If my post was helpful, a rating would be appreciated!

(in reply to Peekstra)
Post #: 2
RE: How to create collection not containing a specific ... - 5/21/2008 4:04:59 AM   
Peekstra

 

Posts: 29
Score: 0
Joined: 2/7/2008
Status: offline 		Hi Jarvis,


thanks for the links!

I'm now using these queries:

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 SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID FROM SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Program name")

and for programs that contain a version number in the display name (for example Adobe reader) this one seems to work nicely:

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 SMS_R_System.ResourceId not in (select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID FROM SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe Reader%")


Peekstra



< Message edited by Peekstra -- 5/21/2008 4:57:30 AM >

(in reply to jdavis375)
Post #: 3
RE: How to create collection not containing a specific ... - 5/21/2008 9:21:29 AM   
jdavis375

 

Posts: 150
Score: 17
Joined: 5/1/2006
From: Minneapolis, MN
Status: offline 		Glad you got it working...and thanks for the rating. :-)

_____________________________

Jarvis

My Blog: The Realm of the Verbal Processor

If my post was helpful, a rating would be appreciated!

(in reply to Peekstra)
Post #: 4
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> How to create collection not containing a specific program? Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.406