Updating the BMC Atrium CMDB database with BMC Client Management data
This topic discusses how data from BMC Client Management is updated to the BMC Atrium CMDB database.
An administrator can use BMC Client Management jobs available in the Atrium Integrator to update the BMC Atrium CMDB database. A BMC Client Management job is a tool that collects data from BMC Client Management and transfers it to the BMC Atrium 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 Atrium CMDB database.
The following topics are provided:
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.
Verifying data in the BMC Atrium CMDB database
In the BMC Atrium CMDB database, there are different tables and views and it is not easy to find the correct data to check.
Note that BCM uses a value set in the DatasetID
field.
The DatasetID
field can have two different values. BCM can use one of these values:
BMC.FP.
ASSETCORE: It contains all the data from BCM after to launch the jobs available in Atrium Integrator Console (Hardware and Software)BMC.
ASSET: It contains all the data fromBMC.FP.ASSETCORE
after to launch the jobs available in Atrium Core Console (Identification & Merge /Purge)
Database mapping between BCM and Atrium 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 BCM and Atrium 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 | |
| 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_ |
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_ |
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_ | 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_ |
Key | Source.InstanceId | srcInstanceID |
Destination.InstanceId | destInstanceID | |
Fields | Name | BMCNAME |
BCM_Software_Relation_ | Atrium_CMDB_Software | BMC.CORE BMC_ |
Key | Source.InstanceId | srcInstanceID |
Destination.InstanceId | destInstanceID | |
Fields | Name | BMCNAME |
Adding data from BCM into the Atrium CMDB database
- Get the data available in BCM 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
)
Deleting data from BCM into the Atrium CMDB database
- 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 update the different views with the field MarkAsDeleted = 1 in Dataset final (BMC.ASSET
) - Launch the Purge Job.
The job clean all the different dataset.
Comments
Log in or register to comment.