SQL Queries - CAST Central Base - SQL Queries on Transactions - How to retrieve the list of transactions

 The purpose of the query is to retrieve the list of transactions stored in the Central database.

This query on the central will provide a list of transactions - need to provide appropriate snapshot_id:

select * from DSS_OBJECT_INFO where SNAPSHOT_ID = <snapshot_id> and OBJECT_TYPE_ID =30002;

 Same as above 

 Same as above 

The appropriate snapshot_id can be obtained by running on the central the query: 

select * from DSS_SNAPSHOTS;