How to import a large number of IP addresses into a dynamic list

  • 7017640
  • 24-May-2016
  • 24-May-2016

Environment

NetIQ Sentinel Server 7.x

Situation

You can only add one entry at a time to a dynamic list which makes it very time consuming if 100 or a 1000 IP addresses need to be added. 

Resolution

I will assume you already have a dynamic list created. To confirm go to the Sentinel control panel > configuration tab > configuration > dynamic list. If you don't currently have a dynamic list then create one by clicking the add button at the top left corner of the dynamic lists box, name it something like IP_list. 


1. Create your import file with the list of IP addresses. 

Note: This is done by you, not in Sentinel.  


The format of the file you are creating should look like the following depending on whether you want to the IP addresses to be persistent, non-persistent, or a mix.  The values should be separated by commas.  The first value specifies whether the IP address is persistent or non-persistent. 1 meaning persistent and 0 meaning non-persistent. If the first value is 1 than the second value should always be 0 meaning there is no expiration for the IP address.  If the first value is 0 than the second value will always be an EPOCH time value which is your expires date.  You can easily get the EPOCH time stamp by using a free online EPOCH convertor.  If you don't care about the IP address expiration date then simply use the 1,0,IP_Address format for all of you IP's. 

1,0,10.0.0.102
1,0,10.0.0.103
1,0,10.0.0.104
0,1464125210951,10.0.0.100
0,1464125210951,10.0.0.101
0,1464125210951,10.9.9.9
0,1464125330966,10.5.5.5
0,1464125330966,10.6.6.6


2. Once your list is complete simply do a copy and paste into your dynamic list file, than save the file. The dynamic lists files are located at /var/opt/novell/sentinel/data/map_data.

3. Next go to the Sentinel control panel > configuration tab > configuration > dynamic list.

4. Highlight and view your dynamic list, all of the entries should be in the list.