<div>
Does this have to be vbscript? &nbsp;There are other ways such as powershell, adfind, that can make this easier than vbscript.<br />
<br />
Even free GUI tools like adinfo &nbsp; <a href="http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html" rel="ugc">http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html</a><br />
<br />
I don't have a vbscript handy but can help with other methods if you are interested.<br />
<br />
Thanks<br />
<br />
Mike
</div>


Does this have to be vbscript?  There are other ways such as powershell, adfind, that can make this easier than vbscript.

Even free GUI tools like adinfo   http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html [http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html]

I don't have a vbscript handy but can help with other methods if you are interested.

Thanks

Mike

<div>
Hi mkline,<br />
<br />
I am interested in Powershell or free GUI tools. The condition is that a single query/execution must output all requested data into one CSV file. Thank you for responding so promptly.<br />
<br />
Kind regards,<br />
Walt
</div>


Hi mkline,

I am interested in Powershell or free GUI tools. The condition is that a single query/execution must output all requested data into one CSV file. Thank you for responding so promptly.

Kind regards,
Walt

<div>
Hi Spec01: this solution is exactly what I needed! Kudos! Many, many thanks!
</div>


Hi Spec01: this solution is exactly what I needed! Kudos! Many, many thanks!

<div>
<div class="content wysiwyg-content">
Points of My Scenario<br />
1. I am admin of a Windows Server 2008 R2 domain<br />
2. I need to create monthly reports on users in Active Directory<br />
3. The report must contain (a) username (b) Full name (c) User's OU/container (d) User's last login time (e) User's creation date<br />
<br />
REQUEST: Please provide a VBscript that will output the data (specified in point#3) to CSV file.
</div>
</div>


Points of My Scenario
1. I am admin of a Windows Server 2008 R2 domain
2. I need to create monthly reports on users in Active Directory
3. The report must contain (a) username (b) Full name (c) User's OU/container (d) User's last login time (e) User's creation date

REQUEST: Please provide a VBscript that will output the data (specified in point#3) to CSV file.

I Need A VBscript To Export AD User Data

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.

VB Script

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.