<div>
Get-ADUser -Filter &quot;Name -eq '$user'&quot; | Select-Object name, samaccountname
</div>


<div>
May I assume the users emails are found in your AD?<br />
<br />
If so then you can amend your CSV using the code below.<br />
<br />
<b>Example Starting CSV:</b><br />

<pre><code class="code-1 nolinks" id="code-20-42356730-1"><span>&quot;email&quot;,&quot;Column2&quot;</span>
<span>&quot;User@YourDomain.com&quot;,&quot;Column2 Value&quot;</span>
<span>&quot;User2@YourDomain.com&quot;,&quot;Another Column2 Value&quot;</span>
</code></pre>
<br />
<b>Powershell code to replace the original CSV with one which contains the column of values:</b><br />
<br />

<pre><code class="code-10 nolinks" id="code-20-42356730-2"><span>$CSVFile=&quot;\\tsclient\C\Admin\Experts-Exchange\29066762\emails2.csv&quot;</span>
<span>$Obj = Import-CSV $CSVFile</span>
<span>$NewObj = @()</span>
<span>Foreach ($O in $Obj) {</span>
<span>	$SAMID = Get-ADUser -properties * -filter &quot;emailaddress -eq '$($O.email)'&quot; | Select -expandproperty SAMAccountName</span>
<span>	$O | Add-Member –MemberType NoteProperty –Name SAMID –Value $SAMID</span>
<span>	$NewObj += $O </span>
<span>}</span>
<span></span>
<span>$NewObj | Export-CSV $CSVFile</span>
</code></pre>
<br />
<b>Example changed CSV:</b><br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42356730-3"><span>#TYPE System.Management.Automation.PSCustomObject</span>
<span>&quot;email&quot;,&quot;Column2&quot;,&quot;SAMID&quot;</span>
<span>&quot;User@YourDomain.com&quot;,&quot;Column2 Value&quot;,&quot;User_SAM_ID&quot;</span>
<span>&quot;User2@YourDomain.com&quot;,&quot;Another Column2 Value&quot;,&quot;User2_SAM_ID&quot;</span>
</code></pre>
<br />
<b>Note the above code is setup to retain ALL of the data in all of the columns you already have in your CSV.</b>
</div>


<div>
Hi<br />
<br />
I was unable to get it to work<br />
is there a method to just do it from scratch?<br />
and produce a csv file from my AD containing only user accounts with a valid email address alongside the samaccount
</div>


<div>
Did you try my post?<br />
<a href="https://www.experts-exchange.com/questions/29066762/extract-SamAccountName-from-email-address-csv-file.html?anchor=a42358110&notificationFollowed=199891428&anchorAnswerId=42356644#a42356644" rel="ugc">https://www.experts-exchange.com/questions/29066762/extract-SamAccountName-from-email-address-csv-file.html?anchor=a42358110&notificationFollowed=199891428&anchorAnswerId=42356644#a42356644</a>
</div>


<div>
i did but its something im not doing correctly<br />
am i right in saying i need to copy that code into notepad and save as .ps1<br />
then run?
</div>


<div>
You can just paste it into your powershell prompt. If you're running Windows 2012 or newer you can paste as is. If it's 2008 R2, you need to first run <b>Import-Module activedirectory</b>
</div>


<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Split: <br />
-- Jeremy Weisinger (<a href="https:#a42356644" rel="ugc">https:#a42356644</a>)<br />
-- Ben Personick (Previously QCubed) (<a href="https:#a42358360" rel="ugc">https:#a42358360</a>)<br />
<br />
<br />
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.<br />
<br />
Pber<br />
Experts-Exchange Cleanup Volunteer
</div>


<div>
<div class="content wysiwyg-content">
i have a csv file populated with email addresses<br />
i also need there SamAccountName<br />
Rather than look each of these up<br />
Is there a method that could query the email addresses in the csv and populate another column with the SamAccountName?
</div>
</div>


i have a csv file populated with email addresses
i also need there SamAccountName
Rather than look each of these up
Is there a method that could query the email addresses in the csv and populate another column with the SamAccountName?

extract SamAccountName from email address csv file

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

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.