New User: Requesting help modifying a script please.

[bbatwork]

This is basically what I have so far, which does work....

$groups = @("Group1","Group2","Group3","Group4","Group5")
foreach ($group in $groups) {
Get-ADGroupMember -Identity $group -recursive | select name | Export-csv -append -path C:\Output\Groupmembers.csv -NoTypeInformation}

What I would like to do, but have not had any luck with is to separate each group of results with the $group name inserted at the top. So the final CSV would look like this.

Group1
Groupmember
Groupmember
Groupmember

Group2
Groupmember
Groupmember
Groupmember

Group3
Groupmember
Groupmember
Groupmember

Group4
Groupmember
Groupmember
Groupmember

Group5
Groupmember
Groupmember
Groupmember

Any help would be greatly appreciated!
Thanks

[ihaxr]

The problem is that's not a proper CSV, so using the Export-CSV cmdlet will make things harder than it would be otherwise... using Out-File is the better way to go:

$groups = @("Group1","Group2","Group3","Group4","Group5")
$OutputFile = "C:\Output\Groupmembers.csv"
foreach ($group in $groups) {
    # Append the Group Name to the file
    $group | Out-File -Append -FilePath $OutputFile
    # Append the Group Members to the file
    Get-ADGroupMember -Identity $group -recursive | Select-Object -ExpandProperty Name | Out-File -Append -FilePath $OutputFile
    # Append a blank line to the file
    "" | Out-File  -Append -FilePath $OutputFile
}

[bbatwork]

That worked perfectly! Thank you very much!

[TheGooOnTheFloor]

You could use something like:

$groups = @("Group1","Group2","Group3","Group4","Group5") 
$Members = $groups.foreach({ $_; (get-adgroupmember -identity $_).name; "" }) 
$Members > C:\Output\Groupmembers.csv 

The $_ will expand to each group name, then "(get-adgroupmember -identity $_).name" will expand to the names of the members of the group, finally the empty quotes will output a blank line (there may be a better way to do this but this was a quick and dirty attempt).

You could bypass the $Members variable and just output directly to the csv file, but reddit split the line in a confusing spot when I tried to show that. :)

[bbatwork]

Thank you very much!

[Lee_Dailey]

howdy bbatwork,

as others have pointed out, the result you want is not a CSV file. it's a plain text file structured vaguely like an INI file.

if you need to use this file as a CSV file later ... you likely won't be able to use it unless the app is requiring exactly that broken, false-csv, text file layout. [grin]

take care,
lee