You are running out of budget this moment but you really need an IPAM system to manage your IPs (IPv4 and v6) and leave away the old excel which you worked for a long time. For me using or not an IPAM system will depend of the environment size, it’s need to be reasonable and rational.
This free version supports 2000 hosts and multi-discovery, so not bad for a free product
The requirements to run this version from Infoblox are low (1vcpu, 1GB memory, 50GB), and it’s supported in VMware Player, VMware Workstation or VMware Fusion
I’ve tried convert strait away to vSphere 6 but didn’t work, so i started my journey until get this working, and i did it.
First we need to download the free copy, unzipped and use vCenter Converter to convert the image to our environment and play it.
Virtual Machine Properties
These are properties i used to setup my IPAM Express
Since IPAM Express doesn’t support a fixed IP, you need get a DHCP working for that subnet
After register you will receive an email like one below, open a browser https://ip-ipam and use credentials and download code provided
Importing Subnets and Hosts using a CSV file
To import a CSV you will need to respect a strict field format, you can use just a file for subnets and hosts, but i found it insane sometimes. For that reason i imported using different files.
File content subnets.csv
File content hosts.csv
Click on CSV Import on your left
Click on + signal
Select a CSV file to import, you can also use Options to control what you want to change. Press Start :)
After a successful import, you will see occupation of each subnet
Click on a subnet 10.1.0.0/24, you can show hosts using an IP Map or List
Drop me a comment if you need my ova file