How to Add the CI Type in Service Manager

Before creating a new Service Manager CI type, you should determine if there are any existing CI types in your Service Manager system that provide the CI attributes you want. In most cases, you can reuse the existing CI types for the integration.

The integration does not require any special steps to add a CI type to Service Manager. You can use the standard CI type creation procedures to add a CI type. For more information on CI type creation, see the Service Manager online help.

To add a new CI type in Service Manager:

  1. Create a table for storing the specific attributes of this new CI type.
  2. Create a join definition to join the device table.
  3. Create an erddef definition that defines a relationship between the two tables.
  4. Create a view form and a bulk update form for the new CI type.
  5. Add the CI type.

The following steps illustrate how to create a new CI type called RDBMS.

Note This example is provided only as an illustration of the steps. The best practice is to reuse the existing Service Manager CI type RunningSoftware to map with UCMDB CI type SM RDBMS.

To create a table in Service Manager:

  1. Log in to Service Manager as a system administrator.
  2. Navigate to Tailoring > Database Dictionary.
  3. In File Name, type the table name you want to add. For example, rdbms.
  4. Click the New button .
  5. Click the Fields tab.
  6. Click the New Field/Key button. The Add Field window opens.
  7. In Name, type a field name you want to add. For example, logical.name, which is mandatory for joining the device table.

    Caution The name cannot include any of the following characters: ' / \ [ ] : | < > + = ; , ? *.

  8. In Type, select a type from the list. For example, select character.
  9. Click the Add Field button to save the attribute.
  10. Repeat step 7 to step 9 for each attribute you wish to add. For example, dbinstance and port.
  11. Click the Keys tab.
  12. Place the cursor on the first line of the structure, and click the New Field/Key button. The Add Key window opens.
  13. In Type, select unique from the list.
  14. In Fields list, type the name of a field that you want to use as the unique key. For example, logical.name.
  15. Click Add Key button to save the key.
  16. Click the OKbutton to save attribute changes to the table.

To create a join definition in Service Manager:

  1. Log in to Service Manager as a system administrator.
  2. Navigate to Tailoring > Database Manager.
  3. In Table, type the table name joindefs.
  4. Click the Search button .
  5. In Join Table Name, type a name for the join definition. For example, joinRDBMS.
  6. In File Names, select the names of the tables to join. For example, device and rdbms.
  7. Click Add to save the join definition.

To create an ERD definition in Service Manager:

  1. Log in to Service Manager as a system administrator.
  2. Navigate to Tailoring > Database Manager.
  3. In Table, type the table name erddef.
  4. Click the Search button .
  5. In First Filename, type the name of the first table of the join definition. For example, device.
  6. In Second Filename, type the name of the second table of the join definition. For example, rdbms.
  7. In Relationship type, select a value from the list. For example, One to One.
  8. In Field Names from First Filename, add the unique field name of first table. For example, logical.name.
  9. In Field Names from Second Filename, add the unique field name of the second table. For example, logical.name.
  10. Click the Add button to save the ERD definition.

To create forms for view and bulk update in Service Manager:

Create a view form named configurationItemRDBMS, and a bulk update form named device.rdbms.bulkupdate.

You can create them in Forms Designer based on existing view forms and bulk update forms. To view the form names of an existing CI type in Service Manager, click Configuration Management > Resources > CI Types > Search, and then open the CI type record.

To access Forms Designer in Service Manager, type fd in the command line or go to Tailoring > Forms Designer.

For more information about creating forms in Service Manager, see the Service Manager online help and Tailoring Best Practices.

To add a CI type to Service Manager:

  1. Log in to Service Manager as a system administrator.
  2. Navigate to Configuration Management > Administration > Add New CI Type, and click Next.
  3. In the CI Type Name field, type a descriptive name for the new CI type. For example, RDBMS.
  4. In the CI Type field, type a name for the new CI type. For example, rdbms.
  5. Click Next.
  6. In View Form, type the name of the view form you created for the new CI type. For example, configurationItemRDBMS.
  7. In Bulk Update Form, type the name of the bulk update form you created for the new CI type. For example, device.rdbms.bulkupdate.
  8. Click Next.
  9. In Attribute File, select the table you created for the CI type. For example, rdbms.
  10. Click Next.
  11. Click Next to keep the default setting for Fields Specific to the Attribute File.
  12. In the Join Def Record field, select the join definition you created for this CI type. For example, joinRDBMS.
  13. Click Next.
  14. In the Subtypes field, add necessary subtypes for the CI type. For example, Oracle and SQL Server.
  15. Click Next.
  16. Check the Activate CI Type check box.
  17. Click Next to save the new CI type.