Video Screencast Help
Archiving and eDiscovery Community Blog

How to discover the Saveset ID from the Item ID in Discovery Accelerator

Created: 23 Jun 2009 • Updated: 29 May 2014
Liam Finn's picture
0 0 Votes
Login to vote

Using Discovery Accelerator you find an item that is failing to export using the export or production features in Discovery Accelerator

So now you need to prove the item exists in the archive.

There are two ways to do this
1. Search in EV and dig through mounts of results to fine the one item
2. Find the item Saveset ID and then search in EV by Saveset



Option one make little sense as the search will be fast but unless your search is very, very targetted chances are you will get back hundreds if not thousands of results which will take you hours to look through to find the one item you need

Option two is the easier way to go as it will get you the saveset and then you just search for the saveset or in the case of a Centera you can extract the saveset direct from the Centera device. (see https://www-secure.symantec.com/connect/blogs/how-find-clip-id-saveset)

/* Run this query against the Discovery Accelerator database to find the saveset id. Note: The discovereditemid is
found in Review Items for the case */
select kvssavesetid
from tblintdiscovereditems
where discovereditemid = '10624077'