asked on

retrieving mailbox stats formatted

When I used the below:

Get-MailboxStatistics -database "db1" | fl displayname,storagelimitstatus,totalitemsize,totaldeleteditemsize,database,servername > c:\rpt.txt

I get

storagelimitstatus             : data1
servername                     : data
totaldeleteditemsize           : more-data
displayname                    : some-user 
totalitemsize                  : yada
database                       : bla

storagelimitstatus             : data2
servername                     : data
totaldeleteditemsize           : more-data
displayname                    : some-user 
totalitemsize                  : yada
database                       : bla

storagelimitstatus             : data3
servername                     : data
totaldeleteditemsize           : more-data
displayname                    : some-user 
totalitemsize                  : yada
database                       : bla

etc

Open in new window

How could I get the below?

storagelimitstatus,servername,totaldeleteditemsize,displayname,totalitemsize,database
data1,data,more-data,some-user,yada,bla
data2,data,more-data,some-user2,yada,bla
data3,data,more-data,some-user3,yada,bla
etc

Open in new window

SOLUTION

chrismerritt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Marketing_Insists

ASKER

Hmms, it just gives me a straight row of GUIDs

ASKER CERTIFIED SOLUTION