SQL Queries - CAST Central Base - Queries on snapshots - How to get the ID and name of a snapshot for a given application

Purpose of Query

This query will help you to find the ID and name of a snapshot for a given application. You can get application id from the CB by referring to  SQL Queries - CAST Central Base - Queries on applications - How to get the ID of the application, then go to the next step

Applicable in CAST Version

ReleaseYes/No
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 snapshot_id, 
       snapshot_name 
FROM   dss_snapshots 
WHERE  application_id = "id retrieved from point 1" 
ORDER  BY 1

Query result example

SNAPSHOT_ID;SNAPSHOT_NAME

1;Snapshot1

2;Snapshot2

Query result interpretation

This query will get you the Snapshot name and its corresponding ID.

Query for Oracle

SELECT snapshot_id, 
       snapshot_name 
FROM   dss_snapshots 
WHERE  application_id = "id retrieved from point 1" 
ORDER  BY 1

Query result example

SNAPSHOT_ID;SNAPSHOT_NAME

1;Snapshot1

2;Snapshot2

Query result interpretation

This query will get you the Snapshot name and its corresponding ID.

Query for SQL server

SELECT snapshot_id, 
       snapshot_name 
FROM   dss_snapshots 
WHERE  application_id = "id retrieved from point 1" 
ORDER  BY 1

Query result example

SNAPSHOT_ID;SNAPSHOT_NAME

1;Snapshot1

2;Snapshot2

Query result interpretation

This query will get you the Snapshot name and its corresponding ID.

Notes/comments

Related Pages