Importing IP Ranges

[doug_schulze]

Seems allot of folks are looking for easier ways to bring in tons of IP ranges into their discoveries without having to manually enter hundreds of IP networks. Well Service-now.com to the continued rescue with an already existing product technology, Import Sets.

First, gather the list of IP ranges from the customer and have them properly formatted. You want   the IPs in a network/subnet format and identify what location or grouping they want to manage them by.

Next, identify the target ServiceNow table. This is going to be important the first

time so you can find exactly where the import of data is going to go. There is an OOB range set that you can use for reference.

As you see below, it's going to be the discovery Range Item table

Now that you know where the records are going, it's time to clean up your data and get it ready for import. In an excel sheet, you need a minimum Network, Subnet, Type and Range (set) Name.

Once the data is properly formatted, then perform a standard data import and transform.

Message was edited by: Doug Schulze

[manita_anand]

hi,

can you tell me what is the Name field mapped to ?

as in your excel i see only 4 columns and nothing mentioned for u_name.

[glennpinto]

Here is the documentation on the import, but basically you just need ip, mask, type and name of the range. The name is how it will be referenced from a schedule so it is a subjective name that should be descriptive of the ip/mask.

Import IP ranges into Discovery schedules with import sets

[manita_anand]

thanks!

[tlsimmons88]

If anyone is looking for the current URL to the official docs on how to import this data I found it here.

(The link from @glennpinto is broken).

https://docs.servicenow.com/bundle/paris-it-operations-management/page/product/discovery/reference/discovery-ip-address-configuration.html#t_ImportIPRanges