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.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
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