Creating CSV output with headers

Hi charlie4872,

To add headers to your CSV output, you can try the following changes to your script. Instead of appending each line of data directly, we can first try to write the headers and then write the data below them.

Here's the updated script:

# Get a list of all AD groups with names starting with 'GLN-GOV' and sort them by name
$groupList = Get-ADGroup -Filter {Name -like 'GLN-GOV*'} | Sort-Object Name | Select-Object Name

# Set the CSV file path
$csvFilePath = ".\testing.csv"

# Define headers
$headers = "Group Name", "Member Name", "SamAccountName", "UserPrincipalName", "Office", "Department"

# Write the headers to the CSV file
$headers -join "," | Out-File -FilePath $csvFilePath -Encoding UTF8

# Loop through each group and get its members
foreach ($group in $groupList) {
    $memberList = Get-ADGroupMember -Identity $group.Name | Get-ADUser -Properties Name, SamAccountName, UserPrincipalName, Office, Department |
                  Select-Object Name, SamAccountName, UserPrincipalName, Office, Department

    # Output the group and its members to the file
    foreach ($member in $memberList) {
        $output = """$($group.Name)"",""$($member.Name)"",""$($member.SamAccountName)"",""$($member.UserPrincipalName)"",""$($member.Office)"",""$($member.Department)"""
        Add-Content -Path $csvFilePath -Value $output
    }
}