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.

[wquash]

No - I haven't heard back from anyone. Would you be willing to share the details of your inbound email action?   I'm currently using a CSV file, but it's a completely manual effort so your solution would be an improvement.

[payerle]

Happy to - the information is fairly outdated on the community site.   It was working with Eureka, but since we have updated to Fuji and I have begun testing again to fix my issues, I haven't seen as much success.   That said, I hope this gets you started in the right direction, and if you are able to refine it even more by something I missed, I would love to have that sharing back and forth!

Original document to follow: UPDATED - Use an email with an attachment to create a Data Source, Load Data, and Run Transform

- Note, on Step 11 it has you send an email to instancename@unix.service-now.com.   I haven't done any deep research into this, but adding unix did not work for us with Eureka.   It was written in 2012, so it's likely that it doesn't apply.   Worked fine when I used our instance email.

Prerequisites: Log into your K1000, create a report.   For my example, we were exporting employee computer data into SN cmdb and pairing it with the user account.   Your application may differ.   Specifically we were gathering warranty end date for our customer computers to have in SN.

Once you have your report in KACE, click report schedules (as you likely already have) and then schedule the report to run whenever and have it dump to an email address.   Presumably the address will point to a sub PROD instance that you will move to PROD later on.

In your sub prod instance, you will need: Inbound email action, Transform Map, Transform Script - (not sure about this one, I thought I had one, but it could have been removed hence why it isn't working), Data Source.

(didn't see a [code] hash for my code, so going with a quote, sorry if that isn't correct)

Inbound action:

if (current.getTableName() == "sys_data_source") {   



       current.name = "kace_sn_updater - " + gs.nowDateTime();   

       current.import_set_table_label = "Kace 1000 Import";

       current.import_set_table_name = "u_kace_inventory_import_new";   

       current.type= "File"

       current.format = "CSV";

       current.file_retrieval_method = "Attachment";



       current.update();   



var r = new RESTMessage('KaceUpdater', 'get');   

r.setStringParameter('tableLabel', encodeURIComponent(current.name));   

r.setStringParameter('customDataSource', current.sys_id);   

r.setStringParameter('tableName', current.import_set_table_name);   

r.execute();   

}   

I added the time/date stamp so that I could keep myself straight while testing, not sure if that helps/hurts.   That is pretty much it, I'll dig in a bit more in the next few days into that original article I posted, see if there are other updates, but its fairly straight forward.   I confirmed a while back that having the CSV locally and importing it using my data set and transform map worked, but had some minor issues when automating it.   At least its a step in the right direction, perhaps someone can clean up the work here

[gbcmeb]

Any other development here?

We are just getting started out with ServiceNow and we currently have a big investment in Dell KACE.

They don;t offer any real help with integration (from sales/marketing/tech view) since they seem to view Sow as "the competition".

[HarshTimes]

Hi Mike

I have recently configured the dellkase integration. Let me know your requirement/queries. You can mail me at harshchhajer@gmail.com

- Harsh

[louisth]

Hi Harsh,

We have a customer that request us to integrate Dell Kace K1000 CMDB to ServiceNow.

It seems no API for pulling asset data from Dell Kace.

I'm thinking to use ODBC to access database and import to import set but not sure if it's a good way or not?

Could you share me the detail of your integration?

Best regards,

Kobboon