This documentation supports the 21.3 version of BMC Helix CMDB.To view an earlier version, select the version from the Product version menu.

Exporting a service model

As a configuration manager, you can monitor your IT environment by tracking the changes that occurred in a service model.

You can create an Atrium Integrator Spoon job to generate a report about the changes made to a service model.

The output generated by the Spoon job is a text file that you must manually export to a spreadsheet format. You can also specify the columns and their order for the spreadsheet layout.

You can automate this task by setting a schedule for the job and generating reports at regular intervals. For more information about scheduling Atrium Integrator jobs, see Creating-an-Atrium-Integrator-job-to-import-data.

Before you begin

Make sure that you have the required permission to create an Atrium Integrator Spoon job.

Related topics

Permissions-to-access-Atrium-Integrator

Creating-a-job-in-Atrium-Integrator-Spoon

Adding intermediate steps to Atrium Integrator job

Transferring-data-from-external-data-stores-to-BMC-Helix-CMDB

To export a service model

The following image represents the steps that must be added in the transformation:
sample ktr for graphwalk_report.png

  1. Log in to Atrium Integrator Spoon. 
  2. Create a new transformation and add the following steps:
    1. Define REST URL—Add a step to define the constants and enter the following information in the fields:
      Step 1_Define REST URL.png
    2. Get AR JWT Token—Add the REST Client step and specify the AR JWT token authentication details.
      Step 2_REST Client.png
    3. Prefix Token—Add the Modified JavaScript Value step and define the script values.
      Step 3_Prefix Token.png

    4. REST Client CMDB_GraphWalk_API—Add the REST Client step and provide the Graphwalk REST API endpoint URL and the parameters. 
      This step generates a JSON file.
      Step 4_CMDB GraphWalk_API.png
    5. Read GraphWalk Output—Add a JSON Input step that reads the JSON file generated in Step d.
      Step 5_Read GraphWalk Output.png
    6. CIRelationshipReport—Add a Microsoft Excel Output step and define the columns that the report must create.
      This step uses the information from the JSON Input step and generates the report about the service model.
      Step 6_CI relationship Output report.png
  3. Run the transformation.
    The following image shows a sample report with the columns class name, Instanceid, and datasetid:Sample report view.png
  4. (Optional) To automate the report generation, open the transformation in the Atrium Integrator console in CMDB Portal and set a schedule.

Alternatively, you can use the following sample transformation, modify it for your environment, and run it: SampleGraphWalkCMDBRelReport.ktr.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*