7,023 questions
The -Filter parameter takes a string, not a code block, as its argument. Try this:
-Filter "extensionAttribute14 -like '*'"
Unable to get extension attribute values
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 56.00000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Arun Velusamy
21
Reputation points
Hello
I want to export all extensionattribute values for all users in AD. I tried multiple ways but the extensionattribute values are returning with empty data even though it has values. Tried below cmds:
Get-ADUser -Filter * -Properties * | select extensionAttribute*
Get-ADUser -Properties 'extensionAttribute14' -Filter * | fl sAMAccountName, extensionAttribute14
Get-ADUser -Properties 'extensionAttribute14' -filter {extensionAttribute14 -like '*'} | Select-Object extensionAttribute14
Get-ADUser -Properties 'extensionAttribute*' -Filter * | fl sAMAccountName, extensionAttribute*
Output comes like below:
Name : xxxxx
extensionAttribute1 :
extensionAttribute2 :
extensionAttribute3 :
extensionAttribute4 :
extensionAttribute5 :
extensionAttribute6 :
extensionAttribute7 :
extensionAttribute8 :
extensionAttribute9 :
extensionAttribute10 :
extensionAttribute11 :
extensionAttribute12 :
extensionAttribute13 :
extensionAttribute14 :
extensionAttribute15 :
I went through almost all the articles but non gave the result. Am I missing something here? Can you please suggest a way to get it?
Windows for business Windows Client for IT Pros Directory services Active Directory
Windows for business Windows Server User experience PowerShell
Windows for business Windows Server User experience Other
20,212 questions
6 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rich Matheisen 47,901 Reputation points2021-09-15T14:31:57.433+00:00 -
Arun Velusamy 21 Reputation points
2021-09-15T14:41:38.7+00:00 @Rich Matheisen : Tried this but didnt work, it didnt even display samaccountname
Get-ADUser -Filter "extensionAttribute14 -like '*'" -Properties 'extensionAttribute14' | Select samaccountname, extensionAttribute14
Get-ADUser -Filter "extensionAttribute14 -like '*'" -Properties extensionAttribute14 | Select samaccountname, extensionAttribute14
-
Rich Matheisen 47,901 Reputation points
2021-09-15T15:05:38.357+00:00 Unfortunately my AD directory schema hasn't been extended to include any of the Exchange attributes, so I'm unable to work with the property you're trying to use.
However, if you select just one user that you know to contain a populated extensionAttribute14 property using Get-ADUser and requesting "-Properties *", do you find that property in the results?
-
Rich Matheisen 47,901 Reputation points
2021-09-15T15:08:11.24+00:00 Can you use the Exchange "Get-MailUser" cmdlet and do the selection in a Where-Object cmdlet?
Sign in to comment -
-
Limitless Technology 39,916 Reputation points2021-09-16T07:46:51.143+00:00 Hello Arun V,
Normally I use this format for my input, can you try?
Get-ADUser -Properties extensionAttribute1 -Filter * | Select sAMAccountName, extensionAttribute1 | export-csv c:\temp\extensionattribute1.csv
Hope this works for you too,
Best regards, -
Arun Velusamy 21 Reputation points
2021-09-16T13:19:43.237+00:00 @Limitless Technology , I tried this but still giving empty values for extensionattribute, able to get the samaccountname though. Any further thoughts?
Get-ADUser -Properties extensionAttribute1 -Filter * | Select sAMAccountName, extensionAttribute1 | export-csv c:\temp\extensionattribute1.csv
-
Arun Velusamy 21 Reputation points
2021-09-16T13:21:14.007+00:00 @Rich Matheisen : We dont have the exchange integrated so wont be able to try mailuser cmd. Anything else we can try?
-
Rich Matheisen 47,901 Reputation points
2021-09-16T18:53:17.21+00:00 Okay, but I made two comments and you only remarked on the last one.
The first one asked this:
However, if you select just one user that you know to contain a populated extensionAttribute14 property using Get-ADUser and requesting "-Properties *", do you find that property in the results?
-
Arun Velusamy 21 Reputation points
2021-09-17T10:34:23.353+00:00 I tried for single user who has this extensionAttribute14 value but still returns with empty when i run the Get-aduser -properties * - which is very strange
-
Rich Matheisen 47,901 Reputation points
2021-09-17T15:10:08.2+00:00 But is the PROPERTY NAME in the results, regardless of its having a value?
If you run the test in a PowerShell session that's "Run as administrator" do the results differ?
You previously said "We dont have the exchange integrated" -- does that mean that you've extended the AD schema to include all the additional properties that Exchange introduces? If not, have you manually extended the schema to include properties that you've named "extensionAttribute14" etc.?
Sign in to comment -