Exchange Shell Command to exclude system mailboxes and send mail automatically

I have exchange 2013 powershell script to get the output of all mailboxes and want the output .csv file it to be sent automatically as a email but excluding system mailboxes and mailboxes starts with Exchange*. 

NAME, EMAILID,DATABASEQUOTA,ISSUEWARNING,PROHIBITSENDQUOTA,PROHIBITSENDRECEIVEQUOTA,TOTALITEM,TOTALITEMSIZEINMB

Get-Mailbox -ResultSize Unlimited | Where {$_.UseDatabaseQuotaDefaults -eq $false} | Select-Object DisplayName, IssueWarningQuota, ProhibitSendQuota, @{label="TotalItemSize(MB)";expression={(Get-MailboxStatistics $_).TotalItemSize.Value.ToMB()}}, @{label="ItemCount";expression={(Get-MailboxStatistics $_).ItemCount}}, Database | Export-Csv "C:\Scripts\UserMailboxSizes.csv" NoTypeInformation

Experts! please help!

February 23rd, 2015 9:30pm

To send out the CSV file the simplest way is to use Send-MailMessage command. Btw, this is not Exchange command.
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2015 1:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics