Azure AD Graph Powershell: Getting an export an all users with all extension attributes and Manager's anmes

Question

Hey Guys

I am trying to export a list of all users, with all their extension attributes and further properties, including the manager. I am able to get all the properties needed except for the Manager's Name.

Get-MgUser -All -Property DisplayName,onPremisesExtensionAttributes,UserPrincipalName, Department, Division, City, Country, Manager | Where-Object {$_.UserPrincipalName -Like "******@company.com"}| Select-Object DisplayName,UserPrincipalName, Department, Division, City, Country, Manager -ExpandProperty onPremisesExtensionAttributes, Manager | select DisplayName,UserPrincipalName, Department, Division, City, Country,ExtensionAttribute*,  @{Name = 'Manager'; Expression = {$_.Manager.AdditionalProperties.displayName}} | Export-CSV -nti file.csv

I am able to get the Manager without the ExtensionAttributes included, by using the "ExpandProperty" setting, but I cannot "combine" it with ExtensionAttributes.

Do you may know what i can do differently?

Thank you for your help.

Kind regards,

Gabe

Answer 1

You can only expand a single property via the Select-Object cmdlet. Try this:

Get-MgUser -All -Property DisplayName,onPremisesExtensionAttributes,UserPrincipalName, Department, Division, City, Country -Expand Manager | Select-Object DisplayName,UserPrincipalName, Department, Division, City, Country, Manager -ExpandProperty onPremisesExtensionAttributes | select DisplayName,UserPrincipalName, Department, Division, City, Country,ExtensionAttribute*, @{Name = 'Manager'; Expression = {$_.Manager.AdditionalProperties.displayName}} | Export-CSV -nti file.csv