SQL Queries - CAST Central Base - SQL Queries on snapshots

Purpose

This page lists the sql queries on snapshots.

Details

  1. Select the page you are interested with:
  2. If you do not find the information you are looking for or solution for your problem, please contact CAST Technical Support

Notes / Comments

Related Pages


SQL Queries - CAST Central Base - Queries on snapshots - How to check the status of a snapshot

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

SQL Queries - CAST Central Base - Queries on snapshots - How to get the number of SQL tables for a given snapshot

SQL Queries - CAST Central Base - Queries on snapshots - How to change the label of the snapshot using UPDATE query

SQL Queries - CAST Central Base - Queries on snapshots - How to get the list of source file objects that belong to a snapshot

SQL Queries - CAST Central Base - Queries on snapshots - How to get the list of source file objects that does not belong to a snapshot

SQL Queries - CAST Central Base - Queries on snapshots - How to identify all the objects invoved in AFP modification for specific snapshot and for all applications

SQL Queries - CAST Central Base - Queries on snapshots - How to manually populate DSS_VIOLATION_STATUSES table for a given snapshot

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

SQL Queries - CAST Central Base - Queries on snapshots - How to check which quality rules have been ADDED and DELETED between two snapshots

SQL Queries - CAST Central Base - Queries on snapshots - How to get the duration of a snapshot

SQL Queries - CAST Central Base - Queries on snapshots - How to check if the capture date was changed across snapshots

SQL Queries - CAST Central Base - Queries on snapshots - How to get the history of creation and deletion of snapshots

SQL Queries - CAST Central Base - Queries on snapshots - How to get the list of different files between 2 snapshots

SQL Queries - CAST Central Base - Queries on snapshots - How to get the variation between two snapshots for TQI and LOC

SQL Queries - CAST Central Base - Queries on snapshots - How to find out the time consumed by stored procedure

SQL Queries - CAST Central Base - Queries on snapshots - How to update the snapshot name and snapshot version