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

[AlanJ]

Hello

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:

http://www.symantec.com/business/support/index?page=content&id=TECH43224

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?

[TonySterling · Accepted solution]

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.