Video Screencast Help

Get RelativeFileName from a Centera Clip-Id

Created: 10 Feb 2011 • Updated: 14 Feb 2011 | 2 comments
This issue has been solved. See solution.

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?pag..., but I'm just trying to unluckily do the opposite, get a RelativeFileName having a Clip-Id.

Any ideas? Reward is offered smiley

Thank you in advanced,

Jesus.

Comments 2 CommentsJump to latest comment

JesusWept3's picture

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>'

SOLUTION