Integrate > Micro Focus UCMDB > Using the ServiceManagerAdapter9.41 Adapter > Tailoring the Integration > Integration Tailoring Options > How to Add the CI Type's Attributes to the Query Layout

How to Add the CI Type’s Attributes to the Query Layout

To add a CI attribute to the integration, you must enable the calculation layout setting from the query that synchronizes the CI type. Because you must enable calculation for each attribute you want to add to the integration, you should be familiar with the integration CI types and the CI attributes that they contain.

Tip Keep a list of the attributes that you enable, because you will need to create a matching XSL transformation for each one.

The following steps illustrate how to enable calculation for attributes of the SM RDBMS CI type described in previous sections.

To add a CI type’s attributes to the query layout:

  1. Log in to UCMDB as an administrator.
  2. Navigate to Modeling > Modeling Studio.
  3. From the Queries navigation tree, click Integration > SM Sync.
  4. Select the query that manages the CI type whose attributes you want to add to the integration. For example, rdbmsData. UCMDB displays the query for the integration.
  5. Select the Root node from the query layout, and then click the Edit button from the Information Pane. The Node properties window opens.

    Caution Your integration query must contain a node called Root. See Query Requirements for more information.

  6. Click the Element Layout tab, and select the option Select attributes for layout.
  7. Select Specific Attributes from the Attributes condition list, and from the Available Attributes list select each CI attribute you want to add to the Specific Attributes list. For example, select the Product Name, Application Version Description, Vendor, Version, Description, The Database Instance Name, and Port attributes.

  8. Click OK to save the query node properties.
  9. Select any additional nodes that contain CI attributes you want to add to the integration. For example, Node.
  10. Click the Edit button from the Information Pane. The Node properties window opens.
  11. Click Element Layout tab, and select the option Select attributes for layout.
  12. Select Specific Attributes in Attributes condition, and from the Available Attributes list select each CI attribute you want to add to the Specific Attributes list. For example, select attributes for the OS Vendor, and name attributes.
  13. Click OK to save the query node properties.
  14. Repeat step 9 to step 13 for each additional node that contains CI attributes that you want to add to the integration.
  15. Click the Save button to save the query .