Powershell script for retrieving AD information using piped Get commands then copy to csv file but getting "append" error

Question

I am trying to run multiple Get Commands to retrieve AD information. I piped all of these commands and now I want to write the output to write all the the information ito one csv but at the moment i am getting "a parameter can not be found that matches parameter named 'append'

    $OutFile = "C:\Results.csv"

#This gets the managedBy and name
$Domain=Get-addomain|select-object ManagedBy,Name | Export-csv -Path $OutFile -append -notypeinformation

#This gets the distinguished name
$Users=Get-ADUser -Filter *|select-object DistinguishedName | Export-csv -Path $OutFile -append -NoTypeInformation

#Gets User
$ADUsers=Get-ADUser -filter *| Export-csv -Path $OutFile -append -NoTypeInformation

Answer 1

What may work for you is to use arrays to create new objects that you can then output to a csv file. I've extracted the relevant portions of code I have used before (the names of variables have been changed to protect the innocent :) ) that should allow you to get the idea of how to make this work (and some google searches can fill in any other missing pieces):

Initialize the arrays you will be working with

$objOut = @()
$objWork= @()

Loop through the objects in a list - assumes that you will be building the csv from multiple answers/data that you will loop through to gather

Foreach ($objList in $list){

Within loop, assign to objwork the values that you will be adding to array, think of it as adding records in a DB. Assume that you are doing work here to gather your data that will populate the values for $firstvalue and $secondvalue (such as the AD calls you have)

$objWork = New-Object System.Object
$objWork | Add-Member -type NoteProperty -name header1 -value $firstvalue
$objWork| Add-Member -type NoteProperty -name header2 -value $secondvalue
$objOut += $objWork
}

Export the array of all the user details to a CSV file for consumption (yum!)

$objOut | Export-CSV C:\results.csv

Answer 2

I get an entirely different error, on the third command.

Export-csv : Cannot append CSV content to the following file: Results.csv. The appended object does not have a property that corresponds to the following column: ManagedBy. To continue with mismatched properties, add the -Force parameter, and then retry the command.

Which makes sense. You can't put different columns into a single CSV file. Export to plain text, or use multiple CSV files.