Discovery · System inventory

System inventory

Musterwerk Antriebstechnik GmbH

Situation
The one person who knows the system is leaving
Access
Tier B
Prepared by
Aleph Engineering GmbH
Version
1.0, reviewed by a second engineer

Scope and limits

Systems examined
ERP, AuftragsPlaner, Shop-floor data, File server
Context only
Customer portal, Nightly sync, EDI link, 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 how the tool is built, released, and connected. Runtime behaviour, such as performance, is inferred.

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

AuftragsPlaner

Production planning and machine scheduling for every order.

Owner
Petra Vogel
Technology
Desktop application with an SQL database, written in 2009
Runs on
Plant server; installed on 14 workstations
Users
14 planners and foremen

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
AuftragsPlanerProduction 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 serverValidated
Shop-floor dataMachine and labour time recorded at each work centre.Petra VogelTerminal software writing export files. Shop floor; files to the file server.File serverValidated
File serverShared drives, machine data exports, and drawings.Jens AlbrechtWindows file server. On-premises.—Validated
Customer portalcontextOrder status, delivery dates, and documents for B2B customers.Markus WendtPHP web application. Rented virtual private server.Nightly syncObserved
Nightly synccontextMoves 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.ERPObserved
EDI linkcontextElectronic orders and delivery notes with two large customers.Markus WendtEDI converter service. External provider.ERPObserved
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