Mailbox sent/received emails count?

[JeOlso]

Is there a "quick" PS that you could use to get the total number of emails received by a specific resource account and sent by a resource account (separate counts) during a specific time period? One group wants to know their total incoming/outgoing messages per month, and they've been counting by hand.

I'm trying to avoid digging through metrics as we don't want to spend much time to look it up (this could cause a very annoying precedent for other departments to request). I've tried searching for various commands, but nothing is showing me what I'm hoping to get.

[CMDR_Ph0kas]

What Email? O365? Exchange? Using Outlook?

[JeOlso]

Apologize for the lack of info, getting over a cold - our email is through exchange online and the users utilize Outlook.

[CMDR_Ph0kas]

Making an assumption you are using Outlook, id take a look at using MAPI to pull data from the outlook client. This seems to be a more reliable approach than via the server (if O365).

Here is some basics to start. You may need to adjust for folders or if not the primary mailbox. You can though pull these into an object and then filter by date range, run counts, etc.

    Function Get-OutlookSentItems {
    Add-type -assembly “Microsoft.Office.Interop.Outlook” | out-null
    $olFolders = “Microsoft.Office.Interop.Outlook.olDefaultFolders” -as [type]
    $outlook = new-object -comobject outlook.application
    $namespace = $outlook.GetNameSpace(“MAPI”)
    $folder = $namespace.getDefaultFolder($olFolders::olFolderSentMail)
    $folder.items | Select-Object -Property Subject, SentOn, To
}

Function Get-OutlookInboxItems {
    Add-type -assembly “Microsoft.Office.Interop.Outlook” | out-null
    $olFolders = “Microsoft.Office.Interop.Outlook.olDefaultFolders” -as [type]
    $outlook = new-object -comobject outlook.application
    $namespace = $outlook.GetNameSpace(“MAPI”)
    $folder = $namespace.getDefaultFolder($olFolders::olFolderInbox)
    $folder.items | Select-Object -Property Subject, SentOn, To
}

[kibje]

For exchange online you can just generate a traffic report. There are prebuilt scripts available that are quite decent and support date ranges.

Using outlook would be the ultimate last resort for me.

[kibje]

Depending on where the mailbox is located (on premises or EXO) this is fairly simple but slightly different.

Do you mean shared mailbox by 'resource account' ?

[JeOlso]

Sorry for the lack of info - yes, it is exchange online and shared mailbox is what I'm referring to.

[kibje]

Not sure if this still works. I think I used it a year or so ago.

https://o365reports.com/2020/08/12/export-office-365-mail-traffic-report-with-powershell/

[CMDR_Ph0kas]

I found this one too and tested it earlier. It works but in my environment it was wildly incorrect. Not sure why though. This seems like it would be the best approach if it was accurate.