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
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (question)
Microsoft SQL Server (question)
CSS2 (tick)
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