Integrate > HPE Product Integrations > HPE Configuration Manager – Federating Policy Data > How to Consume Federated Policy Data from Configuration Manager

How to Consume Federated Policy Data from Configuration Manager

This workflow provides a brief overview of the steps to be performed in UCMDB, in order to consume federated data from Configuration Manager.

ClosedCreate an Integration Point to Federate Policy Compliance Data

  1. In the Integration Studio, create a new integration point.

  2. Set the following adapter properties:

    Field Description
    Adapter

    Click the button and select CMPolicyAdapter.
    Credentials ID

    Do the following:

    1. Click the button.
    2. Select Generic DB Protocol (SQL) and click OK.
    3. Click the button to add the credentials to connect to the Configuration Manager database. These should be the same credentials that were provided during the installation of Configuration Manager.
    4. When finished, click OK.
    DB Name/SID The database name or schema ID.
    DB Type Specify Oracle or MSSQL, as required.
    Hostname/IP Provide the host name or IP address of the Configuration Manager database.
    Integration Name Enter a name for the new integration point.
    Port Enter the port number that is used for communication with the Configuration Manager database.
  3. Click Test Connection to make sure that you have configured the integration point correctly.
  4. Click OK to save the integration point.
  5. Select the Policy and PolicyResults CI types in the Supported and Selected CI Types tree.
  6. Click the button to save the integration point.

For further details about creating integration points, see the section about the Integration Studio in the Universal CMDB Data Flow Management Guide.

ClosedCreate Policy Reports Based on CIs in a View or Custom TQL query
  1. Create an integration point as described in , if one does not already exist.

  2. In UCMDB, create a new view with a custom TQL query, or copy an existing view.

    Note When using a custom TQL query, make sure you take into account the limitations of the data capacity when using federation. You should filter the CIs in the TQL query to take this limitation into account. For details, see

  3. For each configuration item that you want to associate with a policy, attach the Policy CI type and the selected CI to the PolicyResult CI type, using composition and aggregation links accordingly. The cardinality should be 0..* if you also want to obtain results for CIs that do not have associated policy information. An example is shown below:

  4. Specify the Configuration Manager integration point that you defined to be the data source that provides the policy and policy result data.

  5. Set the hierarchy. An example is shown below:

  6. Add properties for the Policy CI type to the report layout: An example is shown below:

  7. Add properties for the PolicyResult CI type to the report layout. An example is shown below:

  8. If desired, you can schedule these reports to be created periodically. For details, see the Universal CMDB Data Flow Management Guide.

For details about creating reports, see the section about reports in the Universal CMDB Modeling Guide.

ClosedCreate summary policy reports based on the CIs in a view or a custom TQL query
  1. Create an integration point as described in , if one does not already exist.

  2. In UCMDB, create a new view or copy an existing view.

    Note When using a custom TQL query, make sure you take into account the limitations of the data capacity when using federation. You should filter the CIs in the TQL query to take this limitation into account. For details, see .

  3. For each configuration item that you want to associate with a policy, attach the Policy CI type and the selected CI to the PolicyResult CI type, using composition and aggregation links accordingly. The cardinality should be 0..* if you also want to obtain results for CIs that do not have associated policy information. An example is shown below:

  4. Specify the Configuration Manager integration point that you defined to be the data source that provides the policy and policy result data.

  5. Set the hierarchy. An example is shown below:

  6. Create an aggregation function for the Policy CI type. An example is shown below:

  7. Add properties for the Policy CI type to the report layout. An example is shown below:

  8. Add properties for the ConfigurationItem CI type to the report layout. An example is shown below:

  9. Change the report format to a bar chart. An example is shown below:

  10. If desired, you can schedule these reports to be created periodically. For details, see Universal CMDB Data Flow Management Guide.

For details about creating reports, see the section about reports in the Universal CMDB Modeling Guide.

Send Help Center feedback