cancel
Showing results for 
Search instead for 
Did you mean: 

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?

 

 

3 Replies

Re: Query to collect top 100 authors from EV journal data

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).

Re: Query to collect top 100 authors from EV journal data

Hello,

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

 

Regards. Gertjan

Re: Query to collect top 100 authors from EV journal data

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