Get RelativeFileName from a Centera Clip-Id

[jhbermejo]

Hello,

our architechture in Enterprise Vault platform is currently using two mirrored EMC Centera as storage. EMC support has told us that the size used between both Centera is mismatched and they're sure it's because a corrupted Clip-Id that EV stored once.

We're using collections, so I'm afraid there might be a complete collection stored with corruption, and EMC has asked if we can try searching the original files or even remove them.

I've seen some SQL queries to find out Clip-Ids for a SavesetId in Symantec tech note http://www.symantec.com/business/support/index?page=content&id=TECH43224, but I'm just trying to unluckily do the opposite, get a RelativeFileName having a Clip-Id.

Any ideas? Reward is offered

Thank you in advanced,

Jesus.

[JesusWept3 · Accepted solution]

If you use Centera Collections it would be
SELECT * FROM Collections WHERE relativeFileName = '<yourClipID>'

If you're not using collections i think its
SELECT * FROM SavesetProperty WHERE relativeFileName = '<yourClipID>'

If you want the savesets themselves then it would be something like
SELECT C.CollectionIdentity, C.RelativeFileName, S.IdTransaction, S.ArchivedDate, S.ItemSize
FROM Collection C, Saveset S
WHERE C.CollectionIdentity = S.CollectionIdentity
AND C.RelativeFileName = '<yourClipID>'

[jhbermejo]

:) it worked!

Thank you man