<div>
For Groups, you can use within Powershell AD Module<br />
<br />
PowerShell<br />
Import-Module activedirectory<br />
Get-ADGroupMember -Identity &lt;GroupName&gt; | Select Name, sAMAccountName | Export-csv &lt;Csv file path&gt;<br />
<br />
You can create excel file with concatenate function for all groups and add output of this excel file in .ps1 file<br />
<br />
Example<br />

<pre><code id="code-8267508">Powershell
import-module activedirectory
Get-ADGroupMember -Identity Group1 | Select Name, SamAccountName | Export-csv C:\group1.csv
Get-ADGroupMember -Identity Group2 | Select Name, SamAccountName | Export-csv C:\group2.csv</code></pre>
<br />
For list of users you can use Bulk AD users from WiseSoft, a free tool which can give you output based on list
</div>


For Groups, you can use within Powershell AD Module

PowerShell
Import-Module activedirectory
Get-ADGroupMember -Identity <GroupName> | Select Name, sAMAccountName | Export-csv <Csv file path>

You can create excel file with concatenate function for all groups and add output of this excel file in .ps1 file

Example


Powershell
import-module activedirectory
Get-ADGroupMember -Identity Group1 | Select Name, SamAccountName | Export-csv C:\group1.csv
Get-ADGroupMember -Identity Group2 | Select Name, SamAccountName | Export-csv C:\group2.csv


For list of users you can use Bulk AD users from WiseSoft, a free tool which can give you output based on list

<div>
Exactly what I needed. &nbsp;Thank you.
</div>


<div>
<div class="content wysiwyg-content">
I have a request to pull a list from Active Directory of First and Last names from a list of usernames and list users in a list of AD groups.<br />
<br />
Does anyone have a script for the following?<br />
1. Based on a list of usernames in a text file, Query First and Last names to a .csv<br />
2. Export group membership to a .csv<br />
Thanks.
</div>
</div>


I have a request to pull a list from Active Directory of First and Last names from a list of usernames and list users in a list of AD groups.

Does anyone have a script for the following?
1. Based on a list of usernames in a text file, Query First and Last names to a .csv
2. Export group membership to a .csv
Thanks.

Need a script to export group membership and user names from Active Directory

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

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

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.