How to obtain the index volume search details in Enterprise Vault (EV) Compliance Accelerator (CA) and Discovery Accelerator (DA) for review outside of CA / DA.

book

Article ID: 100022445

calendar_today

Updated On:

Cause

Enterprise Vault (EV) Compliance Accelerator (CA) and Discovery Accelerator (DA) provide information about each index volume searched in each search's Archives section under the search listing in the CA / DA  Client.  In order to review this information outside of CA or DA, this information must be copied to a file such as a Microsoft Excel spreadsheet.
 

Resolution

 
1) Obtain the SearchID of the search whose index volume Info column data is needed
- hover the mouse over the search name to see a pop-up displayed with the SearchID and the CaseID
2) Open the SQL Server Management Studio console
3) Expand the Databases in the left panel
4) Right click on the CA / DA Customer database
5) Select the New Query option
6) Execute the following SQL Query, selecting the output option to save to a file or to the screen as needed
 
a) For any non-accepted search : 
 
SELECT   tc.Name AS 'Case Name'
      , tsv.SearchID AS 'Search ID'
      , tis.Name AS 'Search Name'
      , tv.KVSVaultName AS 'Archive'
      , tv.VaultID AS 'Volume'
      , tvs.Name AS 'Vault Store'
      , ts.Name AS 'Status'
      , tsv.StartDate AS 'Started'
      , tsv.EndDate AS 'Ended'
      , tsv.NumHits AS 'Hits'
      , tsv.Info AS 'Info'
FROM tblSearchVault AS tsv
INNER JOIN tblStatus AS ts ON tsv.StatusID = ts.StatusID
INNER JOIN tblVaults AS tv ON tsv.VaultID = tv.VaultID
INNER JOIN tblVaultStore AS tvs ON tv.VaultStoreID = tvs.VaultStoreID
INNER JOIN tblIntSearches AS tis ON tsv.SearchID = tis.SearchID
INNER JOIN tblCase AS tc ON tis.CaseID = tc.CaseID
WHERE tsv.Info IS NOT NULL
 AND tsv.SearchID = XXX   -- replace XXX with the SearchID of the search
 
b) For any accepted search :    change the initial table from tblSearchVault to tblSearchVaultsArchived as follows:
 
SELECT   tc.Name AS 'Case Name'
      , tsva.SearchID AS 'Search ID'
      , tis.Name AS 'Search Name'
      , tv.KVSVaultName AS 'Archive'
      , tv.VaultID AS 'Volume'
      , tvs.Name AS 'Vault Store'
      , ts.Name AS 'Status'
      , tsva.StartDate AS 'Started'
      , tsva.EndDate AS 'Ended'
      , tsva.NumHits AS 'Hits'
      , tsva.Info AS 'Info'
FROM tblSearchVaultsArchived AS tsva
INNER JOIN tblStatus AS t ON tsva.StatusID = ts.StatusID
INNER JOIN tblVaults AS tv ON tsva.VaultID = tv.VaultID
INNER JOIN tblVaultStore AS tvs ON tv.VaultStoreID = tvs.VaultStoreID
INNER JOIN tblIntSearches AS tis ON tsva.SearchID = tis.SearchID
INNER JOIN tblCase AS tc ON tis.CaseID = tc.CaseID
WHERE tsva.Info IS NOT NULL
 AND tsva.SearchID = XXX   -- replace XXX with the SearchID of the search
 
7) If the SQL Query output is saved to a file, open that file in the application of choice
8) If the SQL Query output is sent to the screen, highlight the output, copy it into the Clipboard, then paste it into an appropriate file
9) Close the SQL Server Management Studio and log off of the SQL Server as appropriate.

Notes:
 
1) Any column that is not desired in the output can be commented out by starting its row with 2 dashes ( i.e., '-- tis.Name AS 'Search Name'' would comment out that line and not return the search name).  Exception: if the Case Name is not to be included in the output, put the 2 dashes in front of the tc.Name identifier and remove the comma from the next line to allow the tsv.SearchID to be the first argument.
 
2) Typical Info column information is
a) Date Range Exclusion - no items in the index volume are within the date span of the search.  This will only display if the Optimize searches based on oldest and youngest items option has been enabled in the Searches configuration settings.
 
b) Index and archive out of sync - the index volume is actively being updated by the EV Indexing Service at the time the search attempted to search the index volume, rerunning the search at a later time will likely allow access to the index volume so it can be searched.
 
c)   Some items could not be searched , or Items or content missing from the index - the index volume has at least 1 item that failed to be indexed.  Run the 'nudge' process or the 'Repair Index Volume' option against the specific Index Volume.  See Related Articles below for additional information.
 
d) Search request failed.  Reason: %1 Index ID: %2 Requestor: %3 Search Query: %4 Search Arguments: %5 [0xc0041c67] - indicates the index volume may have been marked as failed do to the CA / DA search.  See Related Articles below for additional information.
 
e) The search could not be performed due to the index not being searchable.  Index state: Failed (or Rebuilding) - The index volume has been marked as failed and is no longer searchable until the issue is corrected, or the index volume is currently being rebuilt or updated.  See Related Articles below for additional information.
 
 

 

Issue/Introduction

How to obtain the index volume search details in Enterprise Vault (EV) Compliance Accelerator (CA) and Discovery Accelerator (DA) for review outside of CA / DA.
Powered by Wolken Software