Adding values to the Conversions table

To add field values to the ObjectServer Conversions table, use the SQL interactive interface utility. You might want to add conversions for the Event Discriminator field and the Output Severity Threshold fields for incoming status rules. This example shows how to add the following Manager field values to the Conversions table:

Pinger
TrapReceiver

Change values using the SQL interactive interface on UNIX systems

To run the SQL interactive interface on a UNIX system, issue the following commands:


$OMNIHOME/bin/nco_sql -server NCOMS -user root -password ''
INSERT INTO conversions (KeyField,Colname,Value,Conversion) values 
('Manager0','Manager',0,'Pinger');
INSERT INTO conversions (KeyField,Colname,Value,Conversion) values 
('Manager1','Manager',1,'TrapReceiver');

Change values using the SQL interactive interface on Windows systems

To run the SQL interactive interface on a Windows system, issue the following commands:


%OMNIHOME%\bin\redist\isql.exe -S NCOMS -U root -password ''
INSERT INTO conversions (KeyField,Colname,Value,Conversion) values 
('Manager0','Manager',0,'Pinger');
INSERT INTO conversions (KeyField,Colname,Value,Conversion) values 
('Manager1','Manager',1,'TrapReceiver');