Set of Operational SCCM Collections

This script will create a set of 100 SCCM collections for your various needs. These collections can be used for operational tasks afterward.

4.8 Star
39,659 times
Add to favorites
System Center
E-mail Twitter Digg Facebook
  • Query Discrepencies
    1 Posts | Last post May 13, 2016
    • Mobile Devices | Windows RT shows Surface Pro devices
      Servers | Physical shows a Virtual DC - so DCs are detected as physical
  • Windows 7 Windows Update Agent
    1 Posts | Last post May 03, 2016
    • Hi,
      You have two colloctions for outdated Windows Update Agents.
      The latest Windows Update Agent for Windows 7 SP1 is at time of writing 7.6.7601.19116 according to
  • Excellent job!
    2 Posts | Last post April 25, 2016
    • Its true, the "All Servers Physical" is not entirely correct but a quick fix did it.
      Never the less, what a great script! Thanks!
    • What did you change to fix it?
  • How do i run this script
    3 Posts | Last post March 26, 2016
    • How do i run this script ? 
      1. I have the file on my system.
      2. I login to the Console -- connect to power shell through console.
      3. How do i access the ps file ? 
    • Right click the PS1 file and choose "Run with PowerShell"
    • By default, PS1 files open with notepad.exe.  This was done as a security measure to prevent some of the issues with vbscripts that Microsoft had in the past.
      A better option is to open the PowerShell console and run it from there.  You cannot simply run filename.ps1 as it will not run by default, another security measure.  Typically it is best to navigate to the folder location, example:
      set-location c:\scriptsfoldername
      Once you are in the correct folder, you can type dir or ls to see the folder contents (both alias the command get-childitem) then start typing the name of the script (first two or three characters should do it) and then press tab.  Tab completion should do it's trick and you will see .\filename.ps1 and you can press enter to execute the script.
      As always, do not download scripts from the internet and run them unless you know who wrote them and what they are actually going to do.
  • Upgrade Path?
    1 Posts | Last post March 23, 2016
    • This is fantastic! I started with 2.0 and now want to upgrade to 2.1. However, it seems that I have to delete the existing Collections in order to do so. For the most part that's pretty simple, however we've started using some of these collections as references in other collections - which means deleting all the references before we can clear the Operations folder and update. Is there a more 'direct' update path?
  • Collection51 (Line 90) Typo?
    2 Posts | Last post March 14, 2016
    • I have not run the script just yet but it looks like you may want to update line 90 as follows:
      $Collection51 = @{Name = "Clients Version | R2 SP1 CU2"; Query = "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.ClientVersion = '5.00.8239.1403'"}
      $Collection51 = @{Name = "Clients Version | R2 SP1 CU3"; Query = "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.ClientVersion = '5.00.8239.1403'"}
      I will try it on my own but I just wanted to put this out there.
    • Updated ! Thanks
  • Collection refresh times?
    2 Posts | Last post March 04, 2016
    • Great set of collections, but I'm having a problem where collections don't update.  The collection membership evaluation is set for the default 5 minutes on my site, but I have to manually Update membership for a collection in order for updates to show.   For example, I pushed the configuration manager client to a machine, I waited 24 hours and that machine didn't show up in the proper collection.  When I manually updated that collection, the machine then showed.  Any ideas?
    • The default update schedule for these is 7 days. Change to incremental for the appropriate collections.
  • All Servers Physical
    1 Posts | Last post February 02, 2016
    • Hi..
      First of all thanks for your great collection of collections :-D
      I think there might be a bug in the "All Servers Physical" collection.
      I am setting up a new ConfigMgr 1511 infrastructure and I only have the virtual ConfigMgr 1511 server in ConfigMgr and it is showing up in the "All Servers Physical" collection even when it should not :-D
  • Can't delete collections after running
    1 Posts | Last post January 06, 2016
    • I ran this and now get the following error on any collection I try to delete: 
      ConfigMgr Error Object:
      instance of SMS_ExtendedStatus
           CauseInfo = "11";
           Description = "Unable to update collection due to SQL error.";
           ErrorCode = 3242722566;
           File = "e:\\qfe\\nts\\sms\\siteserver\\sdk_provider\\smsprov\\sspcollection.cpp";
           Line = 855;
           ObjectInfo = "";
           Operation = "DeleteInstance";
           ParameterInfo = "SMS_Collection.CollectionID=\"PKR0001F\"";
           ProviderName = "WinMgmt";
           SQLMessage = "[42000][1101][Microsoft][SQL Server Native Client 11.0][SQL Server]Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.";
           SQLSeverity = 17;
           SQLStatus = 1101;
           StatusCode = 2147749889;
  • Great script
    1 Posts | Last post December 28, 2015
    • A very helpful script. Thanks for sharing it. 
61 - 70 of 73 Items