This page provides queries to list customization's in CAST Central Base.

Detection's by querying the Central repository

Productivity Metrics in ADG Admin

Detection: Productivity Metrics's presence

select o.OBJECT_NAME, t.METRIC_NAME
from DSS_OBJECTS o, DSS_METRIC_TYPES t, DSS_METRIC_TYPE_TREES tt
where tt.METRIC_PARENT_ID = 66000
and t.METRIC_ID = tt.METRIC_ID
and o.OBJECT_TYPE_ID = 20000
and exists (select 1 from DSS_METRIC_RESULTS r
where r.OBJECT_ID = o.OBJECT_ID
and r.METRIC_ID = t.METRIC_ID)

Integrated on 3C

Business Value in ADG Admin

Detection: Business Value's presence

select o.OBJECT_NAME, t.METRIC_NAME
from DSS_OBJECTS o, DSS_METRIC_TYPES t
where t.METRIC_ID = 66061
and o.OBJECT_TYPE_ID = 20000
and exists (select 1 from DSS_METRIC_RESULTS r
where r.OBJECT_ID = o.OBJECT_ID
and r.METRIC_ID = t.METRIC_ID)

Integrated on 3C

Adding metric where its id is outside the R&D range in Metric Tree

Detection: Presence of new metrics 

select * from DSS_METRIC_TYPES where METRIC_ID > 1000000

Integrated on 3C

Deactivated metrics

Detection: Presence of deactivated metrics

select * from DSS_METRIC_TYPES where METRIC_TYPE = 0

Integrated on 3C

Objects in exception

Detection: Presence of objects in exception

select o.OBJECT_ID, t.OBJECT_TYPE_NAME, o.OBJECT_NAME, m.METRIC_ID, m.METRIC_NAME
from DSS_METRIC_EXCEPTIONS e, DSS_OBJECTS o, DSS_OBJECT_TYPES t, DSS_METRIC_TYPES m
where o.OBJECT_ID = e.OBJECT_ID
and t.OBJECT_TYPE_ID = o.OBJECT_TYPE_ID
and m.METRIC_ID = e.METRIC_ID

Integrated on 3C

Non administrator users and their associated roles in ADG Dashboard

Detection: Presence of non administrator users and their roles

select u.NAME, r.NAME
from VIEWER_USERS u, VIEWER_USER_ROLES ur, VIEWER_ROLES r
where u.ADMINISTRATOR = 0
and ur.USER_ID = u.ID
and ur.ROLE_ID = r.ID

Integrated on 3C

Metric translation in ADG Dashboard

Detection: Presence of translation in metrics

select d1.LANGUAGE, count( * ) from DSS_METRIC_DESCRIPTIONS d1
where d1.LANGUAGE != 'ENGLISH'
and not exists (select 1 from DSS_METRIC_DESCRIPTIONS d2
where d2.METRIC_ID = d1.METRIC_ID
and d2.DESCRIPTION_TYPE_ID = d1.DESCRIPTION_TYPE_ID
and d2.METRIC_DESCRIPTION = d1.METRIC_DESCRIPTION
and d2.LANGUAGE = 'ENGLISH')
group by d1.LANGUAGE

Integrated on 3C

Dashboard label translation (Discovery portal is translated < 130 labels)

Detection: Presence of translation in labels

select l.ID as LANGUAGE, count( * ) from VIEWER_PARAMETERS p, VIEWER_LANGUAGES l
where l.ID != 'ENGLISH'
and p.COMPONENT_ID = l.ID
group by l.ID
having count( * ) > 130

Integrated on 3C

Detections by comparing the Central repository with a standard CAST Central repository

Adding/deleting metric where its id is in the R&D range in Metric Tree

Detection: Creation and/or deletion of CAST metrics 

Compare content of table DSS_METRIC_TYPES with an official version

Integrated on 3C

Modifying Aggregate Weight and critical contribution

Detection: Modification of metrics's Aggregate Weight and critical contribution

select TT.METRIC_ID, TT.AGGREGATE_WEIGHT, TT.METRIC_CRITICAL, TT.METRIC_PARENT_ID, T.METRIC_NAME
from DSS_METRIC_TYPE_TREES TT,
 DSS_METRIC_TYPES T
where  TT.METRIC_ID = T.METRIC_ID  + 1
order by METRIC_ID  , METRIC_PARENT_ID

Integrated on 3C

Creating new parameters

Detection: New parameters 

Integrated on 3C

Adding, deleting and modifying parameters values

Detection: Creation/deletion/Modification of parameters values
select  T.METRIC_ID          as 'METRIC ID',
        T.METRIC_NAME        as 'Metric Name',
        MTP.PARAM_NUM_VALUE  as 'Parameter Numeric Value',
        MTP.PARAM_CHAR_VALUE as 'Parameter char Value'
 from DSS_METRIC_TYPE_TREES TT join DSS_METRIC_TYPES T
                                 on (TT.METRIC_ID = T.METRIC_ID  + 1)
                    left outer join DSS_METRIC_PARAM_VALUES MTP
                                 on ( MTP.METRIC_ID = T.METRIC_ID  + 1 )
where  T.METRIC_GROUP = 1
order by METRIC_NAME

Integrated on 3C 

Adding, Creating and modifying indexes

Detection: Creation/deletion/Modification of indexes

Integrated on 3C

Adding new pages in ADG Dashboard

Detection: New pages's presence

Compare content of table VIEWER_FRAMES with an official version

Integrated on 3C

Modifying thresholds in ADG Dashboard

Detection: Modification of the metrics' thresolds

Compare content of table DSS_METRIC_ShTATUS_THRESHOLDS with a standard CAST Central repository.

Integrated on 3C 

Oracle rights and privileges

Detection: Oracle rights and privileges other than the CAST recommandations.  

Run the following queries RDBMS Information - Oracle - Getting roles and privileges for an Oracle user

Compare the results with the same queries run on a standard CAST Central repository.

Packages

Detection: Presence of packages other than CAST's

select * from <CB_NAME>.SYS_PACKAGE_VERSION 

Compare the results with the same queries run on a standard CAST Central base.