1. Define the discrepancy
Agree what is wrong, what a correct result should look like and which reports or systems are affected.
← Back to specialist services
Specialist data investigation
SQL & data forensics for business-critical systems.
When reports disagree, classifications change unexpectedly or two systems produce different answers, the problem is rarely solved by looking at the final spreadsheet. Solidity Technology traces the data back through SQL, application logic and source systems to identify where the discrepancy is introduced.
01Where this service helps
When the technical answer is not obvious.
Our investigation follows the full data path from source tables and transformations through views, stored procedures, reports and downstream systems to establish where the result changes and why.
- Reports or dashboards showing different totals from source systems
- Incorrect classifications, mappings or business rules in database views
- Stored procedures producing unexpected results after system changes
- Data moving incorrectly between operational, finance or reporting platforms
- Legacy databases with little documentation and unclear ownership
- Management needing evidence before changing production data or code
✓What you receive
Evidence, documentation and a practical path forward.
The engagement is scoped around a defined business problem. Work is documented so the client retains the findings and can act on them internally or with existing technology suppliers.
- SQL view, stored procedure and query review
- Data lineage and source-to-report mapping
- Cross-system reconciliation and exception analysis
- Documented findings with evidence and likely root cause
- Corrective-action recommendations and controlled test queries
- Technical handover notes for internal IT, developers or vendors
How the engagement works
A controlled investigation, not guesswork.
We begin with the business impact, work through the relevant technical layers and finish with documented findings and clear next actions.
2. Trace the data
Follow the records from source tables through views, procedures, transformations and consuming applications.
3. Prove the cause
Reproduce the issue using controlled queries and compare the result against known-good business records.
4. Recommend the fix
Provide practical remediation, test steps and documentation before production changes are made.
Frequently asked questions
Questions about this specialist service.
Is this computer or criminal digital forensics?
No. This service focuses on business data, SQL logic, applications and reporting integrity. It is not positioned as court-evidentiary computer forensics.
Can you work with an existing developer or MSP?
Yes. Findings can be documented and handed to the client's developer, software vendor or managed service provider for implementation.
Do you change production data during the investigation?
Normally the investigation begins read-only. Any corrective changes should be separately approved, tested and backed up before implementation.
Related capabilities
Specialist services that often work together.
Legacy System Discovery
Explore this related Solidity Technology specialist capability.
View service →ERP & Business Systems Advisory
Explore this related Solidity Technology specialist capability.
View service →Technical Documentation
Explore this related Solidity Technology specialist capability.
View service →Business Process & Data Flow Mapping
Explore this related Solidity Technology specialist capability.
View service →Have a system nobody fully understands, data that does not reconcile or a technical problem that keeps returning?Let's open a discussion on how we can help your team or business.
Book a consultation