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

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/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