How To Create an SCCM 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
Open the SCCM console
Go to \Assets and Compliance\Overview\Device Collections\
In the tool bar click on “Create Device Collection”
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.
Click add rule > Query rule
Give the query a name and click on “Edit Query Statement”
Click on “Show Query Language”
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)
Right click on the collection you just created and select “Update Membership”
The total number of new machines will now show as below