The Reporter Database Schema 2 - The Static Tables
Toni_Id 060001M7HX Visits (6589)
This is the second post in a series of three which give an overview of the Reporter Database Schema and its tables, columns, triggers and procedures.
The first one was http
This post focuses on the static tables.
The Static Data Tables: Members, Classes, Conversions, Groups, Names, Types
There are 5 static data tables, which hold non-event data that has been transferred across from the ObjectServer into the reporting RDBMS. They are
These tables hold information from the ObjectServer about user names, group names, classes, types and conversions.
a) add or remove users,
b) change the permissions of existing users
c) add conversions, classes or severities to the ObjectServer,
that information is recorded there. The static tables in the database are populated infrequently and not dynamically like the Reporter status, journal and details tables.
As a result you must transfer their contents either automatically when the gateway starts via the startup.cmd file or manually using nco_sql.
If the gateway is running on Unix, you can also create a cron job which connects to the gateway via nco_sql at regular intervals to transfer any changes which may
have been made while the gateway is operational.
The following tables list the fields in each of the Netcool/Reporter static tables. Fields that are marked with an asterisk (*) are primary key fields.
REPORTER_NAMES maps to master.names in the ObjectServer
REPORTER_GROUPS maps to master.groups in the ObjectServer
REPORTER_MEMBERS maps to master.members in the ObjectServer
REPORTER_CLASSES maps to alerts.objclass in the ObjectServer
Other Static, Non-Event Related Tables
REP_SEVERITY_TYPES stores the severity names associated with the six severity numbers (0-5), while REP_TIME_PERIODS
provides the number of days elapsed since the start of the report.
The next post in this series looks at:
Other blogs in this series:
Historical Database Gateways - An Overview http
Subscribe and follow us for all the latest information directly on your social feeds: