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

Purpose of Query

This query returns the size of modified 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_MODIFIED'
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 Subset”;1
1600006;“Siebel Environment”;1
1600007;“Siebel Module”;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