Purpose of Query
This query check whether the object was modified between two snapshots
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/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