JDBC Event Enrichment policy - Copy CI UserAttribute value into Alert User Attribute

Document ID : KB000011593
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Event Enrichment Policy - We want to copy Parent CI (Let's say Computer System) "CI UserAttribute1" value to an alert UserAttribute10 of a Child CI of ComputerSystem CI.

For Ex: There are few ComputerSystem CIs with Child CIs like File, Interface etc. We manually updated "CIUserAttribute" for parent CI that is "ComputerSystem" and when there is a new alert on child CIs we want the parent "CIUserAttribute" value to be update in Alert "UserAttribute"

Question:

We want to copy a Parent CI(Let's say Computer System) CI UserAttribute1 value to an alert UserAttribute10 of a Child CI of ComputerSystem CI.

Environment:
Windows 2008 & Windows 2012SOI 3.3 & 4.0
Answer:

This can be achieved through an JDBC Event Enrichment policy, please follow these steps

1) Create a new event enrichment policy

1.png

2)

2.png

3)

3.png

4) Deploy this policy to MTC or individual connector like Universal or Spectrum etc

4.png

5) Modify the policy file with below SQL query in \SOI\resources\Core\Catalogpolicy\extensions and save the file

query="select UserDefinedCol1 from CI where DeviceID in (select DeviceID from CIStaging where CINamespaceMapID=?) and CI.UserDefinedCol1 is not NULL"

6) The ‘CI User Attribute’ is available to the CI that is modeled

 

 

1)     First, add a value to ‘CI User Attribute (1)’ for the ComputerSystem CI as shown in the picture

      5.png

    7)   When an alert generated on any of the child CIs, the Event Enrichment DB policy will run the SQL query to get User Attribute value against ‘CINamespaceMapID’ and update alert “User Attribute” property.  As you see in the below screenshot, there are alerts on child CIs like Processor, Memory etc and the UserAttribute10 is updated with a value of Parent CI "CI UserAttribute1"

    

   6.png