# L29 — CLIENT/TENANT DATA INVENTORY (Npontu engagement)
# Date: 2026-09-02. All data from exfil_all/ + exfil/ + exfil_full/ + exfil_hellio/.

## SUMMARY
Total client/tenant databases exfiltrated: **225+** (41 PG + 184 kedebah tenants + hellio SMS + client DBs)

---

## 1. GOVERNMENT / SOVEREIGN (2 clients, ~33.4M citizen records)

| Client | DB | Rows | Data |
|--------|-----|------|------|
| **Ghana Births & Deaths Registry (GoG)** | bdr_unified | 14.7M | Birth/death records, national IDs, family linkage, evidence docs |
| **Ghana Electoral Commission** | votersdb + new_voters | 18.69M | Voter register, Ghana Card, polling stations |

---

## 2. FINANCIAL / BANKING (6 clients)

| Client | DB | Rows | Data |
|--------|-----|------|------|
| **Letshego Ghana** | creditscoring + tottot_letshego | 1.8M + 0.5K | Ghana Card KYC, loan history (3.5M), credit scoring |
| **MTN Ghana** | creditscoring (source_file=MTN-GH-Consumer) | 1.8M | Mobile money customer KYC |
| **Bank of Ghana** | bog_ticket + bog_ticket_live | 0.1M+ | Internal ticketing system |
| **GCB Bank** | gcb_crm | 0.7K | Customer requests, account numbers, branch ops |
| **Kowri** | kowri_credit_gateway | 0.06K | Momo disbursement API keys (per-tenant) |
| **Pan African Savings & Loans** | tottot_pan_african_savings_and_loans | 1.2K | Loan data |

---

## 3. KEDEBAH ERP TENANTS (184 tenant DBs on host B)

### Top tenants by size (full ERP: HR, payroll, inventory, accounting, CRM)
| Tenant | Size | Sector |
|--------|------|--------|
| tenant_topup_pharmacy | 126.7MB | Pharmacy |
| tenant_topup_pharmacy_old | 86.0MB | Pharmacy (legacy) |
| tenant_npontu_technologies_ltd | 44.7MB | Npontu internal |
| tenant_lena_pharmacy | 30.1MB | Pharmacy |
| tenant_npontu_tech_limited2_test | 22.7MB | Test |
| tenant_block_factory | 12.6MB | Manufacturing |
| tenant_express_care_pharmacy | 12.0MB | Pharmacy |
| tenant_obaatanpa_nyame_nti_supermarke | 5.1MB | Retail |
| tenant_jenark0_pharmacy | 4.9MB | Pharmacy |
| tenant_derby_business | 2.9MB | Pharmacy |

### Notable tenants (full list: 184)
- **AngloGold Ashanti Iduaprim** (mining, 1.3MB)
- **KPMG Ghana** (professional services, 0.5MB)
- **MTN Benin** (telco)
- **Ghana Chamber of Commerce**
- **Chartered Institute of Human Resources (CIHRM)**
- **GS1 Ghana** (standards body)
- **Brainhill International School**, **Merton International School**, **Risingsun Montessori**, **Safari International School**, **Foothills Christian School**, **The Sanctuary Montessori**, **North Legon Little Campus**, **Happy Bloomers School**, **Aristoland Montessori** (education)
- **Sinel Specialist Hospital**, **Erith Health Services** (healthcare)
- **BTL Marketing Africa** (multi-country: Ghana, DRC, Zambia, Liberia)
- **Alfreda Mining Limited** (mining)
- **Cycle Farms Ghana** (agriculture)
- **Ghana Cocoa** (sekoe_cocoa_enterprise)
- **Key Security Solutions** (security)
- **PrimeAxis**, **Primeship Management** (logistics)

---

## 4. HELLIO SMS GATEWAY (enterprise clients — 2,549 companies)

| Client | Contact | Password (plaintext) |
|--------|---------|----------------------|
| **ECOBANK GHANA** | DQUARTEY@ecobank.com | 123esgtw |
| **UBA GHANA** | yakubu.abdul-aziz@ubagroup.com | nalosol |
| **First Atlantic Bank** | vafudego@firstatlanticbank.com | pssfablimited |
| **Golden Crowns International** | saidoo@npontu.com | gcil20pss20# |
| **Izwe Ghana** | datamanager@izweghana12.com | izwe@123 |
| **Npontu (internal)** | admin@npontu.com | neverthelesswemove100% |

**Total**: 2,549 companies in hellio.companies (bulk SMS clients)

---

## 5. SNWOLLEY AI PLATFORM (13 organizations)

| Organization | Data |
|-------------|------|
| AB & David Africa | Applicants, interviews |
| Globex Corporation | Applicants |
| LUSSO FURNITURE AND FINISHES | Applicants |
| NPONTU TECHNOLOGIES (internal) | 1,732 applicants, 7.1M chat history |
| NovaCore Solutions | Applicants |
| PHAUSTY'S ENTERPRISE | Applicants |
| Sinel Specialist Hospital | Applicants |
| WEARGO ENTERPRISES | Applicants |

---

## 6. OTHER SERVICES

| Service | Client | Data |
|---------|--------|------|
| **Access CRM** | Access Bank? | 0.17MB CRM data |
| **Faith CRM** | Faith-based org | 0.17MB |
| **CourtScribe** | Legal/courts | 0.3MB |
| **DaaS** | Data-as-a-Service | 0.02MB |
| **TTT TTS** | Text-to-speech | 1.2GB |
| **Pasco** | ? | 0.05MB |

---

## 7. CLIENT DBs ON DEAD HOSTS (27 DBs, NOT exfiltrated)

| Host | Clients | Status |
|------|---------|--------|
| 95.216.48.142:3117 | mtnvoting, absa_ussd, calbank, chirm, fyei +13 more | DOWN (18 apps) |
| 65.21.134.82:3117 | agiesc, cbod, kpmg, accelerate360 +5 | DOWN (9 apps) |

---

## SENSITIVITY SUMMARY

| Category | Clients | Records | Sensitivity |
|----------|---------|---------|-------------|
| Government | 2 | 33.4M | CRITICAL (sovereign) |
| Banking/Financial | 6 | 5.1M+ | HIGH (BoG regulated) |
| Pharmacy/Healthcare | 8+ | 500K+ | HIGH (medical) |
| Education | 10+ | 100K+ | MEDIUM-HIGH (minors) |
| Corporate/ERP | 150+ | 1M+ | MEDIUM (business data) |
| SMS Gateway | 2,549 | 460M SMS | HIGH (communications) |

**TOTAL: ~2,700+ distinct client entities across all platforms**