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.