Hi, I am very new to SCCM 2007, was totally on CA unicenter before my company decides to move onto SCCM 2007 Environment. Please guide me in creating a new collection based on a file containing all the hostnames. Ta.

Hello - There are two types of collection one is static collection and other one is dymanic collection. Static collection can be created using the below tool.. http://smstools.codeplex.com/ Dynamic collection is created using query membership rules. Also see, the below thread for more details... http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/0a27029f-0532-4f8a-8198-2de6f8881446Anoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Easiest way to create a collection from a text file that contains all the machine names is to use the free tool called Collection Injection from SCCM Expert. John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|

Thanks Anoop and John...I am able to made the new collection as per suggestion, however, how can I delete a specific computer from that collection without deleting it from database?

Goto collection properties -- membership rule and remove the computer from there. IF it's static collection above mentioned action will help you to remove that resource from collection.Anoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

what if I need to delete a member from a dynamic/query based group? or if I need to put some machines in an exclusion list?Share your knowledge. It's a way to achieve immortality.

See, http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/ef303e44-a498-45a6-af5d-dcf272548b6cAnoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Above link is for creating a collection based on machine not in specific collection..I am more interested towards the machines, which are part of a couple of collections (meeting a query) but I never wanted any software to be deployed on them since they are business critical. Is it possible?Share your knowledge. It's a way to achieve immortality.

Yes possible. I think, you should go through the below site? http://www.windows-noob.com/forums/index.php?/topic/892-deploy-software-through-ad-groups-linked-to-collections-in-sccm/Anoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Thanks again, but is it me or this link actually dont have anythink to do with my question? Sorry about it, but i am not seeing what I am looking for..:|Share your knowledge. It's a way to achieve immortality.

Thanks again, but is it me or this link actually dont have anythink to do with my question? It's not just you :-) Which question is still unanswered? How to exclude computers that are members of a given collection? If so see: http://social.technet.microsoft.com/Forums/en/configmgrgeneral/thread/8dd106ce-6ea7-4a03-8c79-77687a80dbccTorsten Meringer | http://www.mssccmfaq.de

Thx Torsten, apprecaited, very close to what I am looking for. However a little bit more explaination will definitely help me. Say there is a couple of collections (randomly, collection 1 ID: 203 and collection 2 ID:211)...Machine (hostname: ABC) is part of collection 1, and another machine (hostname DEF) is a part of collection 2 among several other machines. What changes do I need to make in the below mentioned query to exclude these 2 machines from the regular update? Will it create a new collection of all machines which I am intending to exclude? 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.Client = 1 and SMS_R_System.ClientType = 1 and SMS_R_System.ResourceId not in (select ResourceID from SMS_CM_RES_COLL_XXXxxxxx) Replace the item in red with the Collection ID of the collection you are trying to exclude, which is located under the General tab of the properties window. Share your knowledge. It's a way to achieve immortality.

I thought u were aking abt creating collection using query. As u had several questions in the same thread ;-) the forum thread posted yesterday had a logic to exclude a number of machines from other collections by just adding one line into existing collection query :-DAnoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Add ABC and DEF to a "exclusion collection" and use the query above.Torsten Meringer | http://www.mssccmfaq.de