Forum Discussion

JimmyNeutron's avatar
4 years ago

Query to collect top 100 authors from EV journal data

Hi All,

Any ideas how to gather such information? Top 100 authors of all data that is in journal archives? There is no mailbox archviing just journaling. Does SQL keep an author table that I might be able to query?

 

 

  • Hi,

    try this with Exchange Management Shell on an exchange server

    Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,TotalItemSize -First 100

     

  • Not to my knowledge. The index does and there are SDK calls that can be used to return some of this data, but that is reserved for partners (also to my knowledge).

  • Hello,

    There should be some Exchange reports which can be used. Getting this information from EV is cumbersome.