Hi,

I have a recurring issue with try to get-mailboxstatistics for a list of mailboxes (using get-content) by using the foreach loop and getting correct results outputted to a csv file.

My coding runs something like this:


$file= Get-content C:\scripts\infiles\mylist.txt
$outfile= c:\scripts\outfiles\mbx_stats_results.csv

Foreach($mbx in $file){
Get-Mailboxstatistics $mbx | SELECT DisplayName, TotalItemSize | Export-Csv $outfile
}

The problem is that only the last mbx in $file is outputted. However, if I take away the Export-csv, the results display correctly in the shell.

What exactly is the magic mix of coding when I want results for a command using a subset of data from a list, and outputting those results to a csv file?

I have the same issue when trying to get mailbox permissions from a list of mailboxes.


Any help would be greatly appreciated.
Powershell Rocks! So do I, back and forth....when i don't understand the commands! :-)


Cheers
Adrian

Adrian;
As you have discovered, Export-Csv does not append data, it overwrites.
See if Dmitry Sotnikov’s post helps:
http://dmitrysotnikov.wordpress.com...sv-append/

Also, you can do thei in your foreach:


Karl

Thankyou for the reply and pointer to Dmitry's blog. 


I also found that If I saved the command into a ps1 then piped the export, the csv file automatically gave me all the results (appended the data) eg:

getmailboxstats.ps1 | Export-Csv c:\scripts\outfiles\MbxStatsResults.csv

Helps to have a go eh?

Thanks once again :-)

You can also do this:

Karl