List all shares that are archived or have been archived by Enterprise Vault

You can use the following SQL query if you need an entire list of shares that have been archived by Enterprise Vault File System Archiving:

USE EnterpriseVaultDirectory;
SELECT distinct SUBSTRING(FolderPath, CHARINDEX(‘\’,FolderPath,4),abs((CHARINDEX(‘\’,FolderPath,22)-CHARINDEX(‘\’,FolderPath,4))))
FROM ArchiveFolder
WHERE not ParentFolderRootIdentity is NULL
AND FolderPath like ‘%servername%';

If your fileservername’s FQDN exceeds 22 characters, please justify the value so the correct “\” is searched.

Leave a Reply