Purpose of Query
This query returns the size of added object per type
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS4 | |
CSS3 | |
CSS2 |
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
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