Highlighted

Get RelativeFileName from a Centera Clip-Id

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 smiley

Thank you in advanced,

Jesus.

1 Solution

Accepted Solutions
Accepted Solution!

If you use Centera

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

https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

2 Replies
Accepted Solution!

If you use Centera

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

https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

:) it worked! Thank you man

Smiley Happy it worked!

Thank you man