<div>
<br />
If you were to go with PowerShell, and had Quest's CmdLets there's not much more to it than this:<br />
<br />
<br />
Import-CSV &quot;YourCSVFile.csv&quot; | `<br />
&nbsp; %{ Get-QADUser $_.Name } | `<br />
&nbsp; Select Name, sAMAccountName | `<br />
&nbsp; Export-CSV &quot;SomeNewFile.csv&quot;<br />
<br />
<br />
That assumes the CSV file has a column called Name. If it encounters a duplicate name in AD it will output all matches.<br />
<br />
Chris
</div>



If you were to go with PowerShell, and had Quest's CmdLets there's not much more to it than this:


Import-CSV "YourCSVFile.csv" | `
  %{ Get-QADUser $_.Name } | `
  Select Name, sAMAccountName | `
  Export-CSV "SomeNewFile.csv"


That assumes the CSV file has a column called Name. If it encounters a duplicate name in AD it will output all matches.

Chris

<div>
Hi Chris,<br />
<br />
Thank for the script, actually the csv file as First name , last name.<br />
Is there is away to get the script checks both First name and the last name ?<br />
<br />
Thanks<br />

</div>


Hi Chris,

Thank for the script, actually the csv file as First name , last name.
Is there is away to get the script checks both First name and the last name ?

Thanks


<div>
<div class="content wysiwyg-content">
Hi everyone,<br />
<br />
I need a power shell, vbs script to check an excel sheet or even a csv file that has a display name for some users and convert them to SAMID and output the results in a text file.<br />
<br />
Thanks<br />

</div>
</div>


Hi everyone,

I need a power shell, vbs script to check an excel sheet or even a csv file that has a display name for some users and convert them to SAMID and output the results in a text file.

Thanks


Script to convert users display name to sam id

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

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.