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:
- Add the field to the XML structure for the ICD incident or service request.
- Add the field to the ObjectServer.
- 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: - Start ICD.
- Select .
- In the filter field of the Object Structure column, enter MXINCIDENT and press Enter.
- 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 ofMXINCIDENT
. - Select the Object Structure tab.
- Select the Exclude/Include Fields action.
ICD displays the Exclude/Include Fields dialog box.
- Select the Non-Persistent Fields tab.
- Select the Include check box beside the
SLAAPPLIED
entry. - Click OK.
- 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.
- 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>
- 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:- Run the gateway.
- Start ICD.
- Open an incident created by the gateway.
- Apply an SLA to the incident by selecting
- Check the Netcool/OMNIbus Event List to verify that the SLA was applied.