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?
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).
There should be some Exchange reports which can be used. Getting this information from EV is cumbersome.
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