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
Release | Yes/No |
---|---|
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 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