Dell KACE Integration

[wquash]

Does anyone have experience integrating Dell KACE with ServiceNow?   I'd like to import the KACE data on a regular basis for asset and change management.

[payerle]

Hi Harsh,

I too would like to see how you integrated the two together.   Can you please share with me as well?

[HarshTimes]

Hi Kobboon/Matthew

Yes you are correct, currently there is no API that connect ServiceNow - Dell Kace. I made the JDBC connection to connect ServiceNow to Dell Kace tables.

To get the details of the hardware data you will be require to connect the MACHINE table in Dell Kace to ServiceNow.

To get the details of the software data you will be require to connect the SOFTWARE table in Dell Kace to ServiceNow.

you have to configure the data source with below details

- type - JDBC

- format - MYSQL

- database name - ORG1(default).

- database port - 3306(default)

- User name

- password

- server : IP address of server where dellkace is setup.

- dellkase table name to connect - machine/software

- You will be require to create a import set table for hardware and software . This will serve as the staging area where hardware and software records will reside.

- Also, you will be required to create the corresponding transform map to populate the records in asset tables.For hardware records target table would be CMDB computer table and for software it is software installation table.

- You will be required to add some logic in the hardware transform map to find the correct CI to update/insert and to create the correct model.

- To integrate hardware disk data is not straight forward. You will be required to create the database view in DellKace and then connect that to servicenow. This is the little trickier part.

- To get the software installed on details you will be required to connect to the Software_JT table in dellkace.

I hope this will give you some idea to connect to DellKace.Please mail me if you require any further help on it.

Thanks

Harsh

[louisth]

Hi Harsh,

I really appreciate your sharing. If I got a deal, I would follow your guidance.

Thank you for helpful information.

Best regards,

Kobboon

[payerle]

Hey Harsh,

I was able to set up some of this, and am working on the JDBC connection.   Right now it attempts to try to hit our KACE server and ultimately times out.   I am using my credentials for the KACE server, but I'm not sure I have all of the correct fields filled out.

Anyway you can private message me some more details?   Would love to get this setup in our environment.   Thank you!

[HarshTimes]

Hi Payerele

Have you setup the MID Server? If yes, The MIDserver you are using should not be part of a cluster.

-Harsh