Exchange Technical Question

Soo all freekin day I have been trying to run an exchange command to get me the following

1, name of user (displayname)
2, total mailbox size
3, break down of the sizes of the subfolders (inbox, sent, deleted, etc etc)

This is what I’m running but I cannot get it to come out into a CSV file properly so all the results show on the same line. (note I cannot run export-csv as this seems to just bring 1 column of what I can only assume are SIDs)

Get-Mailbox | Get-MailboxFolderStatistics | fl identity, foldersize, Totalitemsize >c:\test.csv

I’m just not getting what I need out!

I had to do something similar over a year ago, you have to pipe the command into a FORMAT TABLE command if I remember correctly.