Export all users to a CSV file with all OnPremisesExtensionAttributes

Question

Hey Guys

I am trying to set up a small script that exports all my AzureAD Users with all their ExtensionAttributes into a CSV-File. Best would be to have a Line for each User with all their Properties. Here is what I have so far:

 Get-MgUser  | Where-Object {$_.UserPrincipalName -Like "*companyname.com"} | Select-Object DisplayName,onPremisesExtensionAttributes -ExpandProperty onPremisesExtensionAttributes | Format-Table DisplayName, ExtensionAttribute1, ExtensionAttribute2, ExtensionAttribute3, ExtensionAttribute4, ExtensionAttribute5, ExtensionAttribute6, ExtensionAttribute7, ExtensionAttribute8, ExtensionAttribute9, ExtensionATtribute10, ExtensionAttribute11, ExtensionAttribute12, ExtensionAttribute13, ExtensionAttribute14, ExtensionAttribute15 | Export-CSV -Append -Delimiter ";"

But it unfortunately just shows up empty...do you may see what I am doing wrong?

Thank you for your help.

Kind regards,

Gabe

Answer 1

For starters, you need to specifically request the properties, as by default Get-MgUser returns only a small subset.

Get-MgUser -Property DisplayName,onPremisesExtensionAttributes,UserPrincipalName

Do note that you have to request each property you plan to use, including those used for filtering. Next, don't use Format-table, as it does not mix with Export-CSV. Use another select statement instead, which gives us:

Get-MgUser -Property DisplayName,onPremisesExtensionAttributes,UserPrincipalName | Where-Object {$_.UserPrincipalName -Like "*michev.onmicrosoft.com"}| Select-Object -ExpandProperty onPremisesExtensionAttributes | select DisplayName,UserPrincipalName,ExtensionAttribute* | Export-CSV -nti blabla.csv