To check if the capture date was changed across snapshots the following query can be run on the central repository.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
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;
"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"
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"
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;
"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"
The query returns the traces when the capture date is changed
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;
"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"
The query returns the traces when the capture date is changed