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


Release
Yes/No
8.3.x (tick) 
8.2.x (tick) 
8.1.x (tick) 
8.0.x (tick) 
Applicable RDBMS

 

RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (tick) 
CSS2 (tick) 


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