SQL Queries - CAST Central Base - Queries on Objects - How to get the number of added objects in the action plan since a particular snapshot

Purpose of Query

The query below for the CAST central base provides the number of added objects in the action plan since a particular snapshot.

Applicable CAST Version

Applicable RDBMS

Query for CSS

Snapshot_id needs to be provided below for the snapshot that will be the point of comparison for any added violations in the action plans since that snapshot.  See this page if you need help getting the snapshot_id: SQL Queries - CAST Central Base - Queries on snapshots - How to get the ID and name of a snapshot for a given application

SELECT B.count_of_snapshot_N - A.count_of_snapshot_Nplus AS Added_violations
FROM ( SELECT COUNT(1) AS count_of_snapshot_Nplus
FROM viewer_action_plans dap
JOIN dss_snapshots dsn1
ON dsn1.functional_date <= dap.sel_date
AND dsn1.snapshot_id > <snapshot_id> -- Snapshot_id
)
A ,
( SELECT COUNT(1) AS count_of_snapshot_N
FROM viewer_action_plans dap
JOIN dss_snapshots dsn1
ON dsn1.functional_date <= dap.sel_date
AND dsn1.snapshot_id = <snapshot_id> --Snapshot_id
)
B

Query result example

5

Query result interpretation

Number of added violations since snapshot_id

Notes/comments

Ticket # 31035

Related Pages