Listing C-Clips

[Rob_dos_Ramos]

HI All

Does anyone know how to get a complete C-clip list from the Enterprise Vault database? I am not a hundred percent sure where that information lives in SQL.

Taking a guess here with this one:

SELECT RelativeFileName
FROM Collection
WHERE Collection.CollectionIdentity


Regards,

Cruz

[TonySterling · Accepted solution]

are you using collections?

If yes, you are close, you dont need the where clause:
SELECT RelativeFileName
FROM Collection

If not, use this:
SELECT StoreIdentifier AS 'Centera ClipID'
FROM SavesetStore

If you want to determine the clip for a particular saveset use this method:

http://seer.entsupport.symantec.com/docs/278551.htm

[TonySterling]

Rob,

Did this get you what you needed?

Regards,

[Rob_dos_Ramos]

tony work perfectly. thanks for the scripts. Rob