SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects in exclusion

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

This page provide the details regarding the list of Objects and corresponding metric selected for exclusion in dashboard.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS(tick)
Query for CSS, Oracle, SQL Server
SELECT DOS.object_full_name , DOE.metric_id
FROM DSS_OBJECT_EXCEPTIONS DOE
join DSS_OBJECTS DOS
on DOS.object_id = DOE.object_id
Query result example
object_full_name ; metric_id
java.wk.inter.getID;7908
Query result interpretation

The query returns the object selected for exclusion and ID of the Quality Rule for which it was Excluded

Notes/comments

Related Pages