Forum Discussion

laguns97's avatar
laguns97
Level 4
7 years ago

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

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 !

 

1 Reply

  • Switch's avatar
    Switch
    Level 3
    7 years ago

    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>'