| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMonitoring |
1 | ALALERTDB | Alert: alert database (general alert structure, raw message) | 3 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |
2 | ALALERTX | CCMS Monitoring: Cache for Alerts Already Read | 10 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |
3 | ALALRTGUID | GUIDs for CCMS Alert IDs (for Alert Framework) | 3 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |
4 | ALDBSMTE | CCMS Monitoring Arch.: Database Segment: General MTE Data | 34 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |
5 | ALSYSAL | Instance Table for BOR Object SYALERT (for Use with WFs) | 4 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |
6 | CSMCENTOOL | CCMS Monitoring: Container for Methods Started Centrally | 8 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |
7 | SCMC_NODE | Basic Data of Executed Monitors | 27 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |
TOPProcess Monitoring Infrastructure |
8 | SSPIMOALERTS | PMI: Self-Monitoring, Table of Triggered Alerts | 4 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | | |