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

Purpose of Query

Types of objects counted in CMS are based on category 6100 DataBase Table, and computed by the stored procedure APM_SCOPE_TABLES. The following query give all the types of objects counted in CMS

Applicable CAST Version

Applicable RDBMS

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

1;“SQL_TABLE”;“SQL Table”;“ACTIVE "

133031;“SAPTable”;“SAP Table”;“ACTIVE "
138017;“CAST_Oracle_RelationalTable”;“Oracle table”;“ACTIVE "
138791;“CAST_Oracle_MaterializedView”;“Oracle materialized view”;“ACTIVE "
138871;“CAST_MSTSQL_RelationalTable”;“Microsoft table”;“ACTIVE "
140697;“CAST_Oracle_ObjectTable”;“Oracle object table”;“ACTIVE "
140978;“CAST_ASETSQL_RelationalTable”;“Sybase table”;“ACTIVE "
141046;“CAST_DB2ZOS_RelationalTable”;“DB2 z/OS relational table”;“ACTIVE "
141260;“CAST_TSQL_UDT_TABLE”;“SQL Server UDT TABLE”;“ACTIVE "
141449;“CAST_ABAP_SAPUnresolvedTable”;“SAP unresolved Table”;“ACTIVE "

Query result interpretation

For each type of objects counted in CMS, the query returns the id, the name and description of the job

Query for Oracle

TBD

Query result example

Query result interpretation

Query for SQL server

Query result example

Query result interpretation

Notes/comments

Related Pages