Administer > RTSM > RTSM Modeling > Introduction > Topology Query Language > How to Define a Join Relationship – Scenario

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:

  1. Create a TQL query and drag the following query nodes from the CI Type Selector onto the editing pane:

    • Node

    • IP Address

  2. Select the Node and IP Address query nodes and right-click to open the Add Join Relationship dialog box.

  3. 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 IP Address 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:

  4. Click OK to save your changes.

    The TQL query in the editing pane now looks like this:

Related Topics Link IconRelated Information