Overview
From time to time it may be required to review the folder hierarchy which is presented to an end-user with Enterprise Vault to confirm that post-migration the same folder structure is maintained. There are several ways to perform this step, as described below:
Solution 1 – Archive Explorer
From an end-user workstation which has the Enterprise Vault Outlook Add-in installed Archive Explorer can be relaunched and refreshed. The resulting folder structure can be expanded to the desired part and a screenshot taken.
Solution 2 – Database query
The following SQL query can be used to get the folder hierarchy directly out of the Enterprise Vault database:
use EnterpriseVaultDirectory SELECT A.ArchiveName "Archive", REPLACE(CAST(FolderPath AS varchar(max)),'?','\') "Folder Path", V.CreatedDate "Folder Created", COUNT(S.IdTransaction) "Item Count", SUM(S.ItemSize) "Folder Size (KB)", MIN(S.IdDateTime) "Oldest Item", MAX(S.IdDateTime) "Newest Item" FROM EnterpriseVaultDirectory.dbo.Archive A, EnterpriseVaultDirectory.dbo.ArchiveFolder AF, EnterpriseVaultDirectory.dbo.Root R1, EnterpriseVaultDirectory.dbo.Root R2, evvsvips_2.dbo.ArchivePoint AP, evvsvips_2.dbo.Vault V, evvsvips_2.dbo.Saveset S WHERE S.VaultIdentity = V.VaultIdentity AND S.ArchivePointIdentity = AP.ArchivePointIdentity AND AP.ArchivePointId = R1.VaultEntryId AND V.VaultID = R2.VaultEntryId AND R1.RootIdentity = A.RootIdentity AND R2.RootIdentity = AF.RootIdentity AND A.ArchiveName = 'daniel1' GROUP BY A.ArchiveName, REPLACE(CAST(FolderPath AS varchar(max)),'?','\'), V.CreatedDate ORDER BY "Folder Path"
Note: The vault store name (evvsvps_2 in the example above) must be changed to the vault store where the user archive resides.
Note: The A.ArchiveName parameter in the WHERE clause must be changed to the archive name applicable to the environment
Solution 3 – Folder Hierarchy .Net page
If the Vault Admin account has read permissions on the archive, the following can be used in an Internet Explorer window to generate the folder XML which is used by the Enterprise Vault Outlook Add-in when doing a Virtual Vault synchronization:
http://nameofevserver/enterprisevault/GetArchiveFolderHierarchy.aspx?archiveid=ID
Note: The Enterprise Vault server name should be used in place of ‘nameofevserver’
Note: The Archive ID for the archive should be used at the end of the query. This can be obtained from the ‘Advanced tab’ on the properties of the archive in the Vault Admin Console.
Example output:
SUCCESS” hr=”0“>
1D15BA475D5777B45876FF40DE5B116201110000rowi01-ev-01.rowiev.local” FolderName=”Top of Information Store” RetentionCategoryID=”1C3DDDEF78408D0498638C10229B7C4831b10000rowi01-ev-01.rowiev.local” IsManaged=”0” Deleted=”0” IsDeletable=”1” ExistsInMbx=”1” FolderIcon=”0“>
1B0EBD53A1B98544F8EFB11C7C6075D3E1110000rowi01-ev-01.rowiev.local” FolderName=”Inbox” IsManaged=”0” Deleted=”0” IsDeletable=”1” ExistsInMbx=”1” FolderIcon=”1“/>
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center