The problem
An alert fires: "WS-12345 hasn't checked in for 90 days". You need to contact the owner. Or a security incident requires immediate identification of the assigned user.
- SCCM WQL — SMS_UserMachineRelationship reverse-query, then resolve the SamAccountName.
- AD lookup — fetch mail, department, manager — three more attribute queries.
- Entra correlation — check Entra last sign-in to confirm the assignment is current.
Three minutes per device without this tool. 2 seconds with it. Bulk-process 500 devices in under a minute.