table name where all CCMS values stored

[Former Member]

Hi,

Can any one provide the table name where all CCMS values stored ( for all MTE classes) in the data base?

Regards

Soumitra

[sunny_pahuja2]

Hi,

table name is ALTRAMONI.

check this link also

Thanks

Sunny

[Former Member]

Hi,

it is not a single table where CCMS stores the alert data.

it is comming from multiple functional modules like..

SALM_MT_GET_TREE_AND_MTDATA,

SALM_MT_TYPE_GET,

SALM_VIRTUAL_MT_CREATE,

SALM_MT_TREES_CONCATENATE,

SALM_ALERTS_PROP_IN_VIRT_TREE,

SALM_MONITOR_CREATE,

SALM_MONITOR_DESTROY,

SALM_MONITOR_LOAD,

SALM_MT_ALERT_DATA_SHOW,

SALM_MT_MARKED_INFO_GET,

SALM_ALERT_SET_DONE,

SALM_ERRONOUS_MT_NODE_CREATE,

SALM_GET_TID_BY_NAME,

SALM_MT_DETAIL_DATA_SHOW,

SALM_MONITOR_NAME_GET,

SALM_MT_TREE_DISPLAYCONFIG_GET,

SALM_MT_ANALYSE_SHOW,

SALM_MT_ANALYSE,

SALM_MT_TREE_LEGEND_SHOW,

SALM_RAISE_ALERT_STATE_CHANGE,

SALM_MT_INVALID_ACTION_WARNING,

SALM_MT_DESTROY,

SALM_MT_RESET,

SALM_MT_MARKING_EDITOR,

SALM_MT_MONITORING_START,

SALM_MONISET_READ_FROM_DB,

SALM_MONISET_WRITE_TO_DB,

SALM_MONISET_ATTRIBUTE_EDITOR,

SALM_MONISET_DELETE_FROM_DB,

SALM_GET_MT_TREE_MARKINGS,

SALM_MT_DESTROY,

SALM_MT_RESET,

SALM_MT_MARKING_EDITOR,

SALM_MT_MONITORING_START,

SALM_MONISET_READ_FROM_DB,

SALM_MONISET_WRITE_TO_DB,

SALM_MONISET_ATTRIBUTE_EDITOR,

SALM_MONISET_DELETE_FROM_DB,

SALM_GET_MT_TREE_MARKINGS,

SALM_MT_CLASSES_MARK,

SALM_MT_CLASS_NAME_GET,

SALM_MONITOR_COPY,

SALM_MONISET_COPY,

SALM_MT_SAMPLES_GRAPH_DISPLAY,

SALM_MT_READ,

SALM_MT_GET_AID_BY_TID,

SALM_MT_DESCRIPTION_SHOW,

SALM_MONIDEF_NODE_EDITOR,

SALM_MONIDEF_EDITOR,

SALM_RULE_RESULT_NODE_CREATE,

SALM_MONITOR_TEMPLATE_GENERATE,

SALM_MONITOR_TEMPL_NODE_CREATE,

SALM_MONITOR_PRESENTATION_GEN,

SALM_MONIDEF_NODE_CREATE,

SALM_MONIDEF_EDITOR,

SALM_RULE_RESULT_NODE_CREATE,

SALM_MONITOR_TEMPLATE_GENERATE,

SALM_MONITOR_TEMPL_NODE_CREATE,

SALM_MONITOR_PRESENTATION_GEN,

SALM_MONIDEF_NODE_CREATE,

SALM_GET_MONIDEF_TREE_MARKINGS,

SALM_MSC_TIME_INTERVAL_GET,

SALM_TEST_VALUE_REPORT,

SALM_MONISET_DIRECTORY_GET,

SALM_MONITOR_DIRECTORY_GET,

SALM_MONITOR_TEMPLATE_GET,

SALM_MONITOR_PRESENTATION_GET,

SALM_MONISET_DISPLAYCONFIG_GET,

SALM_MT_ALERT_DATA_GET,

SALM_MONITOR_DISPLAYCONFIG_GET,

SALM_ABORTED_TOOL_STATUS_RESET,

SALM_MONISET_DIR_LEGEND_SHOW,

SALM_MT_PERF_HISTORY_DATA_GET,

SALM_ALERT_DESCRIPTION_SHOW,

SALM_MONIDEF_RULE_DESCR_EDITOR,

SALM_RULE_PARAM_TYPE_HELP,

SALM_RULE_PARAM_DOCU_HELP,

SALM_RULE_PARAM_DESCR_CHECK,

SALM_LOGIN_TO_SYSTEM_OF_MTE,

SALM_MT_R3SYSTEM_EXPLORE,

SALM_MONITOR_LOAD_IN_OWN_TASK,

SALM_MT_ALERT_DATA_SHOW_GRID,

SALM_MT_ALERT_DATA_BUILD_ALV,

SALM_ALERT_TIME_INTERVAL_GET,

SALM_TEST_COPY_MONISETS,

SALM_MONIDEF_WRITE_TO_FILE,

SALM_MONIDEF_READ_FROM_FILE,

SALM_MONIDEF_SYNTAX_CHECK,

SALM_MT_STATE_CHANGE,,

SALM_LOAD_MON_FROM_ACTIVE_SET,

SALM_MONIDEF_SYNTAX_CHECK,

SALM_MT_STATE_CHANGE,

SALM_LOAD_MON_FROM_ACTIVE_SET,

SALM_GET_CURRENT_DB_FORMAT_VER,

SALM_MONIDEFS_OF_MONISET_GET,

SALM_GET_CURRENT_MONISET,

SALM_SET_CURRENT_MONISET,

SALM_MT_ASSIGN_ATTRIBUTE_GROUP,

SALM_VOLATILE_RULE_PARAM_SET,

SALM_VOLATILE_SYSIDLIST_SET,

SALM_MT_CLASSES_MARK,

SALM_MT_CLASS_NAME_GET,

SALM_MONITOR_COPY,

SALM_MONISET_COPY,

SALM_MT_SAMPLES_GRAPH_DISPLAY,

SALM_MT_READ,

Edited by: Soumitra Roy on Oct 13, 2009 5:31 AM