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

Purpose of Query

To get the count of added 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 = 1 
GROUP  BY snapshot_id

Query result example

1;6699

Query result interpretation

In this example we have 6699 added objects for snapshot 1

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