SQL Queries - CAST Central Base - Queries on snapshots - How to get the computation date for a given snapshot

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(tick)
8.2.x(tick)
8.1.x(tick) 
8.0.x(tick) 
7.3.x(tick) 
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick) 
CSS2(tick) 
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