SQL Queries - CAST Central Base - Queries on Objects - How to check if an object is modified between two snapshots

Purpose of Query

This query check whether the object was modified between two snapshots

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Query for CSS

SELECT snp.snapshot_name,
       dob.object_full_name,
       doi.object_checksum
FROM   <Name of current central base>.dss_objects dob
       JOIN <Name of current central base>.dss_object_info doi
         ON dob.object_id = doi.object_id
       JOIN <Name of current central base>.dss_snapshots snp
         ON snp.snapshot_id = doi.snapshot_id
WHERE  snp.snapshot_name IN ( 'Name of one of the 2 snapshots',
                              'Name of the second snapshot' )
       AND dob.object_full_name = 'The full name of the object'

Query result example

"Computed on 2017"``;``""``PARTICIPATING_JEE.CUSTOMER``""``;231185933

"Computed on 2016"``;``""``PARTICIPATING_JEE.CUSTOMER``""``;0

Query result interpretation

The query returns the snapshot name, object full name and object checksum

Query for Oracle

SELECT snp.snapshot_name,
       dob.object_full_name,
       doi.object_checksum
FROM   <Name of current central base>.dss_objects dob
       JOIN <Name of current central base>.dss_object_info doi
         ON dob.object_id = doi.object_id
       JOIN <Name of current central base>.dss_snapshots snp
         ON snp.snapshot_id = doi.snapshot_id
WHERE  snp.snapshot_name IN ( 'Name of one of the 2 snapshots',
                              'Name of the second snapshot' )
       AND dob.object_full_name = 'The full name of the object'

Query result example

"Computed on 2017"``;``""``PARTICIPATING_JEE.CUSTOMER``""``;231185933
"Computed on 2016"``;``""``PARTICIPATING_JEE.CUSTOMER``""``;0

Query result interpretation

The query returns the snapshot name, object full name and object checksum

Query for SQL server

SELECT snp.snapshot_name,
       dob.object_full_name,
       doi.object_checksum
FROM   <Name of current central base>.dss_objects dob
       JOIN <Name of current central base>.dss_object_info doi
         ON dob.object_id = doi.object_id
       JOIN <Name of current central base>.dss_snapshots snp
         ON snp.snapshot_id = doi.snapshot_id
WHERE  snp.snapshot_name IN ( 'Name of one of the 2 snapshots',
                              'Name of the second snapshot' )
       AND dob.object_full_name = 'The full name of the object'

Query result example

"Computed on 2017"``;``""``PARTICIPATING_JEE.CUSTOMER``""``;231185933
"Computed on 2016"``;``""``PARTICIPATING_JEE.CUSTOMER``""``;0

Query result interpretation

The query returns the snapshot name, object full name and object checksum

Notes/comments

Related Pages