Import IP ranges into Discovery schedules with import sets

The most efficient method of entering large numbers of IP networks into Discovery schedules is through the use of import sets.

About this task

Common groups of IP addresses, known as ranges, can be used in Advanced Discovery schedules.

The best practice is to use a data source that can be mapped, such as an Excel spreadsheet (network.xls in the following example).
Figure 1. Sample XLS file
Sample XLS file

Procedure

  1. Navigate to System Import Sets > Load Data.
  2. Identify the file or data source that contains the desired information.
  3. Create a new table name, such as ipnetworks.
  4. Select Upload an Excel file and browse to the source file.
  5. Click Go to import the file.
    Figure 2. Data Source
  6. Navigate to System Import Sets > Create Transform Map and map the items in the Excel spreadsheet to the fields of the CMDB in the target table Discovery IP Range [discovery_range_item] table.
  7. Give the Transform Map a unique and descriptive name.
    Figure 3. Table Transform Map 1
  8. Submit the form, and then click New in the Field Maps Related List.
  9. Map the fields from the Excel spreadsheet to the fields in the Discovery IP Range (discovery_range_item) table using the following field names:
    • RangeName to Discovery Range
    • IP to Network IP
    • mask to Network Mask (or Bits)
    • type to Type. Note that the type field is case sensitive.
    The display names are different from the actual field names that appear in the Field Maps list.
    Figure 4. Table Transform Map 2
  10. Click the Mapping Assist Related Link and use the lists that appear to resolve the fields between the table and the data source (the Excel spreadsheet in this example).
    Figure 5. Mapping Assist

    This produces the complete map between the data source and the fields to populate in the CMDB.

  11. Click Save.

    The view returns to the Table Transform Map form.

  12. Click Transform in the Related Links to move the data into the proper fields in the Discovery IP Range (discovery_range_item) table.

    The imported IP ranges are available now for use in any advanced Discovery schedule.