question

RobertTappin-5032 avatar image
0 Votes"
RobertTappin-5032 asked StephenJHare-0893 answered

Exchange 2019 (On-Prem) - Audit unread emails in users mailboxes

Good day everyone,

I have a site I do support for, their office manager would like to start keeping tabs on which users have unread emails.
They have an Exchange server onsite, she doesn't need to read the emails but she wants to be able to either run an audit or report or query to find out if say KellyB has 400 unread emails sitting in her inbox.
*I realize the users could just go in an mark emails as read, but we're just looking to make sure these users have had some sort of interaction with the emails they are receiving.

office-exchange-server-administration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KaelYao-MSFT avatar image
0 Votes"
KaelYao-MSFT answered

Hi @RobertTappin-5032

I suppose you may use the Search-Mailbox command in Exchange Management Shell to achieve this goal.
Before running the command, you may first need to assign Mailbox Search or Mailbox Import Export roles to the account which is used to run this command.

The command would be like:

  Get-Mailbox -ResultSize Unlimited -Filter {RecipientTypeDetails -eq "UserMailbox"} | Search-Mailbox -SearchQuery "isread:false kind:email" -TargetFolder Report -Targetmailbox user01 -LogLevel Full -Logonly

This command will search all user mailboxes and generate a report of the unread emails in user01's (the person to send the report to) "Report" folder.
(If the folder doesn't exist, it will create the folder. You may use an existing folder like "inbox" as well)
In addition, please don't forget to add "-Logonly" to the command, otherwise the unread emails will be copied to the target folder.


The detailed result can be viewed in the "Search Results.csv" file in the attachment.
105127-07.jpg

You may use Excel or other software to get a better view of the result.

In the report, you may see the detailed information of the unread emails ( in which mailbox, in which folder, sent/received time, etc.)
105149-08.jpg


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





07.jpg (35.2 KiB)
08.jpg (84.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

StephenJHare-0893 avatar image
0 Votes"
StephenJHare-0893 answered

this is what I want except for Exchange Online. Anyway to do this with the Online version?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.