SQL Queries - CAST Knowledge Base - Queries on objects - How to get the type of objects counted in CMS

Purpose of Query

To find out the types of objects counted in CMS (View analysis unit content).

Applicable CAST Version

Release	Yes/No
8.3.x	✅
8.2.x	✅

Observed on RDBMS

RDBMS	Yes/No
Oracle Server	✅
Microsoft SQL Server	✅
CSS	✅

Query for CSS

SELECT t.*
FROM   Typ t    ,
       TypCat tc,
       Cat c
WHERE  t.IdTyp        = tc.IdTyp
AND    tc.IdCatParent = c.IdCat
AND    c.IdCat        = 6100

Query result example

Query gives the following result:

	idtyp integer	typname character varying (255)	typ dsc character varying (255)	statuts character (10)
1	1	SQL Table	SQL Table	ACTIVE
2	141260	CAST_TSQL_UDT_TABLE	SQL Server UDT TABLE	ACTIVE
3	141449	CAST_ABAP_SAPUnresolvedTable	SAP unresolved Table	ACTIVE
4	133031	SAPTable	SAP Table	ACTIVE
5	138017	CAST_Oracle_RelationalTable	Oracle table	ACTIVE
6	140697	CAST_Oracle_ObjectTable	Oracle object table	ACTIVE
7	138791	CAST_Oracle_MaterializedView	Oracle materialized view	ACTIVE
8	141046	CAST_DB2ZOS_RelationalTable	DB2 z/OS relational table	DEPRECATED
9	140978	CAST_ASETSQL_RelationalTable	Sybase table	ACTIVE
10	138871	CAST_MSTSQL_RelationalTable	Microsoft table	ACTIVE

Query result interpretation

The result displays all the type of objects counted in CMS. This types are based on category 6100 DataBase Table and computed by the stored procedure APM_SCOPE_TABLES.

Query for Oracle

Same as CSS

Query result example

Query result interpretation

Query for SQL server

Same as CSS

Enter the SQL query

Query result example

Query result interpretation

Notes/comments