Export Powershell output to CSV

Question

I have the following code intended to take a list of user names and output a CSV report of username - GroupMembership. At the command line the output looks great as i get "name" on the left and recursive "group memberships" on the right (see pic https://i.sstatic.net/zLxUR.jpg for command line output, sorry can't post imbedded Pics yet)

I would like to have the output written to a CSV file with the same format, namely Username in one column and GroupMemberships in the second column.. Original code from: http://thesurlyadmin.com/2013/03/21/get-a-users-group-memberships/ with a few small changes.

Param (
   [Parameter(Mandatory=$true,ValueFromPipeLine=$true)]
   [Alias("ID","Users")]
   [string[]]$User
)
Begin {
   Try { Import-Module ActiveDirectory -ErrorAction Stop }
   Catch { Write-Host "Unable to load Active Directory module, is RSAT installed?"; Break }
}

Process {
    ForEach ($U in $User)
   {  $UN = Get-ADUser $U -Properties MemberOf
      $Groups = ForEach ($Group in ($UN.MemberOf))
      {   (Get-ADGroup $Group).Name
      }
      $Groups = $Groups | Sort
      ForEach ($Group in $Groups)
      {  New-Object PSObject -Property @{
            Name = $UN.Name
            Group = $Group
         }
      }
   }
}

I tried using this "$PSObject | Export-CSV C:\Scripts\GroupMembershipList.csv" but it only writes the first line to the CSV and nothing after that.

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Nate,

In Powershell v3.0, the Export-CSV cmdlet introduced the -Append parameter.

Reference: http://technet.microsoft.com/en-us/library/hh849932.aspx

Not knowing the version of Powershell you are using, this may require an update on your side to make use of the new functionality.

In my own cases, I generally see the opposite issue if I forget to -Append to my CSV; I will only end up with the LAST entry as opposed to just the first.

I won't claim this to be your fix, but might be worth a shot...

Example: $PSObject | Export-CSV C:\Scripts\GroupMembershipList.csv -Append

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 19, 2014 at 22:13

Jason

306 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Funky_Crunch_Mahgeezachs Over a year ago

Jason, that did it sir, thank you very much! Tried to upvote and mark as answer but my reputation isn't high enough.

Collectives™ on Stack Overflow

Export Powershell output to CSV

1 Answer 1

Reference: http://technet.microsoft.com/en-us/library/hh849932.aspx

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Reference: http://technet.microsoft.com/en-us/library/hh849932.aspx

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related