Import to CSV from Exchange 2010

use below one:

Get-mailbox -ResultSize unlimited | select Name,PrimarySMTPAddress,issuewarningquota,ProhibitSendquota,ProhibitSendReceiveQuota | Export-csv c:\data.csv

Select allOpen in new window

How can I do this just for users in a csv file. When I try the below only 1 user is outputted:

$userlist = import-csv .\limit.csv
foreach ($user in $userlist){
get-mailbox -Identity $user.email | select name,issuewarningquota,prohibitsendquota,prohibitsendreceivequota | Export-Csv .\viewer.csv
}

and the example you gave will search all mailboxes when I only need to get the info for users in the limit csv and then output to new csv named what ever.

Add -append to your Export-CSV cmdlet.

$userlist = import-csv .\limit.csv
foreach ($user in $userlist){
get-mailbox -Identity $user.email | select name,issuewarningquota,prohibitsendquota,prohibitsendreceivequota | Export-Csv .\viewer.csv -append
}

Select allOpen in new window

This is the error i got when -append was added:
Export-Csv : A parameter cannot be found that matches parameter name 'append'.

I'm using exchange management shell but powershell 2.0

any other suggestions by chance.

Ohhhhhhh. Powershell 2.0, eh?

Try this:

$userlist = import-csv .\limit.csv
foreach ($user in $userlist){
$results += get-mailbox -Identity $user.email | select name,issuewarningquota,prohibitsendquota,prohibitsendreceivequota
}
$results | Export-Csv .\viewer.csv

Select allOpen in new window

This is the error I now get:

+= : Method invocation failed because [System.Management.Automation.PSObject] doesn't contain a method named 'op_Addition'.
At line:2 char:12
+ $results += <<<<  get-mailbox -Identity $user.email | select name,issuewarningquota,prohibitsendquota,prohibitsendreceivequota
    + CategoryInfo          : InvalidOperation: (op_Addition:String) [], RuntimeException
    + FullyQualifiedErrorId : MethodNotFound

Powershell 2.0 (!@$#%!@#@#$)

I have nothing to test with but I think this should work:

$userlist = import-csv .\limit.csv
foreach ($user in $userlist){
    $lo = get-mailbox -Identity $user.email | select name,issuewarningquota,prohibitsendquota,prohibitsendreceivequota
    $results = $results + $lo
 }
$results | Export-Csv .\viewer.csv

Select allOpen in new window

Nope same error. I will update WMF and get a more current verison of PS and give it a try.

Perfect and thanks.