This documentation supports the 21.05 version of BMC Helix CMDB.

To view an earlier version, select the version from the Product version menu

Working with CMDB utilities

As an administrator, you can use different CMDB utilities to perform specific tasks, such as detecting corrupted data in the Common Data Model (CDM), updating the relationships in the CDM, and investigating data issues. The CMDB utilities are run from the command line. 

CMDB provides the commonly used CMDB utilities in a zip file that is available for download from the  BMC Electronic Product Distribution Open link  (EPD) site (Support ID required).

To download CMDB Utilities

  1. Log in to BMC Electronic Product Distribution Open link .
  2. In the search field, enter BMC Helix ITSM.
  3. In the search results, select <version yy.vv> > Product > BMC Helix CMDB Utilities Version <yy.vv>
    For example, 21.05 > Product > BMC Helix CMDB Utilities Version 21.05.00

After downloading the CMDB Utilities zip file, extract the files to your computer. The CMDB Utilities folder contains the following folders:

  • Common 
  • Linux
  • Windows

Depending on the Operating System that you are using, open the folder to access the utilities. The Common folder contains utilities that run on any Operating System.

If you are a BMC Helix Subscriber, connect to a BMC network to run the utilities. See,  BMC Helix Client Gateway connectivity Open link .

The following table lists the utilities and the corresponding documentation about using the utility:

Utility namePurposeReference
CDMChecker

Detects invalid customization in the Common Data Model (CDM) and CDM corruption.

Troubleshooting issues when using the CDMChecker tool

CMDBArchiveArchives the extensions that you made to the Common Data Model.

Archiving CMDB data

CMDBDiag

Checks for invalid data in CMDB and helps correct it.

Verifying your data model

CMDBDriver

Helps purge orphaned CIs in bulk from CMDB.

Removing duplicate computer systems from the CMDB

BMC CMDB: Knowledge Article 000361750

DataAnalyzerTool

Performs data analysis and identifies data inconsistencies in any CMDB dataset such as the following:

  • Duplicate CIs

  • Orphan CI Instances

  • Soft Deleted CIs

  • Non-reconciled CIs/Relationship CI instances

  • Classes without RE Identification rule

Using CMDB Data Analyzer to investigate CMDB data issues

NE Simulator

Simulates the normalization results before running the normalization process and improves the number of CIs that are normalized and the quality of data created in the Product Catalog.

Simulating normalization by using the NE Simulator utility

RE Export JobExports the reconciliation job definitions to an ARX file to help migrate the job definitions from one server to another.Exporting reconciliation job definitions
CDM2HTMLConverts the Common Data Model diagram to an HTML format.Generating Help for the data model by using the cdm2html utility
Test_treedumpObtains a list of the web services that are published to the Web Services Registry.Accessing BMC Helix CMDB web services
atriumwsutil

Modifies, packages, and deploys the configurations in security properties for CMDB Web Services.

Setting up security for web services
CDM Denormalization (Applicable only for Flex UI)

Minimizes the number of tables or forms in which different but related pieces of CI data are stored and optimizes the read performance of the database.

Important: This utility can be accessed only if you are using a browser that supports the Flash-based BMC CMDB UI.

Running the CDM Denormalization utility

isVirtual Mapper (Not applicable for BMC Helix Subscriber)

Moves data associated with isVirtual_old attributes to isVirtual attribute. Use this utility if you have upgraded from BMC CMDB versions 19.02 and earlier to BMC CMDB version 19.08 and later.Moving data from isVirtual_old attribute to isVirtual attribute
Was this page helpful? Yes No Submitting... Thank you

Comments