Yes, you are right, there is no property in the Get-MailboxStatistics cmdlets, hence I have modified it into:
Code: Select all
Get-MailboxDatabase -Server SITE03-EX01 | Get-Mailbox -Database "PRDSITE3-DB04" -ResultSize Unlimited |
Select-Object DisplayName,
servername,database,
RecipientTypeDetails,PrimarySmtpAddress,
HiddenFromAddressListsEnabled,
@{label="ItemCount";expression={(Get-MailboxStatistics $_).ItemCount}},
@{label="TotalItemSize";expression={(Get-MailboxStatistics $_).TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1MB),2}},
@{label="DeletedItemCount";expression={(Get-MailboxStatistics $_).DeletedItemCount}},
@{label="TotalDeletedItemSize";expression={(Get-MailboxStatistics $_).TotalDeletedItemSize}},
@{label="MailboxGuid";expression={(Get-MailboxStatistics $_).MailboxGuid}},
@{label="LastLogoffTime";expression={(Get-MailboxStatistics $_).LastLogoffTime}},
@{label="LastLogonTime";expression={(Get-MailboxStatistics $_).LastLogonTime}} |
Export-Csv -Path C:\Logs\Result.csv -NoTypeInformation
However, I am still having difficulties in the splitting the numbers?
here's the error:
At line:7 char:37
+ @{label="TotalItemSize";expression={(Get-MailboxStatistics $_).TotalItemSize.To ...
+ ~
Missing closing '}' in statement block.
At line:7 char:137
+ ... ace(",","")/1MB),2}},
+ ~
The hash literal was incomplete.
At line:7 char:137
+ ... ace(",","")/1MB),2}},
+ ~
Unexpected token ')' in expression or statement.
At line:7 char:140
+ ... (",","")/1MB),2}},
+ ~
Unexpected token '}' in expression or statement.
At line:7 char:141
+ ... ",","")/1MB),2}},
+ ~
Unexpected token '}' in expression or statement.
+ CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : MissingEndCurlyBrace
Your help is appreciated.