How to find the date a user was enabled for archiving
Article ID: 100029804
Updated On:
Resolution
Overview:
It may be necessary to know the date a user was enabled for archiving especially if "auto-enable" is being used. To find the date, a SQL query will need to executed against the Vault Store(s).
Solution:
1. Open the Vault Administration Console, expand Archives and click Mailbox.
2. Right-click the user and click Properties.
3. Click the Advanced tab and take note of the ArchiveID.
4. Open SQL Query Analyzer.
Note: Replace VaultStoreDB with the name of the Vault Store database. Replace ArchiveID with the value from Step 3.
5. The CreatedDate column is the date the user was enabled for archiving.
Note:
It may be necessary to know the date a user was enabled for archiving especially if "auto-enable" is being used. To find the date, a SQL query will need to executed against the Vault Store(s).
Solution:
1. Open the Vault Administration Console, expand Archives and click Mailbox.
2. Right-click the user and click Properties.
3. Click the Advanced tab and take note of the ArchiveID.
4. Open SQL Query Analyzer.
Note: Replace VaultStoreDB with the name of the Vault Store database. Replace ArchiveID with the value from Step 3.
USE VaultStoreDB SELECT CreatedDate FROM ArchivePoint WHERE ArchivePointId = 'ArchiveID' 5. The CreatedDate column is the date the user was enabled for archiving.
Note:
- If an Exchange mailbox is moved between Exchange servers before disabling it in Enterprise Vault, and auto-enable is configured, a new archive will be created. If the old archive is exported to the new archive and the original is deleted, the CreatedDate for the new archive will be the most recent. Therefore, before deleting the original archive query SQL for the original archive to find out when it was originally created.
- If an archive was disabled, then reenabled, the CreatedDate will be the original date and not the date of when it was reenabled.
Issue/Introduction
How to find the date a user was enabled for archiving
Was this article helpful?
Yes
No
Powered by
