<div>
I've almost got it. It's just the 'filter' part I need help with. This:<br />
<br />

<pre><code id="code-20-40875950-1">PS C:\Temp&gt; import-csv &quot;c:\temp\users.csv&quot; | Get-ADUser -filter 'samaccountname
-like &quot;*&quot;' | FT name</code></pre>
<br />
Nearly works but because I've put the wildcard in, it's trying to return every AD object! What filter do I need so it only looks at what's in the CSV file?
</div>


I've almost got it. It's just the 'filter' part I need help with. This:



PS C:\Temp> import-csv "c:\temp\users.csv" | Get-ADUser -filter 'samaccountname
-like "*"' | FT name


Nearly works but because I've put the wildcard in, it's trying to return every AD object! What filter do I need so it only looks at what's in the CSV file?

<div>
Can't test it at the moment, but that should do it:<br />

<pre><code id="code-20-40875952-1">Get-Content -Path &quot;C:\Temp\users.txt&quot; | % {Get-ADUser -Identity $_} | Select-Object -Property SamAccountName, DistinguishedName</code></pre>
To put that into a csv file again:<br />

<pre><code id="code-20-40875952-2">Get-Content C:\Temp\users.csv | % {Get-ADUser -Identity $_} | Select-Object -Property SamAccountName, DistinguishedName | Export-Csv -Path &quot;C:\Temp\export.csv&quot; -NoTypeInformation</code></pre>
</div>


Can't test it at the moment, but that should do it:


Get-Content -Path "C:\Temp\users.txt" | % {Get-ADUser -Identity $_} | Select-Object -Property SamAccountName, DistinguishedName

To put that into a csv file again:


Get-Content C:\Temp\users.csv | % {Get-ADUser -Identity $_} | Select-Object -Property SamAccountName, DistinguishedName | Export-Csv -Path "C:\Temp\export.csv" -NoTypeInformation

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm looking to do something that I assume is quite simple for someone in the know. I have a CSV file with a list of SAMAccountNames and from that I want to use Powershell to output a list of Distinguished Names. Anyone know how?<br />
<br />
Thanks.
</div>
</div>


Hi,

I'm looking to do something that I assume is quite simple for someone in the know. I have a CSV file with a list of SAMAccountNames and from that I want to use Powershell to output a list of Distinguished Names. Anyone know how?

Thanks.

Get DN from SAMAccountName

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.

Active Directory

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.