Updating Rollup Configuration
You can add columns to Seasonal Event reports and Related Events reports. Update the rollup configuration to add columns to reports.
Before you begin
- Log in to the server where IBM Tivoli Netcool/Impact is stored and running.
- Go to the <Impact install location>/bin directory.
- Enter the following command.
./nci_trigger NCI <UserID>/<password> NOI_DefaultValues_Export FILENAME <Full Path to the file name>.properties
- <UserID>
- Specifies the ID of the Impact user.
- <password>
- Specifies the password of the Impact user.
- <Full Path to the file name>
- Specifies the directory where the properties file is stored.
About this task
Procedure
Results
Example
number_of_rollup_configuration=3
rollup_1_column_name=SEVERITY
rollup_1_display_name=MINSeverity
rollup_1_type=MIN
rollup_2_column_name=SEVERITY
rollup_2_display_name=MAXSeverity
rollup_2_type=MAX
rollup_3_column_name=TYPE
rollup_3_display_name=TYPE
rollup_3_type=MAX
Example 2. The configuration parameters
for a default Related Events report. reevent_rollup_1_column_name=ORIGINALSEVERITY
reevent_rollup_1_display_name=MINSeverity
reevent_rollup_1_type=MAX
reevent_rollup_1_actionable=true
reevent_rollup_2_column_name=ACKNOWLEDGED
reevent_rollup_2_display_name=Acknowledged
reevent_rollup_2_type=NON_ZERO
reevent_rollup_2_actionable=true
reevent_rollup_3_column_name=ALERTGROUP
reevent_rollup_3_display_name=AlertGroup
reevent_rollup_3_type=EXAMPLE
reevent_rollup_3_actionable=false
What to do next
To add columns to the Seasonal Event reports, Historical Event portlet, Related Eventreports, or Related Event Details portlet complete the following steps:
- Log in to the Tivoli® Netcool®/Impact UI.
- Go to the Policies tab.
- Open the policy that you want to modify. You can modify one policy
at a time.
- For Historical Events, open the SE_GETHISTORICALEVENTS policy.
- For Seasonal Events, open the SE_GETEVENTDATA policy.
- For related events groups, open one of the following policies.
- RE_GETGROUPS_ACTIVE
- RE_GETGROUPS_ARCHIVED
- RE_GETGROUPS_EXPIRED
- RE_GETGROUPS_NEW
- RE_GETGROUPS_WATCHED
Note: Each policy is individually updated. To update two or more policies, you must modify each policy individually. - For related events, open one of the following policies.
- RE_GETGROUPEVENTS_ACTIVE
- RE_GETGROUPEVENTS_ARCHIVED
- RE_GETGROUPEVENTS_EXPIRED
- RE_GETGROUPEVENTS_NEW
- RE_GETGROUPEVENTS_WATCHED
Note: Each policy is individually updated. To update two or more policies, you must modify each policy individually. - For related events details group instances table, open the following
policy:
- RE_GETGROUPINSTANCEV1
- Click the Configure Policy Settings icon.
- Under Policy Output Parameters, click Edit.
- To create a custom schema definition, open the Schema Definition Editor icon.
- To create a new field, click New.
- Specify the new field name and format.
- The new field name must match the display name in the configuration file.
- The format must be string format for the rollups to correctly display.
- Refresh the SE_GETHISTORICALEVENTS_DB2 table, or other database model, before you run Event Analytics with the added Historical Event table fields.
- For the RE_GETGROUPS_ policies, only rollup columns with a <type> value of MAX, MIN, SUM, NON_ZERO are supported. Therefore, add only numeric fields to the schema.
- To complete the procedure, click Ok on each of the open dialog boxes,
and Save on the Policies tab.Note: Columns that are created for the Related Event Details before Netcool Operations Insight release 1.4.0.1 are displayed as designed. Configurations and groups that are created after you upgrade to Netcool Operations Insight release 1.4.0.1, display the events from the historical event. By adding columns to the Related Event Details, you can display additional information such as the owner ID or ticketnumber.
- To add columns to the Related Event Details,
update the RE_COLUMN_EVENT_INSTANCES variable in
the RE_CONSTANTS policy in Impact. Add or remove
fields from the static array. For example,
var RE_COLUMN_EVENT_INSTANCES = "NODE,SUMMARY,ALERTGROUP,SEVERITY,OWNERUID,ACKNOWLEDGED,TALLY";
- SERVERSERIAL
- SERVERNAME
- TALLY
- OWNERUID
By default, the previously listed columns are hidden for group instances in the Related Event Details. To display these columns in the Related Event Details, you need to edit the Policy_RE_GETGROUPINSTANCEV1_RE_GETGROUPINSTANCEV1.properties file, which is located in the following directory: $IMPACT_HOME/uiproviderconfig/properties.
Specifically, set the following properties in the Policy_RE_GETGROUPINSTANCEV1_RE_GETGROUPINSTANCEV1.properties file from their default values of true to the values false (or comment out the field or fields):
SERVERSERIAL.hidden=true
SERVERNAME.hidden=true
TALLY.hidden=true
OWNERUID.hidden=true
OWNERUID.hidden=false
#OWNERUID.hidden=true