Hi All

I have an AD group, it has many subgroups and users, for example
Group1 is my AD group. it has many groups and users added to it, i want to export users and groups residing in it to csv file.
Lets say Group1 has below groups and users and i want the output as in the below format.( i dont want to export all users of group2 and group4, i just need the group names)

Group2
user1
user2
group4

i am using below two syntaxes and i am not getting output.

Get-ADGroupMember -Identity "group1" | Get-ADUser -Properties Name,Description,UserprincipalName,SamAccountName,office,Department | Select Name,Description,UserprincipalName,SamAccountName,office,Department | Export-CSV -Path C:\temp\output.csv -NoTypeInformation

or

$props = "Name,Description,UserprincipalName,SamAccountName,office,Department,ObjectCategory" -split ','      
(Get-ADGroup -Identity "group1").Members | 
Select-Object @{n=Identity;v={$_}} |
Get-ADObject -Properties $props | 
Select-Object $props | Export-CSV -Path C:\temp\output.csv -NoTypeInformation

7 Spice ups

Something like this works but keep in mind, groups don’t have the same attributes available as users.

$members = Get-ADGroupMember -Identity "groupname" 
$results =  foreach($member in $members){
                if($member.objectclass -eq 'user'){Get-ADUser $member -Properties Name,Description,UserprincipalName,SamAccountName,office,Department | Select Name,Description,UserprincipalName,SamAccountName,office,Department}
                elseif($member.objectClass -eq 'group'){Get-adgroup $member -Properties Name,Description,UserprincipalName,SamAccountName,Department | Select Name,Description,UserprincipalName,SamAccountName,Department}
  }
$results | Export-CSV -Path C:\temp\output.csv -NoTypeInformation

1 Spice up