SQL Script to perform FSA item location in the File Server

Hi John,

This script should list out all the paths for items archived between two dates:

CREATE TABLE #tmp

(

Id VARCHAR(127)

)


insert into #tmp (Id)

(

  SELECT DISTINCT [ArchivePointId]

  FROM [EVVSooVSoo_1].[dbo].[Saveset]

  inner join

  [EVVSooVSoo_1].[dbo].[ArchivePoint]

  on

  [EVVSooVSoo_1].[dbo].[Saveset].ArchivePointIdentity = [EVVSooVSoo_1].[dbo].[ArchivePoint].ArchivePointIdentity

  where [EVVSooVSoo_1].[dbo].[Saveset].ArchivedDate > '2014-03-17 12:34:00.000' AND [EVVSooVSoo_1].[dbo].[Saveset].ArchivedDate < '2014-03-17 12:39:00.000'

  )



select FolderPath from #tmp as t

inner join

[EnterpriseVaultDirectory].[dbo].[ArchiveFolderView] as AFV on t.Id =  AFV.ArchiveVEID


drop table #tmp

I use the full 'path' to my vault store so that I can get acess to the vault store database and the directory from the same query.

My test Vault Store database is: 

[EVVSooVSoo_1]

Hope it helps