SQL Queries - CAST Central Base - Queries on Objects - How to count the objects per 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.3.x✅
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, SQL Server, Oracle

select SNAPSHOT_ID,
       count(distinct OBJECT_ID)
  from DSS_OBJECT_INFO
group by SNASPHOT_ID
order by SNASPHOT_ID;

Query result example

1;22010
2;22020

Query result interpretation

In this example, there are 22010 objects for snapshot 1 and 22020 objects for snapshot 2.

Notes/comments

Related Pages