$yesterday=(get-date).adddays(-1) $tomorrow=(get-date).adddays(+1) $output=[pscustomobject]@{ DisplayName="" sent = 0 recieved = 0 RecipientTypeDetails ="" PrimarySmtpAddress="" } $mailboxes=get-mailbox -ResultSize unlimited foreach ($mailbox in $mailboxes) { $output.DisplayName=$mailbox.DisplayName $output.DisplayName $output.PrimarySmtpAddress=$mailbox.PrimarySmtpAddress $output.PrimarySmtpAddress $output.RecipientTypeDetails=$mailbox.RecipientTypeDetails $output.RecipientTypeDetails $output.sent=(Get-MessageTrackingLog -Start $yesterday -End $tomorrow -Sender (get-mailbox $mailbox).primarysmtpaddress -ResultSize unlimited).count $output.sent $output.recieved=(Get-MessageTrackingLog -Start $yesterday -End $tomorrow -recipient (get-mailbox $mailbox).primarysmtpaddress -ResultSize unlimited ).count $output.recieved $output| export-csv -noTypeInformation -append -path c:\temp\output.csv }{"id":1644,"date":"2021-10-28T21:09:26","date_gmt":"2021-10-28T13:09:26","guid":{"rendered":"https:\/\/www.itforce.mn\/?p=1644"},"modified":"2021-10-28T21:10:33","modified_gmt":"2021-10-28T13:10:33","slug":"how-to-count-traffic-for-each-mailbox-in-exchange","status":"publish","type":"post","link":"https:\/\/www.itforce.mn\/index.php\/2021\/10\/28\/how-to-count-traffic-for-each-mailbox-in-exchange\/","title":{"rendered":"How to count traffic for each mailbox in Exchange"},"content":{"rendered":"<pre>\r\n$yesterday=(get-date).adddays(-1)\r\n$tomorrow=(get-date).adddays(+1)\r\n\r\n$output=[pscustomobject]@{\r\nDisplayName=\"\"\r\nsent = 0\r\nrecieved = 0\r\nRecipientTypeDetails =\"\"\r\nPrimarySmtpAddress=\"\"\r\n}\r\n\r\n$mailboxes=get-mailbox -ResultSize unlimited\r\nforeach ($mailbox in $mailboxes)\r\n{\r\n$output.DisplayName=$mailbox.DisplayName\r\n$output.DisplayName\r\n$output.PrimarySmtpAddress=$mailbox.PrimarySmtpAddress\r\n$output.PrimarySmtpAddress\r\n$output.RecipientTypeDetails=$mailbox.RecipientTypeDetails\r\n$output.RecipientTypeDetails\r\n$output.sent=(Get-MessageTrackingLog -Start $yesterday -End $tomorrow -Sender (get-mailbox $mailbox).primarysmtpaddress -ResultSize unlimited).count\r\n$output.sent\r\n$output.recieved=(Get-MessageTrackingLog -Start $yesterday -End $tomorrow -recipient (get-mailbox $mailbox).primarysmtpaddress -ResultSize unlimited ).count\r\n$output.recieved\r\n$output| export-csv -noTypeInformation -append -path c:\\temp\\output.csv\r\n}\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":null,"protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-1644","post","type-post","status-publish","format-standard","hentry","category-exchange-server"],"_links":{"self":[{"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/posts\/1644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/comments?post=1644"}],"version-history":[{"count":2,"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/posts\/1644\/revisions"}],"predecessor-version":[{"id":1646,"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/posts\/1644\/revisions\/1646"}],"wp:attachment":[{"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/media?parent=1644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/categories?post=1644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itforce.mn\/index.php\/wp-json\/wp\/v2\/tags?post=1644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}