SQL Queries - CAST Central Base - Queries on Objects - How to count of objects with the status deleted by snapshot

Purpose of Query

To get the count of deleted objects in the current snapshot the following query can be run on the central repository.

Applicable 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, 
       Count(1) 
FROM   dss_objects_statuses 
WHERE  object_status = 2 
GROUP  BY snapshot_id

Query result example

5;36828

Query result interpretation

In this example we have 36828 deleted objects for snapshot 5

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages