1. Support
  2. Knowledge base
  3. 100017154

How to determine a Centera CLIP ID associated with a Saveset in Enterprise Vault (EV)

Article: 100017154
Last Published: 2014-03-20
Ratings: 0 0
Product(s): Enterprise Vault

Problem

How to determine a Centera CLIP ID associated with a Saveset in Enterprise Vault (EV)

Solution

When troubleshooting Centera, it is often important to determine the Centera CLIP ID associated with a particular Saveset. The CLIP ID is what is used to identify an item stored on a Centera. The SQL query to use to determine the CLIP ID depends on whether Centera Collections is being used.

SQL query to determine the CLIP ID if NOT using Centera Collections:
 
(For a single saveset)

SELECT StoreIdentifier
FROM SavesetStore, Saveset
WHERE Saveset.SavesetIdentity = SavesetStore.SavesetIdentity
AND Saveset.IdTransaction = '<id transaction of saveset>'
 
 

(For multiple savesets listed in another table - example uses the dbo.Watchfile table)


SELECT StoreIdentifier
FROM SavesetStore, Saveset
WHERE Saveset.SavesetIdentity = SavesetStore.SavesetIdentity
AND Saveset.IdTransaction IN (select ArchiveTransactionID from dbo.watchfile)
 
SQL Query to determine the CLIP ID if using Centera Collections:

(For a single saveset)

SELECT RelativeFileName 
FROM Collection, Saveset
WHERE Collection.CollectionIdentity = Saveset.CollectionIdentity 
AND Saveset.IdTransaction = '<id transaction of saveset>'
 

(For multiple savesets listed in another table - example uses the dbo.Watchfile table)
SELECT RelativeFileName 
FROM Collection, Saveset
WHERE Collection.CollectionIdentity = Saveset.CollectionIdentity 
AND Saveset.IdTransaction IN (select ArchiveTransactionID from dbo.watchfile)
 
 
Perform the following steps to determine the transaction ID of a Saveset:

 
1. Find out the full Saveset ID. For example:
 
Saveset Id: 237000000000000~200307161720070000~0~10CEB2F7AF5041F196361664479FEF5
 
2. Take the last part of this Saveset ID after the last ~ e.g. 10CEB2F7AF5041F196361664479FEF5
 
3. Add hyphens (-) into this transaction id as per the example below:
 
10CEB2F7-AF50-41F1-9636-1664479FEF5
 
4. Add enough zeros to end of ID to make it a total of 32 characters e.g. 10CEB2F7-AF50-41F1-9636-1664479FEF50
 

 

 


Was this content helpful?

Article Languages