Skip to content

The Hidden Database

By Tomasz Lewandowski · 6 Aug 2026 · 8 min read

The Hidden Database
The Maintenance Blueprint — Your Hidden Database

The Information You Already Own

Most maintenance firms begin their digital journey by asking what software they should buy. It is a natural question, but it is not the first one. The better starting point is quieter and much more useful: what information do we already rely on every day? Somewhere in the business there will be asset lists, site addresses, service histories, risk notes, staff skills, parts records, old quotations, photographs, client emails and handwritten job sheets. They may not look like a database, but that is precisely what they are. They are the working memory of the business, only spread across too many places.

Recognising this hidden database changes the nature of the project. Instead of treating software as a miracle cure, you begin by treating your existing information as an asset. The question becomes not "what app can fix us?" but "what do we know, where is it kept, who trusts it, and how can we turn it into something the whole team can use?" That shift is the beginning of preventative control.

Why Hero Knowledge Is a Business Risk

Every maintenance operation has at least one person who "just knows". They know which client has a difficult access arrangement, which pump was replaced last winter, which engineer is best suited to a temperamental boiler, and which old work order never quite made it into the file. This knowledge is valuable, but when it lives only in one person's head it becomes a business risk. If that person is on holiday, off sick, overloaded or leaves the company, the operation becomes exposed.

Hero knowledge often feels efficient because it avoids formal process. Someone asks a question, the right person answers, and the work carries on. The danger is that the business has mistaken personal memory for operational resilience. A stronger system does not remove the value of experienced people; it captures enough of their knowledge so the business can function when they are not in the room. The aim is not to replace judgement. It is to stop vital facts being trapped inside private memory.

Where Hidden Data Usually Lives

Hidden data rarely sits in one dramatic pile waiting to be discovered. It is usually ordinary, untidy and familiar. Client addresses may be in Outlook contacts, the accounting package and a spreadsheet on someone's desktop. Asset numbers may be written on service tags, tucked inside old job sheets or buried in PDF reports. Parts usage may be half in supplier invoices and half on a workshop whiteboard. Staff certifications may be in a folder that only one administrator updates. Each source may be useful in isolation, but together they create friction because nobody can quite tell which record is current.

This is why the first exercise should be an inventory, not a migration. Walk around the business and list every place where maintenance information is stored or implied. Include physical folders, local drives, email accounts, WhatsApp messages, photos, notebooks, whiteboards, spreadsheets and people's heads. At this stage, do not judge the quality. Simply find the data. You cannot clean what you have not found.

Turning Paper Trails into Useful Records

Paper is not the enemy. In many firms, paper is the reason the business has survived as long as it has. A completed job sheet, a signed service record or a handwritten note on a plant room door can contain exactly the sort of operational truth a new system needs. The problem is not that the information was captured on paper. The problem is that paper does not make itself searchable, shareable or easy to compare.

The practical task is to extract the important facts rather than merely scan the documents. A scan may preserve a job sheet, but it does not automatically tell you the asset serviced, the date of the visit, the fault found, the part replaced or the next recommended action. A useful digital record turns those facts into structured fields. Start with the basics: site, asset, date, work done, engineer, parts used, outcome and follow-up. Those fields are the first bricks in the maintenance blueprint.

Naming the Source of Truth

Once you have found your records, you will almost certainly discover duplicates. One site address may appear in three systems, with three slightly different postcodes. One asset may be described as "Boiler 1", "Main boiler", "Plant room boiler" and "Client asset 004". None of these differences may seem serious in isolation, but they become costly when engineers are sent to the wrong place or reports cannot be trusted.

The remedy is to name a source of truth for each dataset. That does not mean deleting everything else on day one. It means deciding, clearly, which record should be treated as authoritative. For client addresses, it may be the contract database. For asset details, it may be the new asset register. For staff skills, it may be the training matrix. Once the source of truth is named, other copies can either be retired, linked or treated as historical. Without this decision, every system will quietly argue with every other system.

The 45-Minute Inventory

A useful first step can be completed in less than an hour. Open a spreadsheet and create six columns: dataset, location, owner, quality rating, duplication and next action. Then list every source of maintenance information you can think of. "Asset list in workshop folder" is a dataset. "Site notes in Paul's notebook" is a dataset. "Parts stock on whiteboard" is a dataset. "Boiler history known by Alan" is also a dataset, even though its location is a person rather than a drive.

The quality rating should be simple, from one to five. A one means incomplete, unreliable or badly out of date. A five means current, consistent and trusted. The next action should be practical: consolidate, verify, extract, archive, update, assign owner or retire. The exercise is deliberately modest. It is not a grand transformation programme. It is a disciplined act of finding. Once completed, it gives you a map of what your business already knows.

What to Capture Before You Digitise

Before you move into a CMMS or custom application, decide which fields matter. This is where many projects become either too vague or too ambitious. If you capture too little, the system will not support the work. If you capture too much, staff will see it as administrative punishment and avoid it. The right answer is usually a lean set of fields that directly support scheduling, safety, reporting and accountability.

For assets, capture a unique identifier, description, make, model, serial number, site, location, criticality, service interval and current status. For sites, capture address, access notes, contact details, working restrictions and any hazards. For work orders, capture fault, priority, assigned engineer, due date, completion notes, parts used and sign-off. These fields will not cover every future wish, but they give the business a solid foundation. A good first system should be useful, not encyclopaedic.

The Blueprint Mindset

The hidden database is not a problem to be embarrassed about. It is evidence that your business has already developed ways of remembering what matters. The next step is to bring that memory into the open, clean it and make it dependable. That is the difference between digitising for appearance and digitising for control. One produces screens and logins. The other produces better decisions.

The blueprint mindset asks you to slow down before you speed up. It recognises that software will multiply whatever business logic you feed into it. If the underlying information is confused, software will help you become confused faster. If the underlying information is clear, software can make the operation more consistent, more transparent and less dependent on firefighting. Start by finding what you own. The database is already there. The work is to make it visible.

A Common Mistake to Avoid

The common mistake is to start tidying too late. Businesses often wait until they have chosen software before they begin asking where information lives. By then, the structure of the new system may already be shaped around assumptions rather than evidence. This leads to rushed data migration, vague field choices and uncomfortable discoveries during implementation. It is far better to find the mess while decisions are still cheap.

Avoid the temptation to make the inventory perfect before acting. The first map will be incomplete, and that is acceptable. Its purpose is to reveal the main clusters of information and the most obvious risks. Once those are visible, you can prioritise. Clean the datasets that affect live work, safety, compliance and client reporting first. Leave historical curiosities until later. Progress begins when the business can distinguish vital records from background clutter.

The Practical Next Step

Choose one contract, one site or one asset group and perform a focused data hunt. Ask three questions of every record you find: is it current, is it trusted, and who owns it? Then mark each source as keep, clean, merge, verify or retire. This small exercise will quickly show whether the organisation has a data problem, an ownership problem or simply a storage problem.

Do not delegate the whole exercise to the most junior administrator. Involve someone from the office and someone from the field. The office will know where formal records live; engineers will know which records reflect reality. The contrast between the two is often where the most useful insight sits. When you have completed the first pass, you will have something more valuable than a software wish list. You will have the beginnings of a maintenance blueprint.

The Business Owner's Takeaway

The business owner's takeaway is simple: do not begin by shopping for software; begin by finding the information that already runs the business. The hidden database may be untidy, but it is valuable. Once it is visible, you can decide what to clean, what to protect and what to build around. That is a stronger starting point than any product demo.

How to map your maintenance business's hidden database before buying software

  1. Inventory before you migrate. Walk around the business and list every place where maintenance information is stored or implied - physical folders, local drives, email accounts, WhatsApp messages, photos, notebooks, whiteboards, spreadsheets and people's heads. Do not judge quality at this stage; you cannot clean what you have not found.
  2. Build the 45-minute inventory table. Open a spreadsheet and create six columns: dataset, location, owner, quality rating, duplication and next action. List each source as a dataset - for example "Asset list in workshop folder", "Site notes in Paul's notebook", "Parts stock on whiteboard" or "Boiler history known by Alan".
  3. Rate quality and set an action. Score each dataset's quality from one (incomplete, unreliable or badly out of date) to five (current, consistent and trusted). Give each a practical next action: consolidate, verify, extract, archive, update, assign owner or retire.
  4. Name a source of truth for each dataset. Decide clearly which record is authoritative - the contract database for client addresses, the new asset register for asset details, the training matrix for staff skills. Retire, link or treat as historical the other copies so systems stop arguing with each other.
  5. Extract facts from paper, not just scans. Turn paper trails into structured records by pulling out the operational facts rather than merely scanning documents. Start with the basics: site, asset, date, work done, engineer, parts used, outcome and follow-up.
  6. Decide the lean fields to capture. Before moving into a CMMS, pick the fields that support scheduling, safety, reporting and accountability. For assets capture identifier, description, make, model, serial number, site, location, criticality, service interval and status; for sites capture address, access notes, contacts, restrictions and hazards; for work orders capture fault, priority, engineer, due date, completion notes, parts used and sign-off.
  7. Run a focused data hunt and involve both office and field. Choose one contract, site or asset group and ask three questions of every record - is it current, is it trusted, and who owns it - then mark each as keep, clean, merge, verify or retire. Do not delegate this to the most junior administrator; involve someone from the office (who knows where formal records live) and someone from the field (who knows which records reflect reality).
  8. Prioritise the records that matter most. Accept that the first map will be incomplete. Clean the datasets that affect live work, safety, compliance and client reporting first, and leave historical curiosities until later.

Frequently asked questions

Should I buy maintenance software before sorting out my data?

No. Begin by finding the information that already runs the business rather than shopping for software. Starting to tidy too late means the new system gets shaped around assumptions rather than evidence, which leads to rushed data migration, vague field choices and uncomfortable discoveries during implementation. Find the mess while decisions are still cheap, then choose a tool to support it.

What is "hero knowledge" and why is it a risk?

Hero knowledge is what your most experienced person "just knows" - which client has a difficult access arrangement, which pump was replaced last winter, or which engineer suits a temperamental boiler. It feels efficient because it avoids formal process, but when it lives only in one head the business has mistaken personal memory for operational resilience. The aim is not to replace experienced people's judgement but to capture enough of their knowledge so the business can still function when they are not in the room.

Where is my maintenance data usually hidden?

It is rarely in one dramatic pile - it is ordinary, untidy and familiar. Client addresses may sit in Outlook contacts, the accounting package and a desktop spreadsheet; asset numbers may be on service tags, old job sheets or buried in PDF reports; parts usage may be split between supplier invoices and a workshop whiteboard; and staff certifications may be in a folder only one administrator updates. The article also counts knowledge held in a person's head as a dataset, even though its location is a person rather than a drive.

How do I do a quick data inventory of my maintenance business?

Open a spreadsheet and create six columns: dataset, location, owner, quality rating, duplication and next action. List every source of maintenance information you can think of, including physical folders, whiteboards, notebooks and people's heads. Rate quality from one (incomplete, unreliable or out of date) to five (current, consistent and trusted), and set a practical next action such as consolidate, verify, extract, archive, update, assign owner or retire. It can be completed in less than an hour and gives you a map of what your business already knows.

What fields should I capture before digitising into a CMMS?

Use a lean set of fields that directly support scheduling, safety, reporting and accountability - too little and the system won't support the work, too much and staff treat it as administrative punishment. For assets, capture a unique identifier, description, make, model, serial number, site, location, criticality, service interval and current status. For sites capture address, access notes, contact details, working restrictions and any hazards; for work orders capture fault, priority, assigned engineer, due date, completion notes, parts used and sign-off. A good first system should be useful, not encyclopaedic.

What should I do about duplicate records across different systems?

Expect duplicates - one site address may appear in three systems with three slightly different postcodes, and one asset may be called "Boiler 1", "Main boiler", "Plant room boiler" and "Client asset 004". Rather than deleting everything on day one, name a single source of truth for each dataset and decide which record is authoritative. Other copies can then be retired, linked or treated as historical. These differences seem minor in isolation but become costly when engineers are sent to the wrong place or reports cannot be trusted.

Share Follow
The Day 1 Black Hole: The Find Phase
The Talent Flow Blueprint

The Day 1 Black Hole: The Find Phase

New-starter details are real but scattered across inboxes, PDFs and spreadsheets. Before you clean or automate anything, you have to find where onboarding data actually lives — and this is how to map it.

18 Aug 2026 · 7 min read
Asset Registry & Barcoding
The Maintenance Blueprint

Asset Registry & Barcoding

A barcode is more than a label. It is the link between a physical asset and the service history, location and accountability behind it.

13 Aug 2026 · 8 min read
Follow One Batch — How to Find the Quiet Gaps in Your Factory
Food Traceability

Follow One Batch — How to Find the Quiet Gaps in Your Factory

If you want to understand traceability in a food production business, do not begin with a software demonstration. Begin with one batch.

12 Aug 2026 · 8 min read