Enterprise Vault™ Discovery Accelerator Administrator's Guide
- Introducing Discovery Accelerator
- Setting up and assigning roles
- Working with cases
- Setting up review marks and tags
- Using rules to mark and tag items automatically
- Using Custodian Manager
- Searching for items
- About searching with Discovery Accelerator
- Defining email targets with Address Manager
- Building Discovery Accelerator search schedules
- Manually reviewing items
- About reviewing with Discovery Accelerator
- Searching within the review set
- Deleting items from Enterprise Vault archives
- Working with research folders
- Exporting and producing items
- About exporting and producing items
- Creating and viewing reports
- Enhanced reporting
- Available Discovery Accelerator reports
- Accessing reports through the OData web service
- Appendix A. Enterprise Vault properties for use in Discovery Accelerator searches
- Appendix B. Troubleshooting
- Issues with Custodian Manager
Identifying the archives that contain duplicates of a specific item
When you perform an export run or production run, you can choose to exclude any duplicate items in the review set. If you want to identify all the archives that contain duplicates of a specific item, you can do so by running a SQL query against the Discovery Accelerator customer database.
To identify the archives that contain duplicates of a specific item
- On the SQL Server computer, start SQL Server Management Studio.
- In the left pane of the SQL Server Management Studio window, expand the tree until the required Discovery Accelerator customer database is visible.
- Click the customer database, and then click New Query.
- Enter the following query, and then click Execute:
Declare @ItemID nvarchar(50) Declare @ProductionID int Declare @DAID BigInt Set @ItemID = 'Export ID or Bates number of item' Set @ProductionID = ID of export or production run SELECT @DAID = DiscoveredItemID FROM tblProductionToDiscoveredItem WHERE ProductionID = @ProductionID and ExportID = @ItemID SELECT dbo.fx_GetDuplicateItemArchives(@DAID,@ProductionID) As ArchiveList
Where:
ItemID
Identifies the duplicate item. You can specify either the export ID (for an exported item) or the Bates number (for a produced item). For example:
Set @ItemID = '000622'
To determine the export ID or Bates number, check the details of the item in the export or production report.
ProductionID
Identifies the export or production run that contains the duplicate item. For example:
Set @ProductionID = 57
To determine the ID of the export or production run, look at the summary information in the export or production report.
The query returns a list of the archives that contain duplicates of the specified item.