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 (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 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

"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

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

"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

Notes/comments
 

 

Related Pages