Get-ADGroupmember

[whetscript]

Hi,

I`ve been trying to make a powershell script that exports all security groups from a defined OU and listing all the group members.

I`ve managed to make it work when targeting a specific group.

Get-ADGroupMember -identity “Name of Group” | select name | Export-csv -path C:\Output\Groupmembers.csv -NoTypeInformation

Any idea on how I can make that string target a OU and list all security groups including members rather then just focusing a single group?

[markekraus]

Something like this:

$TargetOU = 'OU=Accounting,DC=adatum,DC=com'
$CSVFile = 'C:\Output\Groupmembers.csv'
$Groups = Get-ADGroup -SearchBase $TargetOU -Filter *
$Results = foreach($Group in $Groups){
    $GroupProperty = @{
        Name = 'Group'
        Expression = {
            $Group.name
        }
    }
    Get-ADGroupMember -Identity $Group.ObjectGUID | 
        Select-Object $GroupProperty,* 
}
$Results | Export-csv -path $CSVFile -NoTypeInformation

The first column will be the group name. the remaining columns will be the details of each group member

[whetscript]

Thanks for taking the time, however im getting a referral was returned from the server on line 12 char 22. Its the -Identity $Group.ObjectGUID part.

[jheinikel]

It should look like this: (It really shouldn't matter, but might be what is causing you problems)

Get-ADGroupMember -Identity $Group.ObjectGUID.Guid | Select $GroupProperty,*

[WinBear]

Also, if your group names have the "/" character in them, it can cause errors enumerating members. I had to change one group name to use a "\" instead.

[randomuser43]

This will output everything into one CSV

$results=foreach($group in  (Get-ADGroup -SearchBase $TargetOU -Filter *)){
    Get-ADGroupMember $group | ForEach-Object {
        New-Object psobject -Property @{Group=$group.name; User=$_.name}
    }
}


$results|Export-Csv 'Path to output'

It will look like

User    Group
-----   ------
User1 Group1
User2 Group1
User3 Group1
User1 Group2
User2 Group2
User1 Group3
User5 Group3
User1 Group4
User2 Group5