08-16-2013 12:59 PM
I am trying to ensure that an index folder, like 1783BC262A0BE2E48A68E8440FCFA2EC31110000vaultsite_234698801 is located on the correct drive/folder on a drive the server.
Any help appreciated.
Solved! Go to Solution.
08-16-2013 01:14 PM
Hi Scott,
Try this query
SELECT IndexRootPathEntry.IndexRootPath, IndexVolume.FolderName FROM IndexRootPathEntry INNER JOIN IndexVolume ON IndexRootPathEntry.IndexRootPathEntryId = IndexVolume.IndexRootPathEntryId WHERE (IndexVolume.FolderName = '[Index-folder]')
Just replace [Index-folder] and should give you the index location (drive:\full-path). Let me know if this is what you are looking for.
08-16-2013 01:14 PM
Hi Scott,
Try this query
SELECT IndexRootPathEntry.IndexRootPath, IndexVolume.FolderName FROM IndexRootPathEntry INNER JOIN IndexVolume ON IndexRootPathEntry.IndexRootPathEntryId = IndexVolume.IndexRootPathEntryId WHERE (IndexVolume.FolderName = '[Index-folder]')
Just replace [Index-folder] and should give you the index location (drive:\full-path). Let me know if this is what you are looking for.
08-16-2013 01:17 PM
Well you can start with:
Select * from indexrootpathentry
Or more complex:
select indexvolumeidentity, indexrootpath, foldername
from indexvolume, indexrootpathentry
where indexvolume.indexrootpathentryid = indexrootpathentry.indexrootpathentryid
08-16-2013 01:19 PM
I'm not worthy! :)