Hello everyone!!I have a command that I use that gives me the output I desire but how can I export it properly to a csv?Get-MailboxStatistics -server “servername” | Sort -Property TotalItemsize | Format-Table DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToKB()};label=”Size(KB)”}, LastLogonTime, LastLogoffTime I have exported it to a csv but it doesn't show any info. The display names are just sids, they don't show the user names and all the other columns are blank.Any help would be appreciated. Thanks in advance

Use select-object instead of format-table: Get-MailboxStatistics -server "servername" | Sort -Property TotalItemsize | select-object DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToKB()};label=”Size(KB)”}, LastLogonTime, LastLogoffTime | export-csv c:\report.csv -notype

Just replace format-table with select-object, and then pipe that out to export-csvGet-MailboxStatistics -server “servername” | Sort -Property TotalItemsize | select-object DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToKB()};label=”Size(KB)”}, LastLogonTime, LastLogoffTime | export-csv mbx_stats.csv -notype

Thanks for the replies. I had actually tried that beforehand but there was an error. I will try again and I'll post if it doesn't go through

When I use "select-object" the output is an error: Select-Object : Illegal Key LabelAt line:1 char:87select-object <<<< Displayname,Any thoughts?

Hi,The below command should helpGet-MailboxStatistics -server “servername” | Sort-Object TotalItemSize -Descending | Select DisplayName, LastLoggedOnUserAccount, ItemCount, LastLogonTime, LastLogoffTime, @{expression={$_.TotalItemSize.value.ToMB()}} | Export-CSV MailboxSizes.csvMahendra

Hi, The below command should help Get-MailboxStatistics -server “servername” | Sort-Object TotalItemSize -Descending | Select DisplayName, LastLoggedOnUserAccount, ItemCount, LastLogonTime, LastLogoffTime, @{expression={$_.TotalItemSize.value.ToMB()}} | Export-CSV MailboxSizes.csv Mahendra select is just an alias for select-object...

When I use "select-object" the output is an error: Select-Object : Illegal Key Label At line:1 char:87 select-object <<<< Displayname, Any thoughts? Works OK for me...maybe something is getting messed up in your copy/paste? Try typing it in from scratch.

@Mike --- Yes you are right but the error is due to label=”Size(KB) in the command.Mahendra

I get the same error even when just using Select. One more question if anyone knows. I can run this report and get the desired output. Just doesn't work when exporting to CSV. My other question is, from the command I have above, can I include 2 other exchange servers? We have 3 exchange servers in our environment and right now I run this command on a per server level. Is there a way in this command for it to run all 3 for just 1 report? Instead of running it for 1 and then the other

@Mike --- Yes you are right but the error is due to label=”Size(KB) in the command. Mahendra Yeah, but that is valid on PS v2. Roberto, if your using PS v1 try using "name" instead of "label" in your calculated property: @{name=”Size(KB)”;expression={$_.totalitemsize.value.ToKB()}}

I get the same error even when just using Select. One more question if anyone knows. I can run this report and get the desired output. Just doesn't work when exporting to CSV. My other question is, from the command I have above, can I include 2 other exchange servers? We have 3 exchange servers in our environment and right now I run this command on a per server level. Is there a way in this command for it to run all 3 for just 1 report? Instead of running it for 1 and then the other $result += Get-MailboxServer | Get-MailboxStatistics | Sort -Property TotalItemsize | select-object DisplayName, LastLoggedOnUserAccount, ItemCount, @{name=”Size(KB)”;expression={$_.totalitemsize.value.ToKB()}}, LastLogonTime, LastLogoffTime $result | Export-Csv c:\report.csv -notype

Thanks for all the replies. Mike you were right at first, it was a copy&paste issue. I had one value in the command that was causing the error. I want to thank you and Mayu whose command does work, it was just my error there.Is there a way to run this command for all 3 exchange servers? or do I have to run the command for one server and then the other?

Thanks for all the replies. Mike you were right at first, it was a copy&paste issue. I had one value in the command that was causing the error. I want to thank you and Mayu whose command does work, it was just my error there. Is there a way to run this command for all 3 exchange servers? or do I have to run the command for one server and then the other? Hi Roberto, To get the info from all 3 servers, try this: $result += Get-MailboxServer | Get-MailboxStatistics | Sort -Property TotalItemsize | select-object DisplayName, LastLoggedOnUserAccount, ItemCount, @{name=”Size(KB)”;expression={$_.totalitemsize.value.ToKB()}}, LastLogonTime, LastLogoffTime $result | Export-Csv c:\report.csv -notype

That's back to the origial problem of trying to do an export-csv on format-table.$result += Get-MailboxServer | Get-MailboxStatistics | Sort -Property TotalItemsize | select DisplayName, LastLoggedOnUserAccount, ItemCount, @{name=”Size(KB)”;expression={$_.totalitemsize.value.ToKB()}}, LastLogonTime, LastLogoffTime$result | Export-Csv c:\report.csv -notype

That's back to the origial problem of trying to do an export-csv on format-table. $result += Get-MailboxServer | Get-MailboxStatistics | Sort -Property TotalItemsize | select DisplayName, LastLoggedOnUserAccount, ItemCount, @{name=”Size(KB)”;expression={$_.totalitemsize.value.ToKB()}}, LastLogonTime, LastLogoffTime $result | Export-Csv c:\report.csv -notype my bad...copy/paste fail. fixed.

BTDT :)

Works great. Thanks to everyone for the help!!