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

To retrieve the list of transaction for a snapshot.

 This query on the central will provide a list of transactions ( replace <snapshot_id> with appropriate snapshot_id). The below query will provide the list of ALL transactions (empty+non-empty)

Select * from dss_object_info where snapshot_id= <snapshot_id> and object_type_id=30002;

To get the list of all non-empty transactions, please execute the below query:

Select object_id 
from dss_object_info doi
join dss_link_info dli
 on doi.snapshot_id = dli.snapshot_id
 and dli.link_type_id = 11004
 and dli.previous_object_id = doi.object_id
where doi.snapshot_id= <snapshot_id> 
and object_type_id=30002

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

select * from dss_snapshots