SQL Queries - CAST Knowledge Base - Queries on Siebel technology - Module size for ADDED objects

Purpose of Query

This query returns the size of added object per type

Applicable CAST Version

Applicable RDBMS

Query for CSS

select T4.object_type,count(1)
from keys T1 join setroot T2 on (T2.idset = T1.idkey) join keys T3 on (T3.idkey = T2.idroot) join ctt_object_applications T4 on (T4.application_id = T2.idroot)
where T1.objtyp = 20000 and T1.keynam = 'REPOSITORY_ADDED'
and T3.keynam not like '%Siebel(Objects list)' and T4.properties = 0
group by T4.object_type order by 1

Query result example

1600008;“Siebel Display Type”;42
1600004;“Siebel”;1
1600006;“Siebel”;1
1600007;“Siebel”;1

Query result interpretation

The query returns the id of the type, the name of of the type and count of object per type

Notes/comments

Related Pages