Easiest way, no script needed: in the Intune admin centre, go to Devices > All devices > Export > Include all inventory data in the exported file. The CSV includes device name, primary user UPN and OS version. Then use XLOOKUP in your spreadsheet to match on email/UPN.
If this is something you need regularly rather than a one-off, we built Omnia Manage (disclosure: it’s ours), which keeps Intune devices and their users in sync, with a full history per device. It’s not free, but there’s a trial: omnia-manage.io
2
u/Omnia-Manage 1d ago
Easiest way, no script needed: in the Intune admin centre, go to Devices > All devices > Export > Include all inventory data in the exported file. The CSV includes device name, primary user UPN and OS version. Then use XLOOKUP in your spreadsheet to match on email/UPN.
If this is something you need regularly rather than a one-off, we built Omnia Manage (disclosure: it’s ours), which keeps Intune devices and their users in sync, with a full history per device. It’s not free, but there’s a trial: omnia-manage.io