How to truncate Alert Summary and assign this value into userAttribute10

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We want to assign Alert Summary value into userAttribute10 attribute and also want to truncate summary to 50 characters

How can we do this by updating connector policy

Environment

SOI: 4.x

 

Resolution

This can be done by using "trunc" function and update connector policy. I took Universal connector policy as an example and update as below

1. Stop Connector services (CA SOI Integration Services)

2. Backup \SOI\resources\core\catalogpolicy\universal_policy.xml file

3. Update \SOI\resources\core\catalogpolicy\universal_policy.xml 

• Locate <Format> section under <EventClass name="Alert"> and add below line
• <Field conditional='Summary' input='{trunc([Summary,15])}' format='{0}' output='userAttribute10' />
• 
• Start "CA SOI Integration" Services

4. Publish an alert through Universal Connector and verify UserAttribute10 column for this alert

5. Now, the UserAttribute10 attribute has only 15 characters 

Note: To update Catalyst connectors such as UIM connector, please update "\CatalystConnector\registry\topology\physical\<HostName>_CatalystConnector\modules\policy\nimsoftconnector_policy.xml" and then restart "CA Catalyst Container" services