Announcing the Global SNUG Board of Directors. Learn more here

Help
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tiagomacul
Mega Sage
Mega Sage

CMDB

How to import data? Como importar dados?

 

01. System Import Sets

https://<instance>.service-now.com/nav_to.do?uri=/create_import_set.do

find_real_file.png

 

01.A Tyoe Label:: Will be create a table

01.B Select you file:  Your Excel file name

01.C Type Sheet number:: The number of sheet what you'll work in at

01.D Type Header row::. The field names

 

02. Create Transformation Map

https://<intancename>.service-now.com/nav_to.do?uri=/sys_transform_map.do%3Fsys_id%3D-1%26sysparm_stack%3Dsys_transform_map_list.do

>> System Import set > Create Transform Map

 

find_real_file.png

 

02.A. Type Nane

02.B Select Source Table

find_real_file.png

02.C Select Target Table

find_real_file.png

02.D Submit

 

find_real_file.png

 

 

03. Auto Map Matching Fields

Using this Excel attached, Service Now will generate your MAP for YOU.

 find_real_file.png

 

find_real_file.png

 

 

04. Run Transform

>> System Import Sets > Run Transform

https://<intance>.service-now.com/nav_to.do?uri=/run_import.do

 

find_real_file.png

 

04.A Click on Transform Button

find_real_file.png

 

 04.B Final Results, check your table.

find_real_file.png

CMDB Design Guidance

Options to populate the CMDB

Improving Configuration Item Data Quality

 

The Who, What, When, Where, and Why for Asset Management Training

 Best Practices for CMDB Data Integration

 

 

 

image

summary

Populate and maintain your CMDB with ServiceNow Discovery

Data Import Object Types

Create manufacturer and vendor codes (docs)

Comments
User674366
Tera Explorer

Thanks for sharing this.

Version history
Last update:
yesterday
Updated by:
Contributors