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
Release
Yes/No
8.3.x (tick)
8.2.x (tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (error)
Microsoft SQL Server (error)
CSS (tick)
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