Technical Blog Post
Abstract
The Reporter Database Schema 1 - The Dynamic Tables
Body
There are 14 tables that comprise the Netcool/Reporter data schema within a database. The schema forms the basis for the OMNIbus Reports for TCR. The tables are created by the schema build script and populated by the Netcool/Reporter gateway. The Reporter Schema tables fall mainly into 3 categories: Dynamic, Audit and Static.
As there is a large amount of information to cover on the Reporter Schema, it will have to be published in a series of blogs in order to comply with entry size restrictions. The Dynamic Tables are covered in this one. Others will cover the Static Data Tables, the Derived Audit Tables, the REP_AUDIT Triggers and Stored Procedures.
There are 3 dynamic tables - REPORTER_STATUS, REPORTER_DETAILS and REPORTER_JOURNAL - and they hold event information and related data. They are outlined in the tables below.
Changes to Severity, Acknowledge, OwnerUID, and OwnerGID in Reporter_Status are tracked in the Audit tables which will be covered in a later blog.
Not all the default Reporter_Status fields are shown here due to space constraints, however you can find more information on them in the ObjectServer documentation for alerts.status.
Fields that are marked with an asterisk (*) are primary key fields.
REPORTER_STATUS (maps to alerts.status in the ObjectServer)
| Field Name | Field Type | Field Size | Mandatory | Description |
| Identifier | varchar2 | 255 | No | Internal hash key/table identifier. |
| Serial | number | 16 | Yes | Netcool/OMNIbus serial number for item |
| Node | varchar2 | 64 | No | Hostname, IP address or other name identifying where the alert originated. |
| NodeAlias | varchar2 | 64 | No | Alias for node (for example, hosts which have multiple IP addresses). |
| Manager | varchar2 | 64 | No | Descriptive name of manager which generated the alert. |
| Agent | varchar2 | 64 | No | Descriptive name of sub manager which generated the alert. |
| AlertGroup | varchar2 | 255 | No | Descriptive name of the group within the manager which generated the alert. |
| AlertKey | Varchar2 | 255 | No | The descriptive key that indicates the managed object instance referenced by the alert. |
| Severity | number | 4 | No | Indicates the alert severity level, which indicates how the perceived capability of the managed object has been affected. |
| Summary | varchar2 | 255 | No | Summary of alert/problem as human readable text to appear on the administration console. |
| LastModified | date | - | No | The last time the event was updated. |
| FirstOccurrence | date | - | No | The time in seconds (from midnight January 1, 1970) when this alert was created or when polling started at the probe. |
| LastOccurrence | date | - | No | The time when this alert was last updated at the probe. |
| Poll | number | 16 | No | The frequency of polling for this alert in seconds. |
| Type | number | 16 | No | The type of alarm, where type refers to the problem or resolution state of the Alarm. |
| Tally | number
| 16 | No | Automatically-maintained count of the number of inserts and updates of the alert from any source. |
| Class | number | 16 | No | The alert class used to identify the probe or vendor from which the alert was generated. |
| Grade | number | 16 | No | Indicates the state of escalation for the alert. |
| Location | varchar2 | 64 | No | Indicates the physical location of the device, host, or service for which the alert was generated. |
| OwnerUID | number | 16 | No | The user identifier of the user who is assigned to handle this alert. |
| OwnerGID | number | 16 | No | The group identifier of the group that is assigned to handle this alert. |
| Acknowledged | number | 16 | No | Indicates whether the alert has been acknowledged; 0 = no, 1= yes. |
| DeletedAt | date | - | No | The time that the alert was deleted. |
| OriginalSeverity | number | 4 | No | The original severity of the alert. |
| ServerName * | varchar2 | 64 | Yes | Name of the originating server. This is used by the gateways to control propagation of alerts between ObjectServers |
| ServerSerial * | number | 16 | Yes | Serial number of the alert on the originating server (if it has not originated on this server). This is used to control propagation of alerts between ObjectServers. |
REPORTER_DETAILS maps to alerts.details in the ObjectServer.
| Field Name | Field Type | Field Size | Mandatory | Description |
| ServerName * | varchar2 | 64 | Yes | Same as alerts.status |
| ServerSerial * | number | 16 | Yes | Same as alerts.status |
| Identifier | varchar2 | 255 | No | Same as alerts.status |
| AttrVal | number | 16 | No | When false (0), just the Detail column is valid. Otherwise, the Name and Detail columns are both valid. |
| Sequence | number | 16 | No | used for ordering entries in the event list Event Information window. |
| Name | varchar2 | 255 | No | Name of attribute stored in the Detail column. |
| Detail | varchar2 | 255 | No | Attribute value. |
REPORTER_JOURNAL maps to alerts.journal in the ObjectServer.
| Field Name | Field Type | Field Size | Mandatory | Description |
| Serial | number | 16 | No | Same as alerts.status |
| UserID * | number | 16 | Yes | User identifier of user who made this entry. |
| Chrono * | date | - | Yes | Time and date that this entry was made. |
| Text1 -16 | varchar2 | 255 | No | There are 16 blocks of text provided for journal entry. If an entry exceeds 255 characters, it is placed in the next field. |
| ServerName * | varchar2 | 64 | Yes | Same as alerts.status |
| ServerSerial * | number | 16 | Yes | Same as alerts.status |
The next entry in this series will cover the Static Tables:
REPORTER_MEMBERS
REPORTER_NAMES
REPORTER_CLASSES
REPORTER_GROUPS
REPORTER_CONVERSIONS
Related Links
Download Information for Schema Creation Scripts
Other blogs in this series:
Historical Database Gateways - An Overview https://ibm.biz/BdjeyS
Reporter Database Schema 2 – The Static Tables https://ibm.biz/Bdjh3Z
Reporter Database Schema 3 – The Audit Tables https://ibm.biz/BdjAHH
Subscribe and follow us for all the latest information directly on your social feeds:
|
|
 |
|
| Check out all our other posts and updates: | |
| Academy Blogs: | https://goo.gl/eZjStB |
| Academy Videos: | https://goo.gl/kJeFZE |
| Academy Google+: | https://goo.gl/HnTs0w |
| Academy Twitter : | https://goo.gl/DiJbvD |
UID
ibm11081557