Video Screencast Help

SQL query to be able to view list of Centera CLIP IDs

Created: 08 Jan 2013 • Updated: 15 Jan 2013 | 1 comment
This issue has been solved. See solution.


I'm looking for a way to be able to list Centera CLIP IDs if that is possible?

To give some background here, one of my clients environment comprises of EV 9.0.4 mail and journal archiving utilising Centera for storage. At some point there was an issue with syncing the data from one Centera to another and as a result data had not been replicated properly between them.

This has apparently been resolved, however EMC have requested a list of all the CLIP IDs so that they can verify that all the data has been merged and replicated properly.

I was given this link to look at and was wondering if that will do the trick:

If so, which tables would contain the relevant information?

Would that be able to list the CLIP IDs for both the journal archive and mailbox archives?

Comments 1 CommentJump to latest comment

TonySterling's picture

If you want a list of all the clip id's use the query in the Technote without the second part of the where clause, like this:

SELECT RelativeFileName 
FROM Collection, Saveset
WHERE Collection.CollectionIdentity = Saveset.CollectionIdentity

You would run it against the Mailbox and the Journal Vault Store databases.