“Managing datacenter IP allocation in an Excel spreadsheet works fine for 10 servers. At 2,000 servers, concurrent spreadsheet edits cause IP collisions that crash core gateways.”

At Net4 India, managing server rack space and IP address blocks across two data centers in Excel spreadsheets resulted in duplicate IP assignments and unmapped patch panel ports.

Architecture: Integrated IPAM & CMDB Operational Portal

We deployed RackTables and iTop (IT Operational Portal) to establish a single source of truth for physical and logical datacenter inventory.

• RackTables: Visualized physical 42U rack layouts, PDU power outlet mapping, and switch port patch assignments down to individual U heights.
• iTop CMDB & IPAM: Centralized public (202.71.x.x) and private (10.x.x.x) IP subnet pools. Integrated REST API webhooks reserved IP addresses automatically during new customer VPS provisioning.

[!NOTE] Enforce mandatory IP address reservation via CMDB before cabling any new physical server to datacenter top-of-rack switches.

-- # iTop IPAM Subnet Allocation Validation Query
SELECT ip_address, fqdn, status 
FROM cmdb_ip_addresses 
WHERE subnet_id = '10.200.50.0/24' AND status = 'allocated';

The Verdict

Key Takeaway

Eliminate Spreadsheet Management in Favor of Automated CMDB IPAM.

Integrating RackTables and iTop CMDB eliminates IP collisions, accelerates rack deployment speeds, and maintains strict auditability across physical datacenter assets.