<div>
I would use the following:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-40439518-1"><span>Get-ADUser -filter * -SearchBase &quot;OU=Your,OU=Structure,OU=GoesHere,DC=YouDomainName,DC=Extension&quot; -Properties * | select Name, SamAccountName, UserPrincipalName, EmailAddress | Export-Csv EmailAddresses.csv -noTypeInformation -UseCulture</span>
</code></pre>
<br />
Just update the SearchBase value and run.<br />
<br />
Dan
</div>


<div>
A slight cleaner version of this would be:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-40440079-1"><span>import-module ActiveDirectory</span>
<span>$SearchBase = &quot;OU=Your,OU=Structure,OU=GoesHere,DC=YouDomainName,DC=Extension&quot;</span>
<span>$SearchScopeControl = &quot;OneLevel&quot;</span>
<span>$OutputFile = &quot;MyOutputFile.csv&quot;</span>
<span></span>
<span>Get-ADUser -filter * -SearchBase $SearchBase -SearchScope $SearchScopeControl -Properties * | select Name, SamAccountName, UserPrincipalName, EmailAddress | Export-Csv EmailAddresses.csv -noTypeInformation -UseCulture</span>
</code></pre>
<br />
This does the same as the first post, but it is easier to edit when you want to reuse it. &nbsp;And the &quot;SearchScope&quot; option let's you control how deep in the OU structure the script runs.<br />
<br />
Options for $SearchScopeControl are:<br />
1. Base<br />
2. OneLevel<br />
3. Subtree<br />
<br />
From Microsoft:<br />

<blockquote>
A Base query searches only the current path or object. A OneLevel query searches the immediate children of that path or object. A Subtree query searches the current path or object and all children of that path or object
</blockquote>
<br />
Reference Link: &nbsp;<a href="http://technet.microsoft.com/en-us/library/ee617241.aspx" rel="ugc">http://technet.microsoft.com/en-us/library/ee617241.aspx</a><br />
<br />
Dan
</div>


<div>
Put in the information from Powershell ISE. &nbsp;But where is the csv? &nbsp;Does it have something to do with this? &nbsp;Do I = it to something?<br />
<br />
$OutputFile = &quot;MyOutputFile.csv&quot;
</div>


<div>
Nevermind,,,,, I'm and idiot worked great!!!!!! &nbsp;Thank you
</div>


<div>
Going to close this out. &nbsp;Just curious. &nbsp;But what does this mean?<br />
<br />
$OutputFile = &quot;MyOutputFile.csv&quot; , &nbsp;where do I stick this variable at if I use it,, or is it being used?
</div>


<div>
You are awesome... &nbsp;I know those long days too. &nbsp;But go into the weekend that you really helped me out with this!!!!!! &nbsp; Much appreciated,,, and thank you so much.
</div>


<div>
Expert knows his stuff. &nbsp;Hope all people with questions can find him.
</div>


<div>
HELP,,,, &nbsp;need one more thing. &nbsp;I have OU's that equal *Laptops, and under that I have Laptop Users OU. &nbsp;I have this<br />
<br />
import-module ActiveDirectory<br />
$SearchBase = &quot;OU=*Laptops,OU=Laptop Users,DC=oxarc1,DC=int&quot;<br />
$SearchScopeControl = &quot;OneLevel&quot;<br />
$OutputFile = &quot;C:\temp\EmailAddresses.cs<wbr />v&quot;<br />
Get-ADUser -filter * -SearchBase $SearchBase -SearchScope $SearchScopeControl -Properties * | select Name, SamAccountName, UserPrincipalName, EmailAddress| Export-Csv $OutputFile -noTypeInformation -UseCulture<br />
<br />
But I get this error. &nbsp;<br />
<br />
Get-ADUser : Directory object not found<br />
At C:\Users\tmb.OXARC1\Docume<wbr />nts\Script<wbr />_Commands\<wbr />attibutesb<wbr />ysearchbas<wbr />e.ps1:5 char:11<br />
+ Get-ADUser &lt;&lt;&lt;&lt;&nbsp; -filter * -SearchBase $SearchBase -SearchScope $SearchScopeControl -Properties * | select Name, SamAccountName, UserPrincipalName, EmailAddress| Export-Csv $OutputFile -noTypeInformation -UseCulture<br />
&nbsp; &nbsp; + CategoryInfo &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;: ObjectNotFound: (:) [Get-ADUser], ADIdentityNotFoundExceptio<wbr />n<br />
&nbsp; &nbsp; + FullyQualifiedErrorId : Directory object not found,Microsoft.ActiveDire<wbr />ctory.Mana<wbr />gement.Com<wbr />mands.GetA<wbr />DUser<br />
&nbsp;<br />
I hope this pasted right on this comment box. &nbsp;But it works with *Laptops OU but not the OU underneath *Laptops which is Laptop Users. &nbsp; I tried all three scopeControls but it didn't work. &nbsp;<br />
<br />
Can you help me one last time?
</div>


<div>
Nevermind. &nbsp;I got it. &nbsp;I see better how it works. &nbsp;I have to only put the base OU, &nbsp;then change the value of $SearchScopeControl. &nbsp; Getting better at it. &nbsp;Only question then is, &nbsp;If I have 4 sub OU's in *Laptops &nbsp;how to I get only 1 Sub OU that I need. &nbsp;e.g. &nbsp;OU=*Laptops, but I only want Laptop Users is Spokane or Yakima. &nbsp;OU structure would be &quot;OU=*Laptops,OU=Yakima Users&quot;. &lt;----- &nbsp;Only want Yakima not Spokane which is also in the *Laptops OU? &nbsp; &nbsp; Hope I made sense.
</div>


<div>
<div class="content wysiwyg-content">
I need some help. &nbsp;I am trying to use Get-ADuser cmdlet to retrieve the mail attributes of each user. &nbsp;What I would really like is to just export into a .csv the name and the mail attribute. &nbsp;I tried this using ISE.<br />
<br />
import-module ActiveDirectory<br />
Get-ADuser -filter * -properties mail| Export-Csv C:\temp\Computer.csv<br />
<br />
That way I could modify the .csv but it did not import the mail. &nbsp;Really could use some help. Thanks much in advance.
</div>
</div>


I need some help.  I am trying to use Get-ADuser cmdlet to retrieve the mail attributes of each user.  What I would really like is to just export into a .csv the name and the mail attribute.  I tried this using ISE.

import-module ActiveDirectory
Get-ADuser -filter * -properties mail| Export-Csv C:\temp\Computer.csv

That way I could modify the .csv but it did not import the mail.  Really could use some help. Thanks much in advance.

Using Powershell to retrieve mail attributes

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.