Generating CLIP ID List

[jasonwelch01]

Hello,

Does anyone know the proper sql commands to generate list of CLIP IDs?  We're running EV9.0.1 w/ SQL 2k5 SP2 back-end

If CLIP ID lists are generated via SQL queries and points to each VaultStore database, does the query syntax change whether or not 'Collections' are enabled for that vault store?

Thanks in advance

[JesusWept3 · Accepted solution]

its either

When using Collections
USE vaultStoreDBName
SELECT RelativeFileName FROM Collection

When Not Using Collections
USE VaultStoreDBName
SELECT StoreIdentifier FROM SavesetStore

[TonySterling]

edited==> What JW2 said.  :)

For collections use:

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:

Article URL http://www.symantec.com/docs/TECH43224

[jasonwelch01]

this is great, thanks guys