search cancel

It it possible to insert CIs from UIM into CA Service Desk Manager?

book

Article ID: 72810

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

MSP UIM customer that will be using UIM to monitor customer's application and network services.
They want to integrate with CA SDM (CMDB) for Configuration Item data. Is this possible?  

The CMDB gateway probe in UIM is not relevant for CA CMDB.
That probe is for Nimsoft CMDB.

Environment

UIM 8.51
sdgtw 1.40
CA Service Desk Manager 14.1, 17.1

Resolution

There is no out of the box integration to import CIs/Devices from UIM into CA Service Desk Manager CMDB.  However, it is possible to do with a little preparation using the CMDB GRLoader tool.


This may be useful if you are using the Service Desk Gateway probe ('sdgtw' probe).  Using this method,  you can now create tickets linked to the correct CI in Service Desk.

This example will bring over: 


In this example, UIM is using an Oracle 12c database server.

CA SDM (CMDB) is using MS SQL 2014.

 

First, identify the database query that will pull the desired information from the UIM database.

For example, this query will work against a MS SQL or Oracle UIM database:

/** 'ci' is required to tell CMDB to load a CI object **/
SELECT 'ci' as object_type, 
/** ip addresses is stored as "alarm_id" in CA CMDB **/
ip as alarm_id, 
/** Tell CMDB these are to be loaded as "Server" CIs **/
'Server' as class, 
name as name,
mac as mac_address,
dns_name as dns_name 
FROM CM_COMPUTER_SYSTEM;

The reason for the aliased columns is to output the data into the CMDB column names.

Once you verify that query returns results, the next step is to prepare to run the GRloader command

At a command prompt:

 1- nxcd java\lib\

 2- C:\PROGRA~2\CA\SERVIC~1\java\lib\>grloader -u ServiceDesk -p password -s http://localhost:8080 -dbdriver oracle.jdbc.OracleDriver -dburl "jdbc:oracle:thin:@databaseHostname:1521/pdborcl.ca.com
" -dbuser CA_UIM -dbpswd password -dbstmt "SELECT 'ci' as object_type, 'Server' as class, ip as alarm_id, name as name,mac as mac_address,dns_name as dns_name FROM CM_COMPUTER_SYSTEM" -a -n -E -e jdbc_error.xml


If successful, you should see output like the following:

GRLoader is smart enough to update an existing CI if it already exists.



Check the output file for errors: jdbc_error.xml


There are many configuration items for GRLoader.  For more information: 


General Resource Loader - GRLoader - CA Service Management - 17.0 - CA Technologies Documentation 



The GRLoader Command - CA Service Management - 14.1 - CA Technologies Documentation 



 



Sample GRLoader command for Oracle:



grloader -u ServiceDesk -p password -s http://localhost:8080 -dbdriver oracle.jdbc.OracleDriver -dburl "jdbc:oracle:thin:@databaseHostname:1521/pdborcl.ca.com
" -dbuser CA_UIM -dbpswd password -dbstmt "SELECT 'ci' as object_type, 'Server' as class, ip as alarm_id, name as name,mac as mac_address,dns_name as dns_name FROM CM_COMPUTER_SYSTEM" -a -n -E -e jdbc_error.xml



 



for MS SQL and MySQL examples, please reference the documentation for GRLoader.



 



GRLoader has the functionality to load the data into a staging area (see TWA options) before loading into the CMDB, which is not shown above.



 



You may script and schedule this command to run as a cron job  or automated task, to get regular updates from UIM

Additional Information

Communities discussion:
https://communities.ca.com/docs/DOC-231177806-tech-tip-importing-ca-uim-devices-into-ca-service-desk-manager-cmdb

Attachments

1558701053187000072810_sktwi1f5rjvs16kdq.jpeg get_app
1558701051419000072810_sktwi1f5rjvs16kdp.jpeg get_app
1558701049379000072810_sktwi1f5rjvs16kdo.jpeg get_app