Retrieving additional fields from ICD

By default, the gateway only retrieves the STATUS field from ICD tickets.

If you want to retrieve an additional field from ICD to send back to Netcool/OMNIbus, you must use the following steps:
  1. Add the field to the XML structure for the ICD incident or service request.
  2. Add the field to the ObjectServer.
  3. Add the ICD field to the list of fields retrieved by the gateway.

Adding fields to the XML structure for incidents and service requests

You can add any of the ICD ticket fields to the details that are retrieved and sent back to Netcool/OMNIbus. For details of which fields are available for selection, see the IBM Control Desk documentation.

The following example shows how to add the appropriate XML code for retrieving the SLAAPPLIED field to the XML structure for an ICD incident:
  1. Start ICD.
  2. Select Go To > Integration > Object Structures .
  3. In the filter field of the Object Structure column, enter MXINCIDENT and press Enter.
  4. Open the MXINCIDENT object structure.
    Note: To add an ICD field to service request details retrieved and sent back to Netcool/OMNIbus, search for, select, and open MXSR instead of MXINCIDENT.
  5. Select the Object Structure tab.
  6. Select the Exclude/Include Fields action.

    ICD displays the Exclude/Include Fields dialog box.

  7. Select the Non-Persistent Fields tab.
  8. Select the Include check box beside the SLAAPPLIED entry.
  9. Click OK.
  10. To confirm that the XML code for the SLAAPPLIED field has been added correctly, select the Generate Schema/View XML action from the Object Structure panel.

    ICD displays the View XML dialog box.

  11. In the left-hand side of the panel, scroll through the XML and locate the following XML (highlighted in Figure 12):

    <max:SLAAPPLIED changed="false">false</max:SLAAPPLIED>

  12. Select OK to close the dialog box.

Adding a field to the ObjectServer

To add a field to the ObjectServer, run the following command using the ObjectServer SQL tool:
alter table alerts.status add column FieldName typ;
go
where FieldName is the name of the field that you are adding and typ indicates the data type.
For example, run the following command to add the SLAApplied field to the ObjectServer:
alter table alerts.status add column SLAApplied int;
go

Adding an ICD field to the list of fields retrieved by the gateway

To add an ICD field to the list of fields retrieved by the gateway, set the Gate.TSRM.QueryRetrieveList property to SLAAPPLIED, where SLAAPLIED is the ICD ticket field that you want to add.

You must also add the extra ICD field to the following SQL file that is supplied with the gateway:

$OMNIHOME/gates/tsrm/tsrm.script

The following example shows the added SLAAPLIED field in bold type:
CASE_OP_TYPE STATUS_UPDATE:
update alerts.status via '$Identifier' set SLAAPLIED='$SLAPPLIED'
where ServerName='$ServerName' and ServerSerial=$ServerSerial;
BREAK;
END;

Checking that the new field gets sent back to Netcool/OMNIbus

To check that the SLAAPPLIED field gets sent back to Netcool/OMNIbus, use the following steps:
  1. Run the gateway.
  2. Start ICD.
  3. Open an incident created by the gateway.
  4. Apply an SLA to the incident by selecting Select Action > Apply SLA
  5. Check the Netcool/OMNIbus Event List to verify that the SLA was applied.