Issue with Patterns

[pauladams]

Hi,

I have built a horizontal discovery pattern with different steps and its not working the way I expect it to

The objective of this pattern is to collect data for multiple attributes for a CI class and populate them. To achieve this I built a pattern with multiple steps -

1) the first step is to parse the executable path of the process and store the value in a temporary variable  inside a temporary table

2) in the second step, I am parsing another variable and storing the value in a temporary variable (not inside a table)

3) In the third step, a transform table operation is used to add the variable from the step # 2 to the table created from step # 1

4) The fourth step is being used for updating another table by doing a WMI query

The 5th and 6th steps are where I am having problem or its not working properly.

5) The fifth step has a transform table operation to update another temporary table with values derived from the WMI query in step # 4

6) The last step is to merge the tables creted in Step # 1 and Step # 5 into the target table.

However, it is creating/updating the CI with the data transformed through in step # 5 and it doesn't pass the data to the table through the merge table in step #6. When I interchange the sequence of step # 5 & # 6 then the merge operation works fine but not the transform map. So basically it stops after step # 5 irrespective of what it is.

When I checked the Discovery Logs, the Creating CI shows only the variables of step #5 going in

Any idea what's going on?

Below are the screenshots of each step.

[Ct111]

Hi,

Have a look at the below example if this gives you an idea about rectifying something in your process

https://docs.servicenow.com/bundle/helsinki-it-operations-management/page/product/discovery/reference/r_DiscoveryPatternExample.html

Mark my ANSWER as CORRECT and HELPFUL if it helped.

[Balaji14]

Hi Paul,

From my understanding with the screenshots, if you have already transformed the details in to the web_server table why do you want to merge and add those details again into the same table? you could have went with another transform table operation to pass on the information from name_detials table to web_server table.

So i believe since the data is already in the table in 5th step, its restricting from overwriting it again making either one of your steps to fail, which shouldn't happen but cant come to any 100% conclusion until or unless deeper hands-on on the same.

Also i have faced some issues always with the naming conventions, so try to add a pre-fix for name and version in the name_details table, since both name and version are available in the cmdb table also which may conflict during any operations.