Populate a field in one table with a value from a different table using rel column in Dis Patterrn

vvr · ‎03-22-2023

Hello Everyone,

I am trying to populate a field in Table A with a value from Table B (temp table) using a related column (similar to joins) in the Discovery pattern extension section. Any thoughts on how this can be done?

The Discovery pattern that is being extended is: Network Switch.

I have added a field named ifAlias in the dscy_switchport table and want to add value of oid 1.3.6.1.2.1.31.1.1.1.18 to it. For this I have created ifXEntry temporary table in the pattern and trying to populate ifXEntry.ifAlias value into dscy_switchport.u_ifalias field with a matching instanceID.

few ways I tried are:

1. Using precondition to match the instanceID of the both the table

2. Trying to use the attached javascript (not complete). Not sure how to get the instanceID of the dscy_switchport.u_ifalias current row that it is going to update.

Greatly appreciate your thoughts or any other approaches.

Thank you.