Integrations > Third Party Integrations > Microsoft SCCM/SMS Integration > How to Customize the Integration Data Model in UCMDB

How to Customize the Integration Data Model in UCMDB

Out-of-the-box CIs for SCCM/SMS integration can be extended in one of the following ways:

ClosedTo add an attribute to an existing CI type:

If the attribute you want to add does not already exist in the CMDB, you need to add it. For details, see "Add/Edit Attribute Dialog Box" in the HPE Universal CMDB Modeling Guide.

  1. Go to the orm.xml file as follows: Data Flow Management > Adapter Management > SMS Adapter > Configuration Files > orm.xml.

  2. Locate the generic_db_adapter.[CI type] to be changed, and add the new attribute.

  3. Ensure that the TQL queries that include this CI type have the new attribute in their layouts as follows:

    1. In the Modeling Studio, right-click the node where you want to include the attribute.

    2. Select Query Node Properties.

    3. Click Advanced Layout Settings and select the new attribute.

      4. For details about selecting attributes, see "Layout Settings Dialog Box" in the HPE Universal CMDB Modeling Guide. For limitations on creating this TQL query, see Troubleshooting and Limitations – Microsoft SCCM/SMS Integration.

ClosedTo add a new CI Type to the Generic DB Adapter:

  1. In UCMDB, create the CI Type that you want to add to the adapter, if it does not already exist. For details, see "Create a CI Type" in the HPE Universal CMDB Modeling Guide.

  2. Go to the orm.xml file as follows: Data Flow Management > Adapter Management > SMS Adapter > Configuration Files > orm.xml.

  3. Map the new CI type by adding a new entity called generic_db_adapter.[CI type].

    4. For more details, see "The orm.xml File" in the HPE Universal CMDB Developer Reference Guide.

  4. Create queries to support the new CI types that you have added. Make sure that all mapped attributes are selected in the Advanced Layout settings:

    1. In the Modeling Studio, right-click the node where you want to include the attribute.

    2. Select Query Node Properties.

    3. Click Advanced layout settings and select the new attribute.

      4. For details about selecting attributes, see "Layout Settings Dialog Box" in HPE Universal CMDB Modeling Guide. For limitations on creating this TQL query, see Troubleshooting and Limitations – Microsoft SCCM/SMS Integration.

  5. In UCMDB, navigate to Data Flow Management > Integration Studio.

  6. Edit the SMS integration point to support the new CI type by selecting it either for population or for federation.

  7. If the new CI type is for population, edit the population job that you created above.