Collections
if you can create queries then you can have dynamic collections
174 topics in this forum
-
I have a collection that is based on membership in an AD Group. The collection works fine for the most part but I have 3 clients are are in the collection that are not part of the AD Group. When I look at the properties of the client, it says it belongs to that group but when I look at the AD Group itself, the clients aren't in there. How do I remove them from that collection? I've deleted the collection and readded it but they will show up again.
-
- 5 replies
- 5.9k views
- 1 follower
-
-
I would like to make a collection of computers that have executed successfully a task sequence. Is this possible?
-
-
- 3 replies
- 4.8k views
- 1 follower
-
-
Hi, we wrote a small tool to generate collection (1 collection for each department and its subdepartments). This structure is gernerated on the Central Site and flows down to the Primary Site. Is there a way that a Admin can move/add Computers to one of these Collection from the Primary Site?
-
-
- 3 replies
- 4.8k views
-
-
Hi all, I have created a new AD security group (domain local) and put ten computers in it. We have enabled AD System Group, Security Group and Systems Discovery in SCCM and I have ticked the sync now button (or whatever its called). Then I created a new collection and set the following query on it 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.SystemGroupName = "domain.ad\\Warehouse - Laptops" Unfortunately even after leaving it 24hrs, clicking on update collection members and refresh the collection rema…
-
- 1 reply
- 3.6k views
- 1 follower
-
-
When I use the settings from your topic "All Windows Vista Systems", I also get all Windows 7 Systems. I would like to separate Vista from 7 but I don't know how.
-
-
- 6 replies
- 14.1k views
- 2 followers
-
-
Hi, I am having problem in creating collections based on OU membership in AD. I am attaching the screenshot of the query which I have used to create collection, but i am not able to get computers in it. I have done the "update collection..". Please help!!!
-
- 3 replies
- 5.5k views
-
-
Hi all, We have enabled AD system discovery and have 1,600 machines in the All Systems group. Great start :-) The issue I'm having is that in this group there's a split between workstations and laptops. Luckily the comapany has a good naming convention and all the workstations start with WSTN- and the laptops start with LPTP-. I've created a group with a query 'System name like WSTN-%' hoping to have a group only containing workstations. The problem is that this group only has 55 machines in it. The All System group has hundreds of machines starting with WSTN-. Weird, as I'd either expect it not to work at all or contain the 400 hundred or so workstations…
-
- 1 reply
- 3.7k views
-
-
Hi Is it possible to create a collection and import membership using an excell [.xml] file? Keith
-
- 5 replies
- 5.6k views
- 1 follower
-
-
How do I create a collection that includes all computers in a specific OU? My AD structure is like: Domain -USA -Site1 -Clients -Servers -Users -Site2 -Clients -Servers -Users -Canada -Site1 -Clients -Servers -Users -Site2 -Clients -Servers -Users Etc. I want to create a collection that contains all the objects in USA-Site1-Clients. How do I do that?
-
- 1 reply
- 3.7k views
- 1 follower
-
-
(New to SCCM, learning fast. Familiar enough with SQL to edit statements and understand what is happening) I have a set of 5 nested collections I utilize for Windows update deployment. Among these, I have a collection called "Servers" containing all 2003 and 2008 servers. The SQL Query is as follows. 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 OperatingSystemNameAndVersion like 'Microsoft Windows NT%Server%' I have a collection called "Manual" (Collection ID LMG00033) that I would like to exclude from the Ser…
-
- 4 replies
- 6.4k views
- 1 follower
-
-
Hi We currently build collections based on AD User group, then advertise and target that collection, easy enough. I now need to add to that, and expand the query that it not only builds the collection on AD User group, but also Operating System and Processor archtitecture . EG AD group = GroupABC , WIndows XP, x64. I'm sure it's achievable with some sort of query \sub query. The 2 queries below are the ones that essentially should be joined or merged... hopefully someone can assist. select useg.usergroup_name0 from v_R_UserGroup useg where Useg.Usergroup_Name0 like 'xxxxxx%' select SYS.Name0, sys.user_Name0 from v_r_system sys join v_GS_PROCESSOR PRO on PR…
-
- 1 reply
- 3.8k views
-
-
Hi I am just beginning to learn SCCM 2007 and here is my scenario which is in a test environment as of now. I have a computer (WIN7X64) that resides in the "ALL SYSTEMS" collection that I would like to move/copy/assign to a new group called "TEST GROUP" I have tried to do this via the computer associations section in configuration manager, import computer information but the computer never shows up in the collection called "TEST GROUP" I have refreshed the membership of "TEST GROUP" yet the computer still never appears. As I said I am a really SCCM newbie so, please bear with me, any assistance would be great.
-
- 3 replies
- 4.4k views
-
-
I have few dynamic collections for software installations. Query checks Application from "Add/Remove Programs" and install it, if it's missing. Purpose is to install few applications (for example Adobe Reader X) to all 1000 machines where it doesn't exist yet. Query is this and it works fine. 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct SMS_G_System_COMPUT…
-
- 1 reply
- 3.9k views
-
-
I've been noticing a weird issue when adding lists of machines to a collection using a query such as this: 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.Name in("PC1","PC2", "PC3") I've been noticing that some machines do not show as members of this collection even though they are listed in the query. As far as I can tell nothing is out of ordinary with these PCs, I can run reports on them, the client is working correctly, etc. If I add them via direct membership, they show up fine. Any ideas why this…
-
- 2 replies
- 4.3k views
- 1 follower
-
-
Hi, we installed IE8 English with WSUS, now we want to make a dynamic collection where we select all pc with IE8 but without IE8-MUI, so we will be able to install the IE8-MUI. The problem is that after the IE8-MUI is installed, we still having the machine on that collection, that is not what we want. 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.ProdID = "…
-
- 3 replies
- 5.4k views
-
