Does enyone have any SQL queries ? looking for two to do the following:-
1. List number of mailboxes enabled for archiving.
2. List all mailboxes that are enabled for archiving with a archive of less that 50MB.
Solved! Go to Solution.
List all those enabled for Archiving
USE EnterpriseVaultDirectory SELECT MbxDisplayName "Mailbox Name" FROM ExchangeMailboxEntry WHERE MbxArchivingState =1 AND DefaultVaultID IS NOT NULL
List Archives enabled and under 50mb
SELECT EME.MbxDisplayName "Mailbox Name", AP.ArchivedItemsSize/1024 "Archive Size (MB)" FROM EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME, yourVaultStore.dbo.ArchivePoint AP WHERE AP.ArchivePointId = EME.DefaultVaultId AND EME.MbxArchivingState = 1 AND AP.ArchivedItemsSize < 51200
For the above you will need to run that for each vault store, replaced yourVaultStore.dbo, with the physical database name for your Vault Store database
That is what the first query does. If a mailbox archiving state is 1 that means it is enabled.
Do you mean you just want a count?
Msg 208, Level 16, State 1, Line 1
Invalid object name 'VaultStoreEntry.dbo.ArchivePoint'.
On second script - also want to modify script to say if mailboxis enabled for archiving and size is 50MB or less then set MbxArchivingstate=2 in other words disable archiving for all mailboxes of 50mb or less