Discovery · System inventory

System inventory

Musterwerk Antriebstechnik GmbH

Situation
An audit finding and an end-of-life deadline
Access
Tier B
Prepared by
Aleph Engineering GmbH
Version
1.0, reviewed by a second engineer

Scope and limits

Systems examined
ERP, Customer portal, Nightly sync, EDI link
Context only
AuftragsPlaner, Shop-floor data, File server, Document archive, Quality system, HR and payroll, Drive and Sheets, Excel workbooks, Shared mailboxes
Period
10 business days
Access
Tier B, read-only technical inspection: Approved read-only access to named repositories, configuration, build and deployment setup, or infrastructure views.
Exclusions
No production data, no changes to any system, no security testing beyond configuration review.
Confidence
High for the configuration, code, and integration design. The sync's actual failure rate is inferred from complaints.

Landscape

13 systems recorded; 4 examined in depth. Select a system on the map for details.

ERPAuftragsPlanerCustomer portalNightly syncEDI linkShop-floor dataFile serverDocument archiveQuality systemHR and payrollDrive and SheetsExcel workbooksShared mailboxes
Core business systemCustom-built softwareCloud serviceSpreadsheets and documentsIntegration

Custom-built software

Customer portal

Order status, delivery dates, and documents for B2B customers.

Owner
Markus Wendt
Technology
PHP web application
Runs on
Rented virtual private server
Users
About 300 customer accounts

Inventory

SystemPurposeOwnerTechnology and hostingDepends onEvidence
ERPOrders, materials, purchasing, invoicing, and accounting.Andrea Hoffmann (process), Sabine Roth (technical)Standard ERP with about 60 customizations, two major versions behind. On-premises server in the plant.—Validated
Customer portalOrder status, delivery dates, and documents for B2B customers.Markus WendtPHP web application. Rented virtual private server.Nightly syncValidated
Nightly syncMoves orders and delivery dates between the ERP and the portal as CSV files.Nobody namedScheduled scripts and file transfer. Split between the plant server and the rented server.ERPValidated
EDI linkElectronic orders and delivery notes with two large customers.Markus WendtEDI converter service. External provider.ERPValidated
AuftragsPlanercontextProduction planning and machine scheduling for every order.Petra VogelDesktop application with an SQL database, written in 2009. Plant server; installed on 14 workstations.ERP, File serverObserved
Shop-floor datacontextMachine and labour time recorded at each work centre.Petra VogelTerminal software writing export files. Shop floor; files to the file server.File serverObserved
File servercontextShared drives, machine data exports, and drawings.Jens AlbrechtWindows file server. On-premises.—Observed
Document archivecontextInvoices, delivery notes, and certificates, archived for retention.Andrea HoffmannDocument management system. On-premises.ERPObserved
Quality systemcontextInspection plans, complaints, and certificates.Ralf NeumannQM software. On-premises.ERPObserved
HR and payrollcontextPersonnel records, time accounts, and payroll.HRSoftware as a service. Provider cloud.—Observed
Drive and SheetscontextAbout 400 sheets: price lists, capacity plans, supplier lists; Docs used as process manuals.Each departmentGoogle Workspace. Provider cloud.AuftragsPlanerObserved
Excel workbookscontextOffer calculation and monthly reporting, with macros.Andrea Hoffmann, Markus WendtExcel with macros. File server and laptops.ERP, Drive and SheetsObserved
Shared mailboxescontextOrders, change requests, and complaints that arrive by email.Sales back officeEmail. Provider cloud.ERPObserved

← Back to the guided tour