SQL Query for Index Folder Name and Index location on hard drive

[Scott__Hastings]

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.

[GabeV · Accepted solution]

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.

[Rob_Wilcox1]

Well you can start with:

Select * from indexrootpathentry

Or more complex:

select indexvolumeidentity, indexrootpath, foldername

from indexvolume, indexrootpathentry

where indexvolume.indexrootpathentryid = indexrootpathentry.indexrootpathentryid

[Scott__Hastings]

I'm not worthy!  :)