How to extract Active Directory users with Get-ADGroup and Get-ADGroupMember

Question: I have a large list of Active Directory Groups and would like to extract the users from these Active Directory Groups. How can I script to iterate through a large list of Active Directory Group and list users using Powershell?

Answer: Powershell has a very effective set of Active Directory modules. Within the set of AD modules , it is possible to achieve listing AD group members , group per group , combining  Powershell Get-ADGroup and Get-ADGroupMember

The basic flow is to extract the AD groups - place them  into a DataTable  and then iterate through the DataTable rows , using Get-ADGroupMember .      The best way to illustrate is to use an example.

The first step is to place the Get-ADGroup list into the $dt DataTable.   

The second step is to iterate using the foreach loop and execute the  Get-ADGroupMember per item. 

The end result will be a list of your AD groups and under every AD group the members

For example:

mygroup1

user1

user2

mygroup2

user

$dt = new-object "System.Data.DataTable"
$dt = Get-ADGroup -Filter "name -like '*.myfilter'" -Properties * | select name

foreach ($Row in $dt) { 

	write-Output "$($Row.Name)"
       $row_name = "$($Row.Name)"
       Get-ADGroupMember -identity “$row_name” | select name 
	
}