How to create import set table for import data from Splunk

Karthikpasikant
Tera Guru

‎06-01-2023 08:15 PM

Hello everyone,

 

How to create import set table for importing data from Splunk in to ServiceNow cmdb_ci_server table? Any suggestions

 

Thanks,

Karthik

0 Helpfuls
  • 4,893 Views
2 REPLIES 2

Manmohan K
Tera Sage

‎06-01-2023 08:43 PM

Hi @Karthikpasikant ,

 

In the left navigation pane, navigate to System Import Sets > Load Data.

 

and Select Create table

 

Enter the Label to be used for import set

 

 

Table name Populates automatically

 

Select Source of import File based on if you are using data source or files like excel/csv

 

Click Submit.

 

The system displays a success message after importing the file.

0 Helpfuls

Manmohan K
Tera Sage

‎06-01-2023 08:49 PM

An Alternative way  - 

  1. In the navigation pane, search for "System Definition" and click on the "Tables" module.

  2. On the "Tables" page, click on the "New" button to create a new table.

  3. Fill in the following information in the form:

    • Name: Enter a unique name for your Import Set table. The name should follow ServiceNow naming conventions.
    • Label: Provide a descriptive label for the Import Set table.
    • Extends table: Select "Import Set Row" from the dropdown list.

  4. Click on the "Submit" button to create the Import Set table

  5. Once table is created,  Go to configure >table by Right clicking on any column in the table list view

  6. Click on the "New" button in the "Columns" related list to add as many fields as desired for field mapping