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
(64)
39,683 times
Add to favorites
System Center
1/13/2020
E-mail Twitter del.icio.us Digg Facebook
  • Typo in Clients Version | 1606
    1 Posts | Last post November 28, 2016
    • Can you confirm that this is a typo?
      
      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 like '5.00.8412.100%'
      
      See the end of the 5.00.8412.100% <--- 100% seems wrong.  I changed it to 5.00.8413.1307 and took out the 100% and all my clients added to that Device collection. ;)
      
      Awesome script!
      
      
  • Workstation Counts
    1 Posts | Last post November 21, 2016
    • How come workstations ALL does not equal Windows 7 + 8 + 8.1 + all Versions of Windows 10?  If I total all workstation collections I'm off by about 5%.  Also My Windows 10 Collection does not equal the total of all Windows 10 Collections (handy for patching).
  • Not digitally signed?
    1 Posts | Last post November 14, 2016
    • Thank you for this script!
      
      However I am getting the error that the script is not digitally signed just like ThePrep below. Any help would be appreciated!
  • Version 2.5 - Not Digitally Signed???
    1 Posts | Last post November 11, 2016
    • Hi... 
      
      I just came across this script. I'm using SCCM Current Branch ( 1607 ) and tried to run the script but I got the following error:
      
      PS C:\Users\Administrator.domain>\desktop> & '.\Operational Collection 2.5.ps1'
      & : File C:\Users\Administrator.<Domain>\desktop\Operational Collection 2.5.ps1 cannot be loaded. The file
      C:\Users\Administrator.<Domain>\desktop\Operational Collection 2.5.ps1 is not digitally signed. You cannot run this
      script on the current system. For more information about running scripts and setting execution policy, see
      about_Execution_Policies at http://go.microsoft.com/fwlink/?LinkID=135170.
      At line:1 char:3
      + & '.\Operational Collection 2.5.ps1'
      +   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : SecurityError: (:) [], PSSecurityException
          + FullyQualifiedErrorId : UnauthorizedAccess
      
      Any help would be greatly appreciated :) 
  • Addition to Query
    2 Posts | Last post October 28, 2016
    • [Version 2.2]
      "Laptops | HP" collection is not showing all HP laptops. HP changed the manufacturer from "HP" to Hewlett-Packard".
      To show correctly the query should be:
      
      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.Manufacturer like '%HP%' or  SMS_G_System_COMPUTER_SYSTEM.Manufacturer like '%Hewlett-Packard%'
      
    • Thanks, will be updated in 2.5
  • re-install is possible ?
    1 Posts | Last post September 26, 2016
    • oi, eu tentei instalar na primeira vez e recebi uma mensagem dizendo que faltava "Cmdlet Library". eu cancelei o script e instalei o cmdlet, mas quando tentei rodar o script novamente recebi este erro : Script has already been run or a collection name already exist. Delete All Operational collection before re-executing the script !
      
      mas não tem "all operational" collection in my "device collections", exite alguma solução para que eu use ele ?
  • Picking up Cisco UCS C series servers as laptops
    1 Posts | Last post August 30, 2016
    • The 'Laptops | All' collection is picking up all our UCS C series servers.
  • Here is one to add for servers that have SQL Database Engine installed
    1 Posts | Last post August 30, 2016
    • 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 inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "SQL Server%Database Engine Services" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "SQL Server%Database Engine Services"
  • Skip existing collection and recreate one that not exist or deleted in the past
    1 Posts | Last post July 29, 2016
    • Can you modify the script so any deleted collection in the past would be recreated while existing once are ignored? The current script will exit immediately if it comes across an existing DeviceCollection.
  • version 2.1 doesn't create the Operational folder
    5 Posts | Last post July 29, 2016
    • I ran the 2.1 script and where it created all the collections it didn't create the Operational folder and move the collections into it.  I saw the red error at the bottom of the script.  I do not already have a folder called Operational nor any other folder under "Device Collections".  Has anyone else experienced this and does anyone know what the solution is?
      Thank you!
    • I have the same issue. any solution?
    • get-execution policy? - are you restricting what can be run
    • Michael, The get-ExecutionPolicy result is "RemoteSigned".  The script runs and creates the collections, it just doesn't create the folder and move the Collections into the folder.
    • Can you modify the script so any deleted collection in the past would be recreated while existing once are ignored? The current script will exit immediately if it comes across an existing DeviceCollection.
51 - 60 of 73 Items