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?

 

find_real_file.png

From: Importing data

 

find_real_file.png

From: No-Code Application Development

 

Loading::. CMDB Manufacturer

 

01. System Import Sets

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

find_real_file.png

 

01.A Type 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

Hardware Model [cmdb_hardware_product_model]

 

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

Best Practices for CMDB Data Integration

CMDB Data Model

Populate the CMDB

CMDB Schema Model

Discovery

Tables and classes - LIST

Making import sets created for Import Set API calls "Asynchronous" to prevent Synchronous transform,...

 

 find_real_file.png

 

Architecture typeType of application architecture.
  • Client Server: Application structure that divides tasks between the service providers and service requesters.
  • N-Tier: A multi-layered architecture where presentation, processing, and data management are physically separated.
  • Web-based: Applications accessed over a network connection.
  • Other: Any other type of architecture.
  • Platform Host: A hardware or a software that hosts the business application.
  • Platform Application: Application that runs on a platform and can be associated to a host.

    In this case, the business application relies on the platform for standard operations such as development tools, execution services, data services, and so on.

Business Application

 

 

 

data sources types are:

  • CSV
  • JDBC
  • FTP
  • HTTP
  • XML

 

 

image

summary

Populate and maintain your CMDB with ServiceNow Discovery

Importing data

Export stopped due to excessive size. Use CSV for a complete export

Comments
User674366
Tera Explorer

Thanks for sharing this.

Version history
Last update:
‎05-15-2018 12:09 PM
Updated by: