SQL Queries - CAST Central Base - Corruptions on Objects - How to list objects computed by Quality rules but not part of module

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