Purpose of Query
The query will result to get the computation date for a given snapshot
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
select * from <CENTRAL_NAME>.DSS_SNAPSHOTS where SNAPSHOT_ID=<ID of the given snapshot>
Query result example
2;1501;"2016-03-14 00:00:00";3;"Computed on 201603141221";"";"2016-03-14 12:24:32.979";"2016-03-14 12:24:00.306";"2016-03-14 12:25:12.098";2;0;2
2;1501;"2016-03-14 00:00:00";3;"Computed on 201603141221";"";"2016-03-14 12:24:32.979";"2016-03-14 12:24:00.306";"2016-03-14 12:25:12.098";2;0;2
The column SNAPSHOT_DATE stores the computation date.
Query result interpretation
The query will result to get the computation date for a given snapshot
Query for Oracle
Same as CSS2
Query result example
Query result interpretation
Query for SQL server
Same as CSS2
Query result example
Query result interpretation
Notes/comments
Related Pages