cancel
Showing results for 
Search instead for 
Did you mean: 

Query to collect top 100 authors from EV journal data

JimmyNeutron
Level 6
Partner Accredited

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 3

Prone2Typos
Moderator
Moderator
Partner    VIP    Accredited Certified

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

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

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

 

Regards. Gertjan

CConsult
Moderator
Moderator
Partner    VIP   

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