<div>
From a DC, run this command: <br />
dsquery user domainroot -limit 0 | dsget user -dn -fn -ln &nbsp; &gt;c:\list.txt<br />
<br />
That will create the output in a textfile that can be brought into XLS. 
</div>


From a DC, run this command:
dsquery user domainroot -limit 0 | dsget user -dn -fn -ln   >c:\list.txt

That will create the output in a textfile that can be brought into XLS.

<div>
<div class="content wysiwyg-content">
I need to produce a report in excel that will give a sortable list of first names, last names and logon names of active directory users.
</div>
</div>


I need to produce a report in excel that will give a sortable list of first names, last names and logon names of active directory users.

I need a script to display first names, last names and logon names of active directory users.

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

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.