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
Release | Yes/No |
---|---|
8.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS |
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