Data Protection - How to query available Centera clip ID list data.

Document ID : KB000045235
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction: 

CA DataMinder can integrate with EMC Corporation's Centera content addressed storage (CAS) solution to ensure long-term content integrity and online access for large volumes of fixed data. Integration between these two systems provides your enterprise with an end-to-end solution to your email and Web risk management and storage needs.

 

Question: 

Is there a way to extract data from the Data Protection (DataMinder) CMS database that can be used to to identify Centera clip ids?

 

Answer: 

The following SQL query can be used to retrieve the required information.

 

select BlobLocation from Wgn3Event where BlobType=2

 

Additional Information:

CA DLP and DataMinder are previous brand names for the product now known as CA Data Protection.