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β/>
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center