Skip to content

Collections

if you can create queries then you can have dynamic collections

  1. Is there a way I could remove computers not found in AD from a collection membership? Using this to grab all systems 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_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation")

  2. Started by Ironman,

    Hi, I created a query for all VIsio installations and refined the query to pull information from Add/Remove Programs. This works 100% However, if i uninstall visio and run Active Directory System Discovery, it still shows that computer up in collection. How do i setup a task that if and when software gets removed, that it updates that collection query for that particular software. Looking forward to your speedy response Shaun

    • 5 replies
    • 5.2k views
  3. Started by wmmayms,

    Hi Guys! Long time no see! Been to busy with other projects Does anybody have a vbs script for creating collection with support of adding membershiprules? I just looked through my script library and could only find one script which dident support the membership rules feature. Thought id ask here before starting to modify Cheers Marcus

    • 6 replies
    • 13.8k views
  4. We need to run somthing on all our Virtual server and something else on all Physical servers via SCCM. Does someone know how can i create colletion of report with all Virtual servers and anothe one for all the Physicals? Thanks Peled

    • 2 replies
    • 12k views
  5. hey guys. without this site there is now way i could have made it this far into SCCM... now, iv hit a wall.. i have a application, java, that i need to install on all desktops. i have found a script that i thought would work, but something is missing. every time i update the collection i get no computers returned. 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.Display…

  6. Started by rwakefie,

    Hello, I have two queries that i need to combine to get all systems that do not have the client installed and are windows 7 systems, I have the two queries but i do not know how to combine them. I have seen people using INTER JOIN but i do not know how to use it. Here are my two queries All systems with out a client 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.ResourceId not in (select SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.Client = 1) All Windows 7 Systems select SMS_R_SYST…

  7. Hi I need to add 120 Computers in a Software Collection. Is there a tool where i can add 120 on one time instead one by one?

    • 1 reply
    • 3.7k views
  8. Started by maffef,

    Hi I created this 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 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.DisplayName like "%TeamViewer 5 Host%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version not like "5.1.9220" and SMS_R_System.OperatingSystemNameandVersion != "Microsoft Windows NT Workstation 6.1" and SMS_R_System.ResourceD…

  9. Started by sweety_devil,

    Hi, I need to know which computers have the registry key [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.pdf]="Progid"="AcroExch.Document". But I don't know how to create my query. Thank you for your help.

  10. Started by maffef,

    Hi I have a Software Collection where I manually adding Computers if they need an specific Software. Time to Time the Collection contains more than 30 or 30 Computers. Removing manually takes so much time. Is there a tool which removes by a button the computers from the specific collection or do you have any other suggestions? Thanks in advance.

  11. Started by maffef,

    Hi After OS Deployment I always get a obsolete Computer. Is there a way to remove it automatically? Thanks in advance.

    • 1 reply
    • 3.5k views
  12. Started by StueyT,

    is there anyway to auto remove the machines from the SCCM collections when our daily AD System Discovery runs?

  13. Started by paddy,

    Hi there, I have identified over 100 machines using SCCM metering report that have not used office pro in over 6 months. I would like to know is there anyway I can upload this excel document into a collection. I want to advertise a task sequence to this collection. If there are step by step guides on how to perform this that would be great.

  14. Started by Finamore,

    Hi Everyone, I managed to make everything work fine in the SCCM 2007, but I have a question about the OSD: When I import the machine information to deploy a new OS, I'll place this machine on a collection called "Blank for Staging". So far so good. The point is after I deploy the new OS, the machine is running and everything, the computer is on the right Collections (All Windws 7 Systems, RJ - Workstations) but it is still on the "Blank for Staging" Collection. How do I remove from there? I tried the delete option but it deleted the computer from the SCCM. Augusto Finamore

  15. Started by Loenhoet,

    We got some AD-groups for specific type of systems (not everyone needs all software): SCCM_Software1, SCCM_Software2 and SCCM_Software3 for example. Now we got some collections that queries if the object is member of one of these groups. The Query looks like (for the Software1 group): 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\\SCCM_Software1" and SMS_R_System.Client = 1 Now we got a collection to check if there are objects that do not belong to any of these groups: select…

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.