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

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
 

 

 


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)