I have a couple of requests for assistance:
1. I have a complex FSA deployment, in so much that I have 4 File Servers each with 2 volume targets, and the Archive Points below them. Is there a query or method for me to get a list of paths from SQL or EV saying that each archive points UNC path is XYZ?
In so much that if I have:
File server 1 --> Volume A --> "Folder B" and "Folder C" Folder B is an Archive point, but Folder C is also an Archive Point and auto enables all of its sub folders. So below Folder C I have folders D-Z each as an AP.
2. More a Discovery Accelerator question.... If I am using DA to search my File System data, and using the example of FSA layout above, if I seach a higher level folder, would DA drill down in to the child Archive Points as well, or does it only do the top layer?
Thanks guys, I am a long time follower of these forums!
Looked interesting so I
Looked interesting so I thought I would have a stab as well :)
The below is the rather nasty query i came up with, but it wont work for root folders (yet). The problem is that there is a folder which basically links all archives on a volume to all folders on a volume so you end up with a matrix of results which you need to prune or you end up with lots of results. I've tried to do that by calculating the path and comparing that with the root path - if you have renamed your archives this will not work fully.
--start of script--
select AF.FolderPath ,AF.FolderName, A.ArchiveName, FSE.DnsName, FSVE.VolumeName,
FSFE.FolderPath, '\\' + FSE.DnsName + '\' + FSVE.VolumeName + '\' + FSFE.FolderPath 'Path', A.ArchiveName, * from FileServerFolderEntry FSFE
--select * from FileServerFolderEntry fsfe
inner join FileServerVolumeEntry FSVE on FSFE.VolumeEntryID = FSVE.VolumeEntryID
INNER JOIN FileServerVolumeArchiveEntry FSVAE on FSVAE.VolumeEntryId = FSVE.VolumeEntryId
INNER JOIN FileServerEntry FSE on FSE.FileServerEntryId = FSVE.FileServerEntryId
INNER JOIN [Root] R on R.VaultEntryId = FSVAE.ArchiveVEID
INNER JOIN Archive A on A.RootIdentity = R.RootIdentity
INNER JOIN [Root] R2 on R2.ContainerRootIdentity = R.RootIdentity
INNER JOIN ArchiveFolder AF on AF.RootIdentity = R2.RootIdentity
where AF.ParentFolderRootIdentity is null
and ((cast(AF.FolderPath as varchar(255)) = '\\' + FSE.DnsName + '\' + FSVE.VolumeName + '\' + FSFE.FolderPath + '\' + A.ArchiveName)
OR ((cast(AF.FolderPath as varchar(255))) = '\\' +FSE.DnsName + '\' + FSVE.VolumeName + '\' + FSFE.FolderPath))
--end of script--