Bulk data import to CMDB CI tables

othomas1
Kilo Guru

I am not sure if this is the correct forum, but would anyone be able to point me in the right direction to get some answers to the below question:

Does ServiceNow allow for bulk data imports into the CMDB CI tables? I am wondering if the system allows for the ability to bulk import data directly into CMDB CI tables in order to facilitate the loading of conceptual data.

1 ACCEPTED SOLUTION

Prateek kumar
Mega Sage

Have you checked about import sets in servicenow

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/reference/import-sets-landing-page.html


Please mark my response as correct and helpful if it helped solved your question.
-Thanks

View solution in original post

13 REPLIES 13

Community Alums
Not applicable
Hi, We had implemented this solution for a client where some users needed to bulk update cmdb regularly. We created an inbound action to check the subject and weather the user was a part of the specific group. You need to verify the format of Excel of the attached Excel. Then use the transform Map scripts to run the transform programmatically.. Let me know in case of any queries

Hi Hardit,

 

could you plz write the steps by step process including the script here.

i am new to servicnow i need to impliment bulk creation of CI's

 

JF Muller
ServiceNow Employee
ServiceNow Employee

To follow up on all the responses below, a very important point!

 Be sure to use CMDB APIs (CMDB SDK) in your import set script.

This particular API has been implemented to create, update, and read operations on the CMDB. 

It uses the Identification and Reconciliation framework to minimize creation of duplicate CIs and to reconcile CI attributes by only accepting information from authorized data sources when updating the CMDB.

 

For more information, please read: 

https://docs.servicenow.com/bundle/madrid-servicenow-platform/page/product/configuration-management/concept/c_CMDBIdentifyandReconcile.html

Regards

Jef

Sumathi Iyengar
Tera Contributor

I'm trying to bulk-correct a field value in cmdb_ci.list table., which is incorrectly set at the time of discovery. 

I want to use the coalesce approach using the IP address field as the pivot field.

However in the create Transform Map stage, the "Target table" dropdown does not contain the "cmdb_ci" table. how do I make the correction?
Appreciate any inputs