Discovering Individual IPs in a IP range list (not Range Sets)

[sayub]

i have a list of IPs to discover. It is not a IP Range set, they have provided a list of about 500 targets to discover initally in an excel column (just IPs not mask information):

IP Address

xx.xx.x.xx

xx.xx.x.xx

xx.xx.x.xx

xx.xx.x.xx

xx.xx.x.xx

Based on my understanding we can only import a IP range set so I envision one of two options to get these IPs into ServiceNow

1.             Turn the format into quick range format (xx.xx.x.xx , xx.xx.x.xx ..) í  then make a range which will map these entries (records) to Discovery IP Range (discovery_range_item) table.

2.             Or the only way is by importing the list as a range sets which writes information to Discovery Range Set (discovery_range) Table. But for that I will have to changes it to the format below based on ServiceNow documentation but I don't have the 'Mask column' info in the original list as shown above:

Range Set import Format based on documentation is:

                                                                                                                                                                    RangeName |   IP   |   mask   |   type

So with the information I have (1) seems to be the only solution to convert into quick range format and create a range? Or is there a way to import a IP range list as well like we have way to import Range sets list.

[Marlos]

Hi Sheikh,

Have you tried to use the quick range? There you can create a comma-separated list of individual IP addresses:

[sayub · Accepted solution]

Ya and thats what i am doing it right now, as i mentioned in my post the quick range solutions as option (1). I just wanted to see if there was another way to import. But based on my research and a your response i believe creating a comma delimted format and use that in the 'quick range --> Make range' is the best option i suppose.

Sheikh

[Rajanmehta]

hi Sheikh,

Yes you are doing it correct. That's the only solution I am aware of too. I am doing it same way. I use Excel functions to append comma in front of IP address and then copy paste it.

Thanks,

Rajan Mehta

[sayub]

Great, thats exactly how i am doing it as well.

Thanks so much guys.