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
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/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