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