Forum Discussion

Copper Contributor

May 13, 2020

Extracting UPN or DisplayName by importing csv with Object-Id

Hi All Microsoft has released a script to import to a csv; IOS devices affected by a passcode issue within Intune. As an organisation we need to contact each of these users and ask them to ta...

azure active directory

Azure Data Lake

Windows PowerShell

Iron Contributor

May 15, 2020

Do you have the script or a link to it?

dan_birrell
Copper Contributor
May 18, 2020
PeterJ_Inobits Hi Sorry Peter

https://github.com/microsoftgraph/powershell-intune-samples/blob/master/ManagedDevices/ManagedDevices_iOS_PasscodeReset_Export.ps1

This is the script Microsoft produced. The output just doesn't allow us to move forward with this as we need to know which device is assigned to which user.

If there is some way of importing object id's or device names to then output upn's then that would suit.

I raised a ticket with Microsoft and they came back and said they don't help edit script. Even their scripts written to fix their own issues 🙂
- PeterJ_Inobits
  Iron Contributor
  May 18, 2020
  dan_birrell
  
  Hi Dan
  
  That script returns the device id correct? You can the query the device owner based on the device id. There are at least two attributes, registereddeviceowner and registereddeviceuser IIRC.
  
  Another approach is to use the Azure Sign Logs and extract the deviceID and UserID and correlate them against the output provided the MS script

Resources