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:
<?xml version=”1.0″ encoding=”UTF-8″?>
<MDCSyncResponse msg=”SUCCESS” hr=”0“>
<GetArchiveFolderHierarchyResponse>
<Folders>
<Folder VaultEntryId=”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“>
<Folder VaultEntryId=”1B0EBD53A1B98544F8EFB11C7C6075D3E1110000rowi01-ev-01.rowiev.local” FolderName=”Inbox” IsManaged=”0” Deleted=”0” IsDeletable=”1” ExistsInMbx=”1” FolderIcon=”1“/></Folder>
</Folders>
</GetArchiveFolderHierarchyResponse>
</MDCSyncResponse>

Print Friendly, PDF & Email