Purpose of Query
In this page you will find queries that list objects computed by quality rules but not part of module.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
SELECT dmr.metric_id, dmr.object_id, dmr.snapshot_id FROM dss_metric_results dmr LEFT JOIN dss_objects dos ON dos.object_id = dmr.metric_object_id WHERE dmr.snapshot_id = <snapshot_id> AND dos.object_id IS NULL;
Query result example
10152;783;1
Query result interpretation
The query returns the ID of the metric, the ID of the object and the ID of snapshot
Query for Oracle
SELECT dmr.metric_id, dmr.object_id, dmr.snapshot_id FROM dss_metric_results dmr JOIN dss_metric_descriptions dmd ON dmr.metric_id = dmd.metric_id LEFT JOIN dss_objects dos ON dos.object_id = dmr.metric_object_id WHERE dmr.snapshot_id = 1 AND dos.object_id IS NULL
Query result example
10152;783;1
Query result interpretation
The query returns the ID of the metric, the ID of the object and the ID of snapshot
Query for SQL server
SELECT dmr.metric_id, dmr.object_id, dmr.snapshot_id FROM dss_metric_results dmr JOIN dss_metric_descriptions dmd ON dmr.metric_id = dmd.metric_id LEFT JOIN dss_objects dos ON dos.object_id = dmr.metric_object_id WHERE dmr.snapshot_id = 1 AND dos.object_id IS NULL
Query result example
10152;783;1
Query result interpretation
The query returns the ID of the metric, the ID of the object and the ID of snapshot
Notes/comments
Related Pages