Hello – We are starting to use Auto Pilot in a testing environment. The AP devices are the only Azure AD joined devices in our environment, we don’t use AAD Hybrid Join. These AP devices are co-managed by our on-premises Endpoint Configuration Manager. I wanted to create a collection in MECM that will show these AP devices. After quite a bit of trial and error, the below query seems like the only way to show AutoPilot devices for us.
select * from SMS_R_System inner join SMS_Client_ComanagementState on SMS_Client_ComanagementState.ResourceId = SMS_R_System.ResourceId where SMS_Client_ComanagementState.AADJoined = 1
The above query shows all of our AP systems, with one exception. We took a AP device and on the MECM console we deleted it. Then we sent a ‘Wipe’ command from the MEM web console. It did that fine and then it was joined again as a AutoPilot device. The system (with the same name as before if that matters) shows up in MECM and MEM consoles as expected. However the system isn’t shown in the collection with the above query. Is the query correct? If an existing AP system that is co-managed by MECM reused, would it not show up in that query? I’m assuming it still should.
Thoughts?
