Report of all mailboxes in organization not enabled for EV

[karmakoma]

Hello,

Is there a report available or a table I can query which will give me a list of all mailboxes in my organization which have not been enabled for Enterprise Vault?

Thanks!

[Rob_Wilcox1]

Do you have all your users targeted by a provisioning group?  If so then you can do some SQL queries against the ExchangeMailboxEntry table if wanted to find out this information.

[Wayne_Humphrey · Accepted solution]

Hi karmakoma,

Here is a SQL query I wrote for you, that should do all you need. It should be in the downloads section soon.

https://www-secure.symantec.com/connect/downloads/get-all-list-all-none-enabled-mailboxes-and-all-relevant-information

-----------------------------------------------------------------
--
-- Author: Wayne Humphrey
-- Date: 29th July 2009
--
------------- Notes -------------
--
-- Get all List of all None Enabled Mailboxs and display the following:
--
-- Mailbox
-- Mailbox Over Quotas (if using exchnage quotas)
-- Mailbox Size (MB)
-- Number of Items (Mailbox)
-- Exchange Server
--
-----------------------------------------------------------------

Use EnterpriseVaultDirectory

SELECT left(MbxDisplayName,20) as 'Mailbox',
MBxSize/1000 - MbxSendLimit/1000 as 'Over Send (MB)',
MbxWarningLimit/1000 as 'Warning (MB)',
MbxSendLimit/1000 as 'Send (MB)',
MbxReceiveLimit as 'Receive (MB)',
MbxSize/1000 as 'Mbx Size (MB)',
MbxItemCount as '#Items (Mailbox)',
left(ExchangeComputer,17)as 'Exchange Server',
MbxExchangeState as 'Exchange State'

FROM
EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry as EME,
EnterpriseVaultDirectory.dbo.ExchangeServerEntry as ESE

WHERE
EME.MbxArchivingState = 0 AND
EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity
ORDER by EME.MBxSize desc

If you are using quotas please chnage the WHERE to

WHERE
WME.MBxSendLimit > 0 AND
EME.MbxArchivingState = 0 AND
EME.MBxSize > EME.MbxSendLimit AND
EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity
ORDER by EME.MBxSize - EME.MbxSendLimit desc

--wayne
 

[karmakoma]

Thank you so much! Saved me hours of work.

[Wayne_Humphrey]

my plesure :)