Enriching device class fields

You can configure chassis events to be enriched with the class name and device class type of the device on which they were raised.

1. On the server where the Event Gateway is installed, back up and edit the $NCHOME/etc/precision/EventGatewaySchema.cfg file.
2. In the config.defaults section, set the EnrichWithClassNameAndType property to 1.
   The default is 0, which disables the device class information enrichment.
3. Add the new fields (shown in bold text) to the outgoing event filter. Remember to add a comma at the end of each line except the final line. Your event filter might look different to the following example:

   insert into config.ncp2nco
   (
       FieldFilter
   )
   values
   (
       [
           "NmosCauseType",
           "NmosDomainName",
           "NmosEntityId",
           "NmosManagedStatus",
           "NmosObjInst",
           "NmosSerial",
           "NmDeviceClassName",
           "NmDeviceClassType"
       ]
   );

4. Add the new fields (shown in bold text) to the incoming event filter. Remember to add a comma at the end of each line except the final line. Your event filter might look different to the following example:

   insert into config.ncp2nco
   (
       FieldFilter
   )
   values
   (
       [
           "NmosCauseType",
           "NmosDomainName",
           "NmosEntityId",
           "NmosManagedStatus",
           "NmDeviceClassName",
           "NmDeviceClassType"
       ]
   );

5. On the server where the Network Manager core components are installed, run the add_device_class_columns.sql script using the following command line:

   $NCHOME/omnibus/bin/nco_sql -server server_name -user root -password password -i /opt/IBM/tivoli/netcool/precision/scripts/add_device_class_columns.sql
   

   Where:

   • server_name is the name of the ObjectServer.
   • password is the password of the root user.
   The script adds the fields NmDeviceClassName and NmDeviceClassType to the ObjectServer alerts.status table.