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
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
SELECT t.* FROM typ t, typcat tc, cat c WHERE t.idtyp = tc.idtyp AND tc.idcatparent = c.idcat AND c.idcat = 6100
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 "
TBD