PowerShell to get User Principal Name that associate with Device name

Question

PowerShell to get User Principal Name that associate with Device name

Ahmed Alshatawi 235

Hello,

I have a CSV file that have 400 device names from Entra ID, I want to get the User Principal Namethat associate with device name. Is there a PowerShell script to get the UPN from the device name in Entra? Thanks.

Vasil Michev 119.5K Reputation points MVP Volunteer Moderator

2024-10-24T07:53:49.5966667+00:00

Can you clarify what you mean by "User Principal Namethat associate with device name"? The registered owner of the device? The set of registered users? Something else altogether?

Take a look at the Get-MgDeviceRegisteredOwner/Get-MgDeviceRegisteredUser cmdlets
Ahmed Alshatawi 235 Reputation points

2024-10-24T13:37:34.43+00:00

I meant is the primary user or the owner for the device. I have a group of 400 devices without user name or email. I'd like to have a script to get the primary user foe the device please.
Sandeep G-MSFT 20,906 Reputation points Microsoft Employee Moderator

2024-10-25T03:43:40.7666667+00:00

@Ahmed Alshatawi

Thank you for posting this in Microsoft Q&A.

I am looking into this issue and will get back to you post my research.

1 answer

Your answer

Vasil Michev 119.5K Reputation points MVP Volunteer Moderator

2024-10-24T07:53:49.5966667+00:00

Can you clarify what you mean by "User Principal Namethat associate with device name"? The registered owner of the device? The set of registered users? Something else altogether?

Take a look at the Get-MgDeviceRegisteredOwner/Get-MgDeviceRegisteredUser cmdlets
Ahmed Alshatawi 235 Reputation points

2024-10-24T13:37:34.43+00:00

I meant is the primary user or the owner for the device. I have a group of 400 devices without user name or email. I'd like to have a script to get the primary user foe the device please.
Sandeep G-MSFT 20,906 Reputation points Microsoft Employee Moderator

2024-10-25T03:43:40.7666667+00:00

@Ahmed Alshatawi

Thank you for posting this in Microsoft Q&A.

I am looking into this issue and will get back to you post my research.

Answer 1

Vasil Michev 119.5K MVP Volunteer Moderator

Try something like this:

Import-CSV blabla.csv | select -ExpandProperty DisplayName | % { Get-MgDevice -Filter "displayName eq '$_'" -ExpandProperty registeredOwners | select @{n="DeviceName";e={$_.DisplayName}},@{n="Owner";e={$_.RegisteredOwners[0].AdditionalProperties.userPrincipalName}} }

where the CSV file must have a column DisplayName to designate the device.

Share via

PowerShell to get User Principal Name that associate with Device name

1 answer

Your answer