Configuration Manager collection based on Client Creation Date (Dates in WMI)

I just had a very specific scenario, requiring me to target all new mobile devices (post a specific date) with a different set of compliance settings, than the rest of the devices.

In that case you can separate newly created devices in their own collection, based off their creation date.

The time of when a device is created is stored in the database, and the data can be queried through WMI using WQL.

A date formatted in WMI is using following syntax: yyyymmddHHMMSS.xxxxxx±UUU and can look like this:

20170819071629.492270+120

So, if you want all devices created post July 1 2017, your query have to look like this:

The syntax for dates in WMI in details: https://technet.microsoft.com/en-us/library/ee198928.aspx?f=255&MSPPError=-2147217396

1 thought on “Configuration Manager collection based on Client Creation Date (Dates in WMI)”

  1. Thanks for the solution. However, in Current Branch, you don’t have to convert the date and in fact that doesn’t work. This format works:
    SMS_R_System.CreationDate < "04/17/2021 6:00:00 AM"

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.