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

image2017-7-13 11:49:41.png

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.

image2017-7-13 11:51:54.png

image2017-7-13 11:52:35.png

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

image2017-7-13 12:2:17.png

Get the data available in BMC Client Management view and put in Atrium DB with the input jobs.
Launch the Input Jobs (hardware and software).
The jobs update the different views with all the fields in Dataset temporary (BMC.FP.ASSET)
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

image2017-7-13 12:3:50.png

Launch the Delete Jobs (hardware and software).
The jobs update the different views with the field MarkAsDeleted = 1 in Dataset temporary (BMC.FP.ASSET).
Launch the Reconciliation and Merge Job.
The job updates the different views with the field MarkAsDeleted = 1 in Dataset final (BMC.ASSET)
Launch the Purge Job.
The job cleans all the different dataset.