How To Create an SCCM Device Collection Showing New Machines

Device Collection Showing New Machines

In this article I will show you how you can create a device collection in SCCM which will show you new machines that have been created recently.

With this device collection you can change the amount of days to detect new machines.

To create an sccm device collection showing new machines follow these steps

  1. Open the SCCM console
  2. Go to \Assets and Compliance\Overview\Device Collections\
  3. In the tool bar click on “Create Device Collection”
    create SCCM collection
  4. Now give the device collection a name and select a limiting collection. In the example below I want to only show new windows 10 machines created in the last 7 days.
    sccm device collection new windows 10 machines
  5. Click Next
  6. Click add rule > Query rule
  7. Give the query a name and click on “Edit Query Statement”
    windows 10 query
  8. Click on “Show Query Language”
  9. Paste the below query in to the Query Statement field

    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 DateDiff(dd,SMS_R_System.CreationDate, GetDate()) <= 7


    This query will show new machines created in the last 7 days.  If you wish to change this to something like 14 days then simply replace 7 with 14 in the query (As shown below)

    new machines 14 days

  10. Click ok
  11. Click ok
  12. Click next
  13. Click next
  14. Click Close
  15. Right click on the collection you just created and select “Update Membership”
  16. The total number of new machines will now show as below

new machines