Exchange 2013 Public Folder Report with Last Access Date

Question

Hi,

Is there anyway to get last access date for public folders? This is for a clean up process. We've found that there is a parameter called "LastModificationTime" but that is not last access date or time.

Thanks in advance,

Regards,
Kavindu

Answer 1

Hi,

In Exchange 2010, this can be retrieved using Get-PublicFolderStatistics but with Exchange 2013 and with the modern public folders, we can get this information using Get-MailboxStatistics as the Public folders reside in the mailboxes.

Also, Get-PublicFolderItemStatistics can provide this information.

References:
https://social.technet.microsoft.com/Forums/en-US/81515fdf-ea69-4432-82f9-a800c41bc720/exchange-online-lastaccesstime-missing-from-getpublicfolderstatistics-cmdlet?forum=onlineservicesexchange

https://learn.microsoft.com/en-us/exchange/collaboration/public-folders/view-statistics?view=exchserver-2019

Answer 2

Hi @Kavindu Dayananda ,
According to my research and test, in Exchange 2013, public folders use a mailbox infrastructure to take advantage of the existing high availability and storage technologies of the mailbox database, we could run the following command to check the last time the public folder mailbox was accessed by the user. If there is only one public folder in this public folder mailbox, then this time is the last time the public folder is accessed. We cannot directly get the time when the public folder was last accessed.

Get-Mailbox -PublicFolder <> | Get-MailboxStatistics | fl last*  

----------

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.

Answer 3

No, there is no way to get the last access date for 2013/16/19/Exo PFs using powershell.
Get-PublicFolderItemStatistics and Get-PublicFolderStatistics only provides last modification and created date, not last access date

Get-Mailbox -PublicFolder <> | Get-MailboxStatistics | fl last*

does not provide that either

3rd party software perhaps...