Need to know which devices installed the Config Manager client during the past 24 hours, or any other time period you’re interested in?
Create a query using the following code to return computer name, agent time (UTC), domain and client.
Limit the query to any collection you choose. I used All Windows 7 Client Systems which previously had the SCCM client installed as I’m preparing to upgrade them to Windows 10 using a Config Manager task sequence.
Change the getdate()) <= 24 figure to the number of hours you need to look at, eg, 168 for 7 days.
|select SMS_R_SYSTEM.Name,SMS_R_SYSTEM.AgentTime,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.AgentName = ‘MP_ClientRegistration’ and datediff(hh, SMS_R_System.AgentTime, getdate()) <= 24|