Device Collection based on creation date

Question

Hello, I'm trying to create device collection which devices are recently added into SCCM through new build/OSD or discovery, sitewide client push etc.

Idea behind that collection is based on device creation date. Thinking of scheduling an ADR to deploy patches to this collection, so the newly built devices will get the updates installed as soon as they born.

Is this sounds appropriate or do we have better option?

Below is the 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
WHERE (SMS_R_System.OperatingSystemNameandVersion LIKE "Microsoft Windows NT Server%"
OR SMS_R_System.OperatingSystemNameandVersion LIKE "Microsoft Windows NT Advanced Server%")
AND DATEPART(DD, SMS_R_System.CreationDate) >= 31

Answer 1

Hi, @RanjithkumarDuraisamy-6350

Thank you for posting in Microsoft Q&A forum.

It might not be a good idea, we usually create ADRs for the collections that contain the same OS version, if we have already configured ADRs for the specified OS version,
once the device joined in SCCM and added to the existing collection, the software updates that deployed to the collection will applied to the new device.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Why not apply su during you ts? Computers will apply any existing su deployment shortly after they join cm, so....