Words and Phrases
How to Define a Join Relationship – Scenario
This section explains how to define a join relationship that links Node CIs to IP Address CIs whose Created by attribute values are equal.
Note To reach the required result, you must implement each one of the following steps.
To define a join relationship that links all IP Address and Node CIs whose Created by attribute values are equal:
-
Create a TQL query and drag the following query nodes from the CI Types selector onto the editing pane:
-
Node
-
IP Address
-
-
Select both of the Node and IP Address query nodes, right-click and select Add Join Relationship to open the Add Join Relationship dialog box.
-
Click the Add
button to add a row to the table and do the following:-
In the Node attribute box, select Created by.
-
In the Operator box, select Equal.
-
In the IpAddress attribute box, select Created by.
In Enrichment Manager and Impact Analysis Manager, you make these selections in the Join Relationship Condition dialog box.
The Join Definition area now looks like this:
-
-
Click OK to save your changes.
The TQL query in the editing pane now looks like this:
