Like many others, I also hate administrative tasks. One of these tasks that comes back again and again is IP documentation. To make my life easier and probably that of others :-), I decided to go testing with IP management software. After some googling I found IPPlan, this tool which looks very promising, can do everything I need. It manages my IP addresses and gives me a quick overview of the status, it also gives me the possibility to “poll” addresses and automatically find used ones. This feature is great, except for one little thing, you have to create a new file with all the subnets you like to poll. If you are a greedy bastard like me, you like to have all subnets polled. We have over 500 subnets and after adding them to IPPlan I wasn’t very pleased with the idea of adding them manually to the list.
Luckily for me, it is very easy to make a export from IPPlan with all the subnets, unfortunately this export is not well formatted for the polling list. The exported list will look like this:
10.10.4.0 Client-Vlan4 255.255.255.0
10.10.5.0 Client-Vlan5 255.255.255.0
10.10.6.0 Client-Vlan6 255.255.255.0
The import list should look like this:
What I did is created a very small and simple vbscript, which will make this transition for me.
You can start the vbscript as follow.
cscript ipplantopoller.vbs exportfromipplan.txt importtopoller.txt
As you maybe have already guessed the exportfromipplan.txt is the exported list and the importtopoller.txt is created by the script.
You can download the script below and if you have any comments or questions please let me know.by