Remove FQDN in Name field in SOI Alert for Spectrum connector

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We are receiving the alerts from Spectrum in SOI. Few of the alerts are are showing Name with FQDN in the SOI Console, Due to SOI alert having Name with FQDN and SNOW tickets are generating with Blank CI in the Affected CI field, since the CI does not have FQDN in SNOW CMDB. Please note that this is happening only for few CI's. Please let us know how to remove FQDN in SOI Alert. 

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

Edit \SOI\resources\Core\Catalogpolicy\spectrumim_policy.xml

In the ComputerSystem and GenericIPDevice sections, 

add the Parse before format section

<Parse> 
              <Field input="Model_Name" pattern="^(.*)\..*\..*\..*$" output="tempLabel" /> 
</Parse>   

Add the Format2 after Format section

<Format2>
            <Field conditional='tempLabel'  output='userAttribute1' format='{0}' input='tempLabel'/>
</Format2> 

Example:

<EventClass name="ComputerSystem" extends="NetworkEntity">
 <Parse> 
              <Field input="Model_Name" pattern="^(.*)\..*\..*\..*$" output="tempLabel" /> 
</Parse>     
  <Format>
      <!-- assign ClassName -->
      <Field output="ClassName" format="ComputerSystem" input="" />

      <!-- assign correlatable properties, need at least one -->
      <Field output="ComputerName" format="{0}" input="Model_Name" />
      <Field output="Tags" format="System-Layer-Hardware" input="" />
      <Field conditional="Vendor_Name" output="Vendor" format="{0}" input="Vendor_Name" />
      <Field conditional="DeviceType" output="Model" format="{0}" input="DeviceType"/>
    </Format>
 <Format2>
            <Field conditional='tempLabel'  output='userAttribute1' format='{0}' input='tempLabel'/>
</Format2> 
    <Write>
      <Field type="file" name="ComputerSystem.out" properties="*" />
      <Field type="publishcache" properties="ClassName,ComputerName,Tags,Model,Vendor" />
    </Write>
</EventClass>

After making changes to the Spectrum connector policy, restart the Spectrum connector.

Uncheck the DNS_Resolution for the Spectrum connector.

You need to delete the CI from Spectrum and re-discover the CI.