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



Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)




RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick) 
CSS2(tick) 



 

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


SNAPSHOT_ID;SNAPSHOT_NAME
1;Snapshot1
2;Snapshot2


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




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


 SNAPSHOT_ID;SNAPSHOT_NAME
1;Snapshot1
2;Snapshot2


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




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


 SNAPSHOT_ID;SNAPSHOT_NAME
1;Snapshot1
2;Snapshot2


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