Skip to content

Collections

if you can create queries then you can have dynamic collections

  1. First of all, great site! I've found some great tips here. I have created SCCM 2007 collections based on Active Directory OUs by following the process found here: http://www.techrepublic.com/blog/datacenter/making-sms-2007-collections-based-on-organizational-unit/381 This works as expected on about 75% of OU based collections that have been created. The other collections are not populating entirely. Some machines show up and some do not. System Group Discovery and System Discovery are enabled. The computers that are not appearing in these OU collections do show up in All Systems collection. Any advice? Thanks, Dick

  2. Looking for some help for SQL query to build a collection. I want to deploy software to a users Primary machine based on if they are in a specific security group. So far my query in sql works as expected but i have some users who have both a laptop and a desktop while others have just either a laptop or desktop. so i want to limit it to something like if the user shows up twice then just add the users laptop to the collection. This is what i have so far SELECT UserGroupName.ResourceID, UserGroupName.User_Group_Name0, v_R_User.Mail0, v_R_User.User_Name0, v_R_System.Name0, v_R_System.DeviceOwner0, v_R_System.Is_Assigned…

  3. Hello. I'm wondering if it is possible to create a collection limited to all discovered systems based on IP subnet. But I need the systems that DO NOT have the client installed yet. We have about 2k systems and are in the testing phase of our client install and we do not want to push the client out to the whole district at once. We are just wanting to push it to one campus/site at a time. We only have 1 MP and 1 DP right now located at our main site. Lately I have been having to go get all the computer names of the systems I want to test client installation on and do a search under all systems and right click-install client one by one. There has to be a better way of doin…

  4. hi All Of Client Afther uninstal and install IIS And Wsus This might have been

  5. Started by oloughran,

    Hi Folks, I need some help on creating collections for specific OS versions, right we have x86 OS installed on both 32 bit & 64 bit architecture so I'm look to create a collection for all x86 windows 7 clients doesn't matter if the architecture is 64 bit, and also a collection for all x64 windows 7 clients, has anyone had experience on do this? any help would be great. Thanks Owen

  6. Hello, I need some collection help lease. I am trying to make a collection of machines that have a specific software product and all three of the hotfixes. The result is zero which I know is not true since I have a couple test VM's with all 4 items. Thank you.

  7. We have about 400 (out of ~35,000) devices that have had a failure in the Endpoint Policy Application. The issue appears to be the Registry.pol file so I've got a batch file I can run that will resolve it by deleting the Registry.Pol and restarting the CCMEXEC service. What I want to do is to create a dynamic collection based on a query that only pulls in devices where the policy application status was "failed". So i can have that batch file run, and then the following day those devices will drop out of the collection as they won't meet the criteria any more. I can kind of see how this would work in a report, but reports don't translate back into collection queri…

  8. You see it all the time regarding device collections in SCCM... how to setup a best practice hierarchy of collections, not to use the All Systems as your sole limiting collection and so on and so forth. But what about the User and User Group side? I set out to discover a best practice for this "other side of the road" and have amazingly come up with very little to back what will be my suggestion to my client of how to reconfigure their entire collection hierarchy. With roughly 1800 incremental collections, any suggestions will be a huge help! But I am now truly intrigued by what would be the best practice, not just by theory, but by way of real world experience exampl…

  9. Recently setup Intune with SCCM integration. Now I would like to setup device collections based what division of the company that the device works for. Looking for some help on creating a query to sort the devices registered in Intune into device collections based on an ad group that the device owner is a member of. Example. User A is a member of AD Group - Company A. User's A's mobile device should be in collection A User B is a member of AD Group - Company B. User's B's mobile device should be in collection B

    • 0 replies
    • 4k views
  10. I'm having some consistency issues with the Active Directory system discovery. I have one domain that populates the "System OU Name" differently than the rest of the domains. I have looked at the domain controllers and the service accounts and I'm not seeing anything that would cause the property to be populated differently. There are only 2 obvious differences between the domains. The one that isn't working like the others has the domain functional level as Windows Server 2012 and isn't trusted by the domain that the primary site is joined to. I have 3 domains setup for Active Directory system discovery. Discovery settings are all setup the same, Search path LDAP…

  11. Hello I currently have an extensive list of device collections in SCCM 2012, varying form using IP Ranges and Using Active Directory Site names. I see the totals of devices is populated which is great However in AD we have the default Containers 'Computers' where all computers end up when not part of any other group, i wish to create a device collection for this I initially tried to create a Site Based Collection titled 'No OU Devices' however i realised that the Computers Container is not an AD site, the current query is as follows select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.Reso…

  12. Started by boyjaew2,

    I have a query built to find a particular software installed. It takes FOREVER to run and spits back way too much. Below is my query. I barely understand these things and I must be doing something wrong here. I only need a few coulumns. I guess it will work for my end goal which will be a collection based on this query. It just seems a little verbose. It's basically giving me back every attribute. All I really want is: System Resources.Active Directory Site Name System Resource.Name System Resource.Last Logon User Name System Resource.Machine Assigned to User Installed Software.Product Name Installed Software.Product Version Installed Software.Publishers Als…

    • 2 replies
    • 4.9k views
  13. Hi, Does anyone know where to pull info like an error from Windows Update? I want to make a SCCM-collection based on computers that get a specific error in Windows Update. Appreciate the help guys

    • 0 replies
    • 4.2k views
  14. Started by mjb,

    Greetings, I am looking for a way to display a custom column in the devices window. I wold like to show the AD Description field in the results pane. I know that this can be shown in a custom report but the requirements that have been given to me is that this field be shown as a column in this window. I am already collecting this information and it shows in the device details. What is happening is that the primary user and primary device links are not reliable and typically do not even show a result. I would like to get the column displayed first then get the associations working after this. We have always relied on this description field for user associati…

    • 0 replies
    • 2.8k views
  15. I am having some weird issues trying to create this. My limiting collection is all systems. What I would like is all PC's in the all systems, excluding the PC's that are in a sub collection. I am getting overlap trying to do include All systems, exlcude "other collection" I assume I am doing this worng. What is the proper way to accomplish this?

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.