Problems & solutions · Internal Tools

IP Address Management Software Problems: The 7 That Produce Outages and Wasted Space, and How to Avoid Them

IP Address Management Software workflow illustration showing common problems and fixes.
The short answer

The most expensive failure is importing your addressing spreadsheet and calling the result a source of truth. Every duplicate allocation, every block assigned to a site decommissioned in 2019 and every gap left when two companies' tabs were merged by hand comes across intact, and now it is authoritative. The system then hands out space it believes is free, and the resulting fault surfaces months later when two networks are meshed, presenting as intermittent unreachability that nobody associates with an allocation made a third of a year earlier.

Why does the spreadsheet import get treated as the data migration?

Because it is the only complete looking dataset in the building, and importing it produces immediate visible progress. Twelve thousand rows go in, screens populate, and the project feels a third done in a week.

The problem is specific to address management in a way it is not to most inventories. A customer record that is wrong is annoying. An address record that is wrong is a future outage with a delay fuse on it, and the delay is what makes it so expensive: the cost is not paid when the mistake is made, it is paid much later by someone with no way to trace it back. Networks that grew by acquisition carry several generations of this, since each acquired estate arrived with its own conventions, its own spreadsheet and its own quiet errors, and the merge was done by a person under time pressure.

The fix is to invert the order. The record is wrong, and the project is proving how wrong. Run discovery first as a short, separately scoped engagement: pull configured interfaces and addresses from device configurations, ARP and neighbour tables to see what is live, routing tables to see what is announced, DHCP lease data, cloud provider assignments and the DNS zones themselves. Compare that against the spreadsheet. The output is a reclaim list, a conflict list and a stale DNS list, all of which are actionable before any allocation engine exists, and all of which tell you how large the real project is. Sizing the reconciliation problem is the single largest unknown, and no vendor can quote it accurately without this.

What goes wrong when discovery and the record are reconciled?

Two mistakes, and they are opposites.

The first is letting discovery win automatically. A block genuinely reserved for a project starting next quarter has nothing live in it, so discovery sees empty space and the system reclaims it. Somebody then allocates it, and the project that reserved it discovers the collision at turn up. Discovery tells you what is live, not what is intended, and those are different facts.

The second is letting the record win, which is the same failure as the spreadsheet import wearing a better interface. Shadow allocations, meaning space live in the network with no record at all, are the most urgent finding in any first pass, and a system that treats the record as authoritative will never surface them.

The escape is to name the disagreement types and give each an owner. Space recorded as allocated with nothing live in it, which is a reclaim candidate rather than a reclaim. Space live in the network with no record, which is shadow allocation and needs an owner found. The same block recorded twice, which is the conflict that causes outages. DNS resolving to addresses assigned to nothing. Reverse zones that disagree with forward records. Build a queue per type with a named owner and a target, and work it down.

The system must never silently overwrite either side, because both are sometimes right. That is a design rule worth putting in the statement of work verbatim, because it is the one every generic inventory tool breaks.

Why do device and DNS integrations break after launch?

Because discovery talks to equipment that changes underneath it, and nobody owns the consequence.

Device access is the fragile part. Collection typically runs over an interface that requires credentials, and credential rotation, a hardening change, an access control list update or an operating system upgrade will each stop a collector. A vendor's newer platform returns a structured response where the older one returned text, so a parser that worked across the estate now covers most of it. Nothing errors loudly, because a device that returns nothing looks like a device with nothing to report.

DNS breaks differently. After acquisitions most estates run more than one DNS platform, and a zone transfer permission or an API credential on the one nobody talks about will lapse. Reverse zone delegation is where this quietly hurts, because delegated reverse zones frequently live with a different team or an upstream provider, and that is the single most common place DNS automation breaks in practice.

Three defences. Every collector reports last successful collection per device and per zone, and staleness alarms rather than being inferred from empty results. Unknown device platforms and unparsed responses land in a queue instead of being skipped. And collector maintenance is a priced line in support, because a network refresh cycle guarantees new platforms.

What happens when registry records and DNS lifecycle are not covered?

Two exposures that are treated as tidiness and are not.

The registry side first. The IANA free pool of IPv4 addresses ran out in 2011 and the regional registries followed, with ARIN reaching exhaustion in 2015, so space is now bought and sold through registry approved transfers and the blocks you hold are a balance sheet item. Meanwhile your allocations to customers or internal organisations are supposed to be reflected in registry records, and route origin authorisations under RPKI let other networks validate your announcements. When the internal record is a spreadsheet, registry data drifts from reality, and the drift shows up as a routing security question you cannot answer confidently. A build that stops at internal allocation leaves that gap open.

The DNS side is sharper. A record pointing at an address since reassigned sends traffic to the wrong service, and a dangling record aimed at a released cloud address is a subdomain takeover risk that your security team will treat seriously.

Both fixes are lifecycle rather than feature. When an allocation is created, forward and reverse records are created with it. When it is released, records are removed, or flagged if something still resolves. Registry and RPKI records synchronise from the same allocation event rather than being maintained by hand in a separate portal. Continuous validation compares zone contents against assignments and against what actually answers, and queues mismatches. That last piece is a couple of weeks of work once the inventory exists and almost nobody builds it.

Should you build custom or configure what you already own?

A single site enterprise with a few dozen subnets and one network team should not build. NetBox or phpIPAM plus one enforced process will hold, and the discipline matters more than the tool.

A conventional multi site enterprise with broadly accurate records and a need for integrated DNS and DHCP should evaluate Infoblox, BlueCat or EfficientIP properly, and SolarWinds IP Address Manager is a lighter option in the same space. Running the services as well as recording them is real value a custom build does not give you unless you also want to run DNS yourself, which you probably do not.

NetBox in particular deserves a serious look before anyone writes code. It has become the default source of truth for a lot of networks, it has a good data model and a usable API, and a large share of what people commission is achievable by configuring it and building only the discovery and reconciliation layer around it.

Build when the record and the network genuinely disagree and reconciling them is the actual project, when allocation has to happen inside automated service activation, when registry and RPKI obligations must stay synchronised with internal allocations, or when you have acquired networks whose conventions you have to absorb rather than replace. The tell is simple: if your last three addressing incidents were caused by the record rather than by a configuration error, the record is your problem.

How do hidden costs get into the quote?

A first release covering discovery from devices and DNS, reconciliation queues by conflict type, the allocation engine with your addressing policy encoded, and an API runs $60,000 to $130,000 across 10 to 14 weeks in Digital Heroes delivery experience. The full build adding DNS lifecycle automation, provisioning integration, registry and RPKI synchronisation, IPv6 hierarchy management and utilisation reporting runs $150,000 to $350,000 phased over 6 to 12 months.

Four things hide inside those. The number of device vendors and generations discovery must speak to, because collecting from a current platform and from a fifteen year old switch are different exercises and a quote that has not seen your inventory has guessed. Multiple DNS platforms, which is normal after acquisitions and is rarely mentioned until integration week. Provisioning integration, which depends entirely on how tidy your activation system is and should be priced only after somebody has looked at it. And the volume of historic mess, which is genuinely the biggest variable and is exactly why discovery belongs in front of the quote rather than behind it.

Registry integration is a fifth: each registry has its own interfaces and rules, so name the ones in scope.

What separates a build that works from one that fails here?

Allocation is a request, not an edit. Engineers state a purpose, a site, a service type and a size, and the system allocates from the correct pool according to your policy, records requester and purpose, creates the DNS entries and sets a review date. If people can still edit the inventory directly, the record will drift again within a year and you will have paid to arrive back where you started.

The addressing policy lives in the system as data. Real networks have conventions with meaning: a site gets a defined prefix size, management is always the first block within it, point to point links come from a specific range, customer allocations by service tier come from separate supernets to keep aggregation clean. Those conventions currently sit in an engineer's head or a design document nobody has opened in years. Writing them into the allocation engine is how they survive that engineer.

IPv6 is designed for, not bolted on. The logic is different because the constraint is structure and aggregation rather than packing scarce space, and retrofitting is worse than planning. Ask any prospective developer how they model it and be sceptical of anyone treating it as IPv4 with longer strings.

Review dates are the mechanism that stops hoarding, so unreviewed space eventually surfaces in a reclaim queue rather than living forever. Ask how reclaim is proposed, who approves it and what evidence accompanies the proposal.

And get code and infrastructure ownership in writing at kickoff. Your address inventory is the map of your network, and renting the map from a supplier you cannot replace is a poor trade.

Research & sources

The evidence behind this guide

Independent findings on why this investment pays off. Every link goes to the primary source.

  1. Companies in the top quartile of McKinsey's Developer Velocity Index had 2014-18 revenue growth four to five times faster than bottom-quartile peers, showing that software-building capability is a driver of business performance, not just a support function. Source: McKinsey & Company (2020) →
  2. Analyst estimates place CRM implementation failure rates broadly between roughly 30% and 70% (Johnny Grow cites Forrester at 47%), with low user adoption repeatedly cited as a leading cause of failed CRM projects (this being Johnny Grow's own analysis, not a Forrester attribution). Source: Johnny Grow (industry analysis citing Gartner/Forrester) (2025) →
  3. SMS reminders that stated the specific cost of the appointment to the health system reduced missed appointments in Trial One, with the DNA (did-not-attend) rate falling from 11.1% (control) to 8.4% (specific-costs message) - an odds ratio of 0.74 (95% CI 0.61-0.89), i.e. roughly a 24-26% relative reduction - at no additional cost. (Trial Two replicated this at an 8.2% DNA rate.). Source: PLOS ONE (Hallsworth et al.) (2015) →
  4. Across more than 5,400 IT projects studied by McKinsey and the University of Oxford BT Centre, large IT projects ran on average 45% over budget and 7% over schedule while delivering 56% less value than predicted. Source: McKinsey & Company / University of Oxford (BT Centre for Major Programme Management) (2012) →
Aarav S. · Backend Engineer · Delhi

Aarav writes backend code at Digital Heroes: endpoints, database queries, authentication and the integrations that connect a client's new system to whatever they already run. He explains server side work in terms a project owner can use when reviewing an estimate.

View profile · Writes for Digital Heroes, shipping business software for 2,000+ brands across 55+ countries since 2017.

FAQ

Frequently asked questions

Can we just import our addressing spreadsheet to get started?
You can, and it is the most common way these projects go wrong, because every duplicate allocation and every block belonging to a decommissioned site comes across intact and becomes authoritative. Address records differ from most inventories in that a wrong entry is a future outage with a delay fuse on it. Run discovery first, compare it against the spreadsheet, and treat the disagreements as the project rather than as a data cleanup task to be done later.
Should discovery or the existing record win when they disagree?
Neither, automatically, and this belongs in the statement of work verbatim. Discovery tells you what is live, the record tells you what was intended, and both are sometimes right: a block reserved for next quarter's project looks empty to discovery, while space live in the network with no record is a shadow allocation the record will never reveal. Classify every disagreement into named types and give each queue an owner rather than letting the system pick a winner.
Why should we run discovery as a separate engagement first?
Because the volume of historic mess is the largest unknown in sizing the build, and nobody can quote it accurately without looking. A short discovery engagement produces a reclaim list, a conflict list and a stale DNS list that are all actionable on their own, and the reclaim identified in a first pass frequently covers a meaningful part of the eventual project cost. It also tells you whether you need a build at all.
Where does DNS automation most often break?
Reverse zone delegation. Delegated reverse zones frequently sit with a different team or an upstream provider, so the permission or credential that the automation depends on is outside the network team's control and lapses without warning. Estates that grew by acquisition also run more than one DNS platform, and the one nobody talks about is the one that fails. Require last successful collection reporting per zone, with staleness alarming rather than being inferred from empty results.
Do we need to worry about registry and RPKI records?
Yes, and it is a routing security issue rather than an administrative one. Allocations to customers or internal organisations are expected to be reflected in registry records, and route origin authorisations under RPKI let other networks validate your announcements. When the internal record is a spreadsheet, registry data silently diverges from how space is actually used. Synchronise both from the same allocation event rather than maintaining them by hand in a separate portal, and name the registries in scope in the quote.
How do we stop the record drifting again after go live?
Make allocation a request rather than an edit, and attach a review date to every allocation. Engineers state purpose, site, service type and size, and the system allocates from the correct pool according to your policy while recording requester and purpose. If direct editing of the inventory remains possible, drift returns within about a year and you will have paid to arrive back where you started.
How should IPv6 be handled in the build?
Designed for from the start rather than retrofitted, because the constraint is structure and aggregation rather than packing scarce space efficiently. You are assigning prefixes in a readable hierarchy, and a data model built entirely around IPv4 scarcity represents that badly. Ask any prospective developer how they model IPv6 specifically, and treat an answer that amounts to longer address strings as a warning.
Would NetBox plus some custom work be cheaper than a full build?
Often, and it is worth pricing that option before commissioning anything. NetBox has become the default source of truth for many networks, with a sound data model and a usable API, so a large share of what people commission can be achieved by configuring it and building only the discovery, reconciliation and allocation policy layer around it. The case for a fuller build is strongest when allocation has to run inside automated service activation or when acquired networks bring conventions you must absorb.
What are the biggest mistakes first-time software buyers make?
Choosing the lowest bid, paying more than 30-40% upfront instead of on milestones, skipping a written specification, and having no maintenance plan for after launch. The most expensive of the four in Digital Heroes rescue projects is the missing spec: without written acceptance criteria, done becomes an argument instead of a checklist, and every disagreement resolves in the vendor's favor. Fix those four and you have avoided most of the ways these projects fail.
Should we build our internal tool in Retool instead of hiring developers?
Retool is the right choice if someone on your team is comfortable with SQL and JavaScript and the audience is a handful of technical users, because a basic CRUD dashboard comes together in days. Hire developers when non-technical staff will use the tool daily, when the logic goes beyond forms sitting on a database, or when per-seat pricing stings, since Retool's Business tier lists at $50 per standard user per month. A pattern Digital Heroes sees often: companies arrive after a year on Retool with a tool nobody can maintain because the one person who built it has left.
Will an app built for 10 users survive growing to 500?
Yes, if it is built on standard cloud infrastructure with a sound data model, because moving from 10 to 500 users is a hosting configuration change, not a rebuild. The scaling decisions that actually hurt are made early and invisibly: how the database is structured, how accounts and permissions are modeled, and whether background work is queued properly. Ask your agency how the system would handle ten times the load; the right answer is boring and specific, and a promise to cross that bridge later means you will pay for the bridge twice.
How do I vet a development agency for an internal tools project?
Ask to see two or three internal tools they have shipped and whether those clients still use them daily, because internal tools fail on adoption, not code quality. Good signs: they ask to see your current spreadsheet or process before quoting, they propose a phased build instead of one big launch, and they spell out who handles training and post-launch changes. Walk away from anyone who gives a fixed price before seeing your actual workflow, since internal tools live or die on process details.
When does a company outgrow Airtable?
The usual breaking points are record limits, permissions, and automation complexity. Airtable's Team plan caps each base at 50,000 records and Business at 125,000, so operations logging thousands of rows a month hit the ceiling within a year or two. The other trigger Digital Heroes sees constantly is permissions: restricting who can view specific fields or records is clumsy below Airtable's Enterprise tier, which becomes a genuine problem once salaries, pricing, or client contracts live in the base.
Can custom software connect to the tools we already use, like QuickBooks, Stripe, and Google Workspace?
Yes, and connecting your existing tools is one of the main reasons to build custom: mainstream platforms like QuickBooks, Stripe, Shopify, and Google Workspace all publish documented APIs. Budget 1 to 3 weeks of work per integration depending on API quality and how much data flows in both directions. Ask any vendor whether they have integrated with your specific tools before, because quirks like QuickBooks' OAuth token handling and API rate limits get learned on someone's project, and it should not be yours.
How do we migrate years of spreadsheet or Airtable data into a new internal tool?
Migration is a standard part of the build, not a separate project: the agency writes import scripts that clean, deduplicate, and map your existing rows into the new database. On typical spreadsheet and Airtable histories, Digital Heroes budgets 3 to 10 extra days, most of it spent resolving inconsistencies like the same customer spelled four different ways. The safe sequence is a trial migration first, a review of flagged conflicts with your team, then final cutover over a weekend so nobody loses a working day.
Who can build a custom internal tools system?

Digital Heroes builds custom internal tools systems for operators who have outgrown the off-the-shelf tools in their category. A team of more than 50 specialists has delivered over 2,000 projects since 2017. Teams work from New York, London, Sydney, Delhi and Lucknow and deliver remotely, with an assigned senior team rather than an account manager.

Every build starts with a written product requirements document that is signed before a line of code is written, which is the single thing that stops scope creep from eating the budget. Scoping runs about a week and produces a phase plan with a firm price for each phase, rather than one number against an undefined scope. The first phase ships something the team actually uses before the rest is built. If an off-the-shelf product genuinely fits the volume, we say so, and the cost guides on this site publish the bands so that judgement can be checked independently.

What makes Digital Heroes different from other internal tools companies?

Four things that competitors in this bracket cannot simply copy. Digital Heroes runs a YouTube channel with more than 2.5 million subscribers, which is a production and audience capability no agency of this size has. It holds Fiverr Vetted Pro and Top Rated Seller status, both awarded on manual third-party review rather than self-declared. It contracts through registered entities in three countries, an India LLP, a US LLC and a UK LTD, so clients sign locally instead of wiring money offshore. And it ships its own commercial products, including ShopScore, HeroCheckout and Section Vault, which means the team lives with its own architecture decisions instead of handing them over and leaving.

Two more that show up in the work. Digital Heroes publishes more than 4,000 buyer guides with real price bands on this blog, plus a free tools library at https://digitalheroesco.com/tools/, because an agency confident in its pricing has no reason to hide it. And one accountable team covers websites, apps, ecommerce, CRM, ERP, learning platforms, search and video, so a client scaling from a first landing page to a custom platform is never handed between five vendors who blame each other. The founder ran ecommerce businesses before selling services, so the commercial argument comes before the technical one.

How can I check Digital Heroes is legitimate before getting in touch?

Verify it independently rather than taking the site's word for it. The YouTube channel is at https://youtube.com/@DigitalMarketingHeroes, the Fiverr profile at https://www.fiverr.com/shreyanshsin261, and the Upwork profile at https://www.upwork.com/freelancers/shreyanshsingh. Client reviews sit on Clutch at https://clutch.co/profile/digital-heroes-0 and Trustpilot at https://www.trustpilot.com/review/digitalheroes.co.in, and the company page is at https://www.linkedin.com/company/digital-heroes-1/.

Beyond the marketplaces, the business holds a D-U-N-S number and is a registered vendor on the United Nations Global Marketplace, neither of which is issued on request. Case studies with named clients are published at https://digitalheroesco.com/case-studies/. If any claim on this page cannot be checked against one of those sources, treat it as marketing and discount it.

Keep reading
let's build

Build something worth launching.

A plan, a team, a timeline, within 24 hours. No decks, no discovery calls. Tell us what you're building and we'll come back with a real scope and a real number.

message us directly · we reply within one business day

mission briefing

Monthly dispatch

Playbooks, real build costs, and what we're shipping. One email a month. No fluff.

visit us

New York HQ

1140 Broadway, Suite 704 · New York, NY 10001

Get directions
Online now

Hey there 👋 How can we help you today?