SQL query to find the index volume corresponding to index volume ID

[laguns97]

Hi !

In Discovery Accelerator, some time we have some search with error "index State: Failed".  I have the Index Volume ID, by example, 68.

There is a SQL query, I can run to know which index volume is corresponding to the index volume ID ?

Thanks !

[Switch]

Update your EVDIrectory database name and provide the Index Volume ID to get Index location info.

USE [EnterpriseVaultDirectory]
SELECT CE.ComputerNameAlternate As [EV Server],A.archivename AS [Archive Name],
IV.IndexVolumeIdentity AS [Index Volume],
IV.IndexedItems AS [Indexed Items],IV.FailedItems AS [Failed Items],
IRPE.indexrootpath AS [Index Path],IV.foldername AS [Folder Name],
OldestItemDateUTC,YoungestItemDateUTC
FROM IndexVolume IV
JOIN indexrootpathentry IRPE ON IV.indexrootpathentryid = IRPE.indexrootpathentryid
JOIN archive A ON IV.rootidentity = A.rootidentity
JOIN indexingserviceentry ISE ON IRPE.IndexServiceEntryId = ISE.ServiceEntryId
JOIN Computerentry CE ON ISE.ComputerEntryId = CE.ComputerEntryId
WHERE IV.IndexVolumeIdentity = '<Index Volume No>'