IBM Support

The Reporter Database Schema 1 - The Dynamic Tables

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

ObjectServer Tables

 

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

 

 


image

 

Subscribe and follow us for all the latest information directly on your social feeds:

 

 

image

 

image

 

image

 

 

  

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
 


image
 

 

 

[{"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

UID

ibm11081557