Highlighted

Looking for SQL query to get message count and mailbox size

Hello,

Does anyone have an SQL query to get a list of archives, message count, and total user archive size?

Thanks

Labels (1)
0 Kudos
3 Replies
tlarsen1
1 Copper

Re: Looking for SQL query to get message count and mailbox size

It is some rather complicated queries which are needed to obtain those data. You could use the sourceone reporting pack for it. That would be the easiest way to get it.

It is part of the base license

Regards

Thomas

0 Kudos
Kejia1
1 Copper

Re: Looking for SQL query to get message count and mailbox size

SourceOne Reporting is the best way to go.

You can refer to SourceOne Admin Guide and Installation Guide for more information.

0 Kudos
boxter1
1 Copper

Re: Looking for SQL query to get message count and mailbox size

Hi Wilson,

Were you able to find the SQL query?

Could you please share, because I am also looking for the same information.

Cheers!

B

0 Kudos