10/3/2019

Sccm Collection Installed Software

Aug 19, 2013  SCCM 2012 – Creating Device Collections. Device Collection based on machines with x software installed. Follow steps 1-5 from the first example. Click on Select, and set the attribute class to Installed Appliactions and attritube to Display Name. The device must already be in SCCM, you can confirm this by searching. Here are some useful queries for System Center Configuration Manager that you can use to create collections. These collections demonstrate different queries you can use to create all the collection you need. Simply copy and paste these into the sccm query statement of the query rule.

We’ve all been there, needing to create collections of computers by installed software in SCCM. Sometimes even needing to list computers that have two or more installed software on them.

So how do you create these collections? Read on below…

Macbeth movie 2015 free. Jun 04, 2015  Macbeth, a duke of Scotland, receives a prophecy from a trio of witches that one day he will become King of Scotland. Consumed by ambition and spurred to action by his wife, Macbeth murders his. Oct 01, 2015  Directed by Justin Kurzel. With Michael Fassbender, Marion Cotillard, Jack Madigan, Frank Madigan. Macbeth, the Thane of Glamis, receives a prophecy from a trio of witches that one day he will become King of Scotland. Consumed by ambition and spurred to action by his wife, Macbeth murders his king and takes the throne for himself.

For this example, I am going to create a collection that will list all computers with “iTunes”. Then I will show you how to add multiple software.

Sccm Collection Installed Software Mac

  1. In “Assets and Compliance” go to your Device Collections and right-click and choose “Create Device Collection”.
  2. In the “Create Device Collection Wizard” enter a name for this new collection and you will want to limit the search to either “All Systems” or another collection of your choosing. I have about 3000 clients in the All Systems collection so I will choose another smaller collection for this example.
  3. In the next screen, click on “Add Rule” and then click on “Query Rule”.
  4. In the “Query Rule Properties”, enter a name for this query, “All computers with iTunes” and then click on “Edit Query Statement.”
  5. In the next window, you’ll want to click on “Show Query Language” and then copy/paste the below code and click on OK:
    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 'iTunes%'
    and
    SMS_G_System_ADD_REMOVE_PROGRAMS.Version like '%' order by SMS_R_System.Name
  6. Once back in the “Query Rule Properties” window, click on OK to close and go back to the “Create Device Collection Wizard” where you can add more direct rules, query rules or include/ exclude collections. For now, click on Next.
  7. In the Summary step, click on Next.
  8. Once complete, click on Close.
  9. You will notice that the icon for your new collection is refreshing and that your member count will be “0”.
  10. Wait a few moments before right-clicking and selecting “Refresh” or press F5.
  11. All done!

List Installed Software

Sccm collection installed software download

To add additional software to the collection, you can add a separate query to the collection’s properties by modifying the line in the code which specifies the software to search for, but keep in mind this will result in an “OR” operation meaning it will list computers with either one or the other. If you want an “AND” operation then just modify the search criteria on the existing query:

  1. Right-click on the collection and click on Properties.
  2. In the ‘Membership Rules” tab click on Edit.
  3. You can update the query name in the “Query Rule Properties” window or just click on “Edit Query Statement…”
  4. Click on the “Criteria” tab and then select the toolbar button which looks like a yellow star.
  5. Choose the “Installed Applications” attribute class and the “Display Name” attribute and then click on OK.
  6. Change the operator to “is like” and then type the software title in the “Value” input box and make sure to include the wildcard “%” (not required if you want a specific title and are sure of the spelling).
  7. You will notice that the new software title has been added with an “AND” operator. You can also change the operator to an “OR” using the button second from last which reads “& ”. Click on OK.
  8. Back at the “Query Rules Properties” click on OK to close this window and then click on “Apply” or “OK” in the collection properties window to save the new changes.
  9. Again wait a few minutes before refreshing and it should update the collection membership as long as it finds the specified software on other computers.

Sccm Query Installed Software On A Specific Computer

Advertisements