**********************
Windows PowerShell Transcript Start
Start time: 20130131102344
Username : vdi.lab\amasv
Machine : EX2010-2 (Microsoft Windows NT 6.1.7600.0)
**********************
Transcript started, output file is C:\Users\amasv\Documents\PowerShell_transcript.20130131102344.txt
[PS] C:\Windows\system32>Get-MailboxDatabase -Status | select ServerName,Name,DatabaseSize
ServerName Name DatabaseSize
———- —- ————
EX2010-2 DB1 24.76 GB (26,585,137,152 bytes)
EX2010-2 DB2 24.51 GB (26,315,128,832 bytes)
EX2010-2 DB3 64.51 GB (69,272,141,824 bytes)
EX2010-2 DB4 112.4 GB (120,677,007,360 bytes)
EX2010-2 DB5 15.63 GB (16,786,194,432 bytes)
EX2010-2 DB6 28.63 GB (30,745,886,720 bytes)
EX2010-1 DB7 136.1 MB (142,671,872 bytes)
EX2010-1 DB8 5.633 GB (6,048,251,904 bytes)
EX2010-1 DB9 3.883 GB (4,169,203,712 bytes)
[PS] C:\Windows\system32>Get-MailboxDatabase -Status | select ServerName,Name,DatabaseSize | Sort-Object DatabaseSize -Descending | measure-object -Property DatabaseSize -Sum -Maximum
Count : 9
Average :
Sum : 300741623808
Maximum : 120677007360
Minimum :
Property : DatabaseSize
[PS] C:\Windows\system32>get-mailboxserver * | Get-MailboxStatistics | sort-object -Property totalitemsize -des | select-object displayname, totalItemSize -first 10
DisplayName TotalItemSize
———– ————-
user1 5.438 GB (5,838,972,934 bytes)
user2 5.421 GB (5,820,989,079 bytes)
user3 2.831 GB (3,040,076,803 bytes)
[PS] C:\Windows\system32>Stop-Transcript
**********************
Windows PowerShell Transcript End
End time: 20130131102532
**********************
for better sorting
| Select-Object eventid,sender,timestamp,@{Name=“Recipients“;Expression={$_.recipients}},@{Name=“RecipientStatus“;Expression={$_.recipientstatus}},messagesubject |
Export-CSV filename.csv
