Integration of AssetCore 11.6 and CMDB 8.1 on Windows
Mike Reider, August 2013
- Download Integration installer here
- Move this installer to the system where the CMDB is installed. In this example, I have 2 windows servers. One server has the AssetCore 11.6 installed, 2nd server has ARS 8.1 installed including CMDB and ITSM 8.1
- Run the installer on CMDB box,
provide AssetCore DB connection details
Database Server or IP: hostname of the AssetCore server
System administrator User: facdbuser (default SQL user account when installing FPAC)
System administrator password: pw provided during install
Database Name/Service: facdb
database port: 1433 or whatever the SQL port # is
(make sure you can Telnet from your CMDB server to the AssetCore server via the DB port (1433, 1521, etc), if you cant telnet to 1433, do the following:
- On the AssetCore box, open SQL Config manager, Network Config, open the TCP/IP properties
Enable 1433 IP setting
Make sure SQL is configured for Remote Connections and Windows Firewall isn’t blocking incoming requests
Enter Remedy login
Click Install
2. Config File Copy
Once installed, go to the CMDB box, open C:\Program Files (x86)\BMC Software\AssetCoreCMDBIntegration\assetcorecmdbintegration\config
Copy the FPAssetCoreConfig.properties file to C:\
3. SQL Configuration
On the AssetCore server, go to the Master install folder, open Vision64Database.ini file located in \config directory
Open the file and locate User= line, get the name of the database user. This is the SQLDBOWNER value.
On the AssetCore box, open SQL Management Studio,
Get the table prefix for AssetCore DB (facdb)
This is your SQLSCHEMAPREFIX
Open the FPAssetCoreConfig.properties file on the CMDB box, and update SQLDBOWNER and SQLSCHEMAPREFIX variables. Make sure there is a dot at end of SQLSCHEMAPREFIX value.
4. Group ID of Device Group
In order to integrate CMDB with discovered Assets in AssetCore, you need to get the Group ID of the Device Group folder in AssetCore. In this example, I am using ‘All Devices’ group to import my devices into CMDB
Open SQL Management Studio on AssetCore server, do a query on facdb table, replace GroupName with whatever Device Group you want to get the ID for.
On the CMDB box, update the FPAssetCoreConfig.properties with the HARDWARE_GROUPIDparameter, insert the ID from the SQL query.
5. CMDB Merge
Go to your CMDB screen, select Reconciliation, select the FP Asset Core Identification and Merge, Execute this job.
The reconciliation job will merge all AssetCore assets into BMC.ASSET dataset.