create_itnm_triggers.sql

Edit online

Use this script to set up a Tivoli Netcool/OMNIbus ObjectServer to support the setting of event severity based on the value of the NmosCauseType field. For example, if NmosCauseType has the value 1 (root cause), then running this script will cause the event severity to be set to Critical.

Running the script

To run the script, use a command line similar to the following:

$NCHOME/omnibus/bin/nco_sql -server objectserver_name -user user_name -password password < $NCHOME/precison/scripts/create_itnm_triggers.sql

Command-line options

The following table describes the command-line options for the create_itnm_triggers.sql script.

Table 1. create_itnm_triggers.sql command-line options
Command-line option	Description
`objectserver_name`	Mandatory; the name of the database.
`user_name`	Mandatory; the name of the database user.
`password`	Mandatory; the password of the database user.