Generating CLIP ID List
Updated: 23 May 2011 | 3 comments
This issue has been solved. See solution.
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
Discussion Filed Under:
Comments
its either When using
its either
When using Collections
USE vaultStoreDBName
SELECT RelativeFileName FROM Collection
When Not Using Collections
USE VaultStoreDBName
SELECT StoreIdentifier FROM SavesetStore
For collections use: SELECT
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
Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK
this is great, thanks guys
this is great, thanks guys
Would you like to reply?
Login or Register to post your comment.