SQL Queries - CAST Central Base - Queries on snapshots - How to check if the capture date was changed across snapshots

Purpose of Query

To check if the capture date was changed across snapshots the following query can be run on the central repository.

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 dh.action_date, 
       dh.description 
FROM   dss_history dh 
WHERE  dh.description LIKE '%DSS_UPD_FunctionalDate%' 
ORDER  BY dh.action_date, 
          dh.history_id;

Query result example

“2018-07-09 12:09:45.649”;“Start DSS_UPD_FunctionalDate for snapshot 2”
“2018-07-09 12:09:45.725”;“DSS_UPD_FunctionalDate: Remove Violation Statuses in snapshot 2”
“2018-07-09 12:09:45.742”;“DSS_UPD_FunctionalDate: Remove Violation Statuses in snapshot 1”
“2018-07-09 12:09:45.748”;“DSS_UPD_FunctionalDate: Compute Violation Statuses from snapshot 3 to snapshot 1”
“2018-07-09 12:09:56.338”;“End DSS_UPD_FunctionalDate”

Query result interpretation

The query returns the traces when the capture date is changed, in the example above the capture date of snapshot 2 was changed, we can see that the change started at “2018-07-09 12:09:45.649” and ended at “2018-07-09 12:09:56.338”

Query for Oracle

SELECT dh.action_date, 
       dh.description 
FROM   dss_history dh 
WHERE  dh.description LIKE '%DSS_UPD_FunctionalDate%' 
ORDER  BY dh.action_date, 
          dh.history_id;

Query result example

Query result interpretation

The query returns the traces when the capture date is changed

Query for SQL Server

SELECT dh.action_date, 
       dh.description 
FROM   dss_history dh 
WHERE  dh.description LIKE '%DSS_UPD_FunctionalDate%' 
ORDER  BY dh.action_date, 
          dh.history_id;

Query result example

Query result interpretation

The query returns the traces when the capture date is changed

Notes/comments

Related Pages