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

Purpose of Query

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

Applicable CAST Version

Applicable RDBMS

Query for CSS

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;

Query for Oracle

Same as above

Query for SQL server

Same as above

Notes/comments

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

select * from DSS_SNAPSHOTS;

Related Pages