Updating the BMC Helix CMDB database with BMC Client Management data

This topic discusses how data from BMC Client Management is updated to the BMC Helix CMDB database.

An administrator can use BMC Client Management jobs available in the Atrium Integrator to update the BMC Helix CMDB database. A BMC Client Management job is a tool that collects data from BMC Client Management and transfers it to the BMC Helix CMDB database.

The BMC Atrium Integrator provides four BMC Client Management jobs. These BMC Client Management jobs are about adding or deleting software or hardware information into the BMC Helix CMDB database.

BMC Client Management jobs in BMC Atrium Integrator console

They are 4 jobs available in Atrium Integrator Console:

  • BCM_Hardware_Delete
  • BCM_Hardware_Input
  • BCM_Software_Delete
  • BCM_Software_Input

BMC Client Management jobs in BMC Atrium Core console

They are 3 jobs available in Atrium Core Console (2 jobs are available in Reconciliation tab and 1 job in Normalization tab).

  • BCM - Identification and Merge: This job updates entries in the final dataset using data from temp dataset. It also sets flag for data to be deleted.
  • BCM – Purge: This job deletes data from the dataset.
  • BCM - Normalize CM Dataset: This job normalizes the data in the final dataset to use the same normalized name and format. For example, all dates are normalized to use the date format.

 

To verify data in the BMC Helix CMDB database

In the BMC Helix CMDB database, there are different tables and views and it is not easy to find the correct data to check.

Note that BMC Client Management uses a value set in the DatasetID field.

The DatasetID field can have two different values. BMC Client Management can use one of these values:

  • BMC.FP.ASSETCORE: It contains all the data from BMC Client Management after to launch the jobs available in Atrium Integrator Console (Hardware and Software)
  • BMC.ASSET: It contains all the data from BMC.FP.ASSETCORE after to launch the jobs available in Atrium Core Console (Identification & Merge /Purge)

Database mapping between BMC Client Management and BMC Helix CMDB database views

Transformation Name

BCM CMDB View

Atrium View

BCM_Hardware_ComputerSystem

Atrium_CMDB_ComputerSystem

BMC.CORE BMC_ComputerSystem

BCM_Hardware_ComputerSystem_Delete

Atrium_CMDB_ComputerSystem 

BMC.CORE BMC_ComputerSystem

BCM_Hardware_IPendpoint  

Atrium_CMDB_NetworkInterface

BMC.CORE BMC_IPEndpoint

BCM_Hardware_IPendpoint_Delete

Atrium_CMDB_NetworkInterface

BMC.CORE BMC_IPEndpoint

BCM_Hardware_OperatingSystem

Atrium_CMDB_OperatingSystem

BMC.CORE BMC_OperatingSystem

BCM_Hardware_OperatingSystem_Delete

Atrium_CMDB_OperatingSystem

BMC.CORE BMC_OperatingSystem

BCM_Hardware_Processor

Atrium_CMDB_Processor

BMC.CORE BMC_Processor

BCM_Hardware_Processor_Delete

Atrium_CMDB_Processor

BMC.CORE BMC_Processor

BCM_Hardware_Relation_ComputerSystem_ComputerSystem

V_CMDB_NetworkRelation

BMC.CORE BMC_Dependency

BCM_Software_ComputerSystem

Atrium_CMDB_ComputerSystem

BMC.CORE BMC_ComputerSystem

BCM_Software_ComputerSystem_Delete

Atrium_CMDB_ComputerSystem

BMC.CORE BMC_ComputerSystem

BCM_Software_Product

Atrium_CMDB_Software

BMC.CORE BMC_Product

BCM_Software_Relation_ComputerSystem_Product

Atrium_CMDB_Software

BMC.CORE BMC_HostedSystemComponents

Attribute mapping between BMC Client Management and BMC Helix CMDB views

Transformation Name                             

      BCM CMDB View       

           Atrium View

BCM_Hardware_ComputerSystem

 Atrium_CMDB_ComputerSystem

BMC.CORE BMC_ComputerSystem

Key

FPIntegrationId 

DeviceID

Fields

Name 

DeviceName

Description

Description

 

ShortDescription

ShortDescription

 

ManufacturerName

ManufacturerName

 

Model

ModelName

 

SerialNumber

SerialNumber

 

Domain

Domain

 

HostName

HostName

 

TotalPhysicalMemory

PhysicalMemory

 

isVirtual

IsVirtual

 

OwnerName

PrimaryUserLogin

 

CITag

AssetTag

 

TokenId

GenTokenID

 

Category

Category

 

Type

Type

 

Item

Item

 

NameFormat

NameFormat

 

VirtualSystemType

GenVirtualSystemType

 

PrimaryCapability

PrimaryCapability

 

CapabilityList

PrimaryCapability

 


BCM_Hardware_ComputerSystem_Delete

Atrium_CMDB_ComputerSystem

BMC.CORE BMC_ComputerSystem

Key

FPIntegrationId

FPIntegrationId

Fields

MarkAsDeleted  

DELETE_STATUS

BCM_Hardware_Ipendpoint

Atrium_CMDB_NetworkInterface

BMC.CORE BMC_IPEndpoint

Key

FPIntegrationId 

GenNetworkInterfaceID

Fields

Name

IPAddress

NameFormat

NameFormat

 

Address

IPAddress

 

ShortDescription

ShortDescription

 

Description

Description

 

FPAssemblyId

DeviceID

 

Category

Category

 

Type

Type

 

Item

Item

 

BCM_Hardware_IPendpoint_Delete  

Atrium_CMDB_NetworkInterface

BMC.CORE BMC_IPEndpoint

Key      

FPIntegrationId 

FPIntegrationId

Fields

MarkAsDeleted  

DELETE_STATUS

BCM_Hardware_OperatingSystem

Atrium_CMDB_OperatingSystem

BMC.CORE BMC_OperatingSystem

Key

FPIntegrationId 

InventoryID

Fields      

Name

OSName

Description  

Description  

 

ShortDescription 

ShortDescription 

 

ServicePack  

ServicePack  

 

VersionNumber  

VersionNumber  

 

BuildNumber  

BuildNumber  

 

FPAssemblyId  

DeviceID

 

Category

Category

 

Type   

Type   

 

Item   

Item   

 

NameFormat  

NameFormat  

 

BCM_Hardware_OperatingSystem

Atrium_CMDB_OperatingSystem

BMC.CORE BMC_
HostedSystemComponents

Key

Source.InstanceId

srcInstanceID

Destination.InstanceId

destInstanceID

 

Fields      

Name   

BMCNAME

BCM_Hardware_OperatingSystem_Delete    

Atrium_CMDB_OperatingSystem

BMC.CORE BMC_OperatingSystem

Key      

FPIntegrationId

FPIntegrationId

BCM_Hardware_Processor

Atrium_CMDB_Processor

BMC.CORE BMC_Processor

Key      

FPIntegrationId

GenInventoryID

Fields      

Name   

InstanceName

Description  

Description  

 

ShortDescription 

ShortDescription 

 

ManufacturerName 

ManufacturerName 

 

FPAssemblyId  

DeviceID

 

Category  

Category  

 

Type   

Type   

 

Model

Name

 

Item   

Item   

 

NumberOfLogicalProcessors

NumberOfLogicalProcessors

 

MaxClockSpeed

MaxClockSpeed

 

NameFormat  

NameFormat  

 

ProcessorFamily  

GenProcessorFamily

 

BCM_Hardware_Processor

Atrium_CMDB_Processor

BMC.CORE BMC_
HostedSystemComponents

Key

Source.InstanceId

srcInstanceID

Destination.InstanceId

destInstanceID

 

Fields      

Name   

BMCNAME

BCM_Hardware_Processor_Delete

Atrium_CMDB_Processor

BMC.CORE BMC_Processor

Key      

FPIntegrationId

FPIntegrationId

Fields      

MarkAsDeleted  

DELETE_STATUS

BCM_Hardware_Relation_
ComputerSystem_ComputerSystem

V_CMDB_NetworkRelation

BMC.CORE BMC_Dependency

Key

Source.InstanceId

srcInstanceID

Destination.InstanceId

destInstanceID

 

Fields      

Name   

BMCNAME

BCM_Software_ComputerSystem

Atrium_CMDB_ComputerSystem

BMC.CORE BMC_ComputerSystem

Key      

FPIntegrationId 

DeviceID

Fields      

Name   

DeviceName

Description  

Description  

 

ShortDescription 

ShortDescription 

 

ManufacturerName 

ManufacturerName 

 

Model   

ModelName

 

SerialNumber  

SerialNumber  

 

Domain   

Domain   

 

HostName

HostName

 

TotalPhysicalMemory

PhysicalMemory

 

isVirtual

IsVirtual

 

OwnerName  

PrimaryUserLogin

 

CITag

AssetTag

 

TokenId   

GenTokenID

 

Category

Category

 

Type   

Type   

 

Item

Item

 

NameFormat

NameFormat

 

VirtualSystemType

GenVirtualSystemType

 

PrimaryCapability

PrimaryCapability

 

CapabilityList

PrimaryCapability

 

BCM_Software_ComputerSystem_Delete 

Atrium_CMDB_ComputerSystem

BMC.CORE BMC_ComputerSystem

Key      

FPIntegrationId

FPIntegrationId

Fields      

MarkAsDeleted  

DELETE_STATUS

BCM_Software_Product                                  

Atrium_CMDB_Software           

BMC.CORE BMC_Product

Key      

FPIntegrationId

InventoryID

Fields      

Name   

Name   

ManufacturerName 

ManufacturerName 

 

Model   

Model   

 

MarketVersion  

MarketVersion  

 

VersionNumber

VersionNumber

 

Category

Category

 

Type

Type

 

Item

Item

 

NameFormat

NameFormat

 

BCM_Software_Product                        

Atrium_CMDB_Software     

BMC.CORE BMC_
HostedSystemComponents

Key

Source.InstanceId

srcInstanceID

Destination.InstanceId

destInstanceID

 

Fields      

Name   

BMCNAME

BCM_Software_Relation_
ComputerSystem_Product

Atrium_CMDB_Software           

BMC.CORE BMC_
HostedSystemComponents

Key

Source.InstanceId

srcInstanceID

Destination.InstanceId

destInstanceID

 

Fields      

Name   

BMCNAME

To add data from BMC Client Management into the BMC Helix CMDB database

  1. Get the data available in BMC Client Management view and put in Atrium DB with the input jobs.
  2. Launch the Input Jobs (hardware and software).
    The jobs update the different views with all the fields in Dataset temporary (BMC.FP.ASSET)
  3. Launch the Reconciliation and Merge Job. 
    The job update the different views with all the fields in Dataset final (BMC.ASSET)

To delete data from BMC Client Management into the BMC Helix CMDB database


  1. Launch the Delete Jobs (hardware and software).
    The jobs update the different views with the field MarkAsDeleted = 1 in Dataset temporary (BMC.FP.ASSET).
  2. Launch the Reconciliation and Merge Job.
    The job updates the different views with the field MarkAsDeleted = 1 in Dataset final (BMC.ASSET)
  3. Launch the Purge Job.
    The job cleans all the different dataset.
Was this page helpful? Yes No Submitting... Thank you

Comments