SQL query to be able to view list of Centera CLIP IDs
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?
Comments 1 Comment • Jump to latest comment
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.
Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK
Would you like to reply?
Login or Register to post your comment.