AWS — Deployed Infrastructure
Live verification of account 660537473428 (us-east-1), performed 2026-07-07 with read-only AWS CLI calls (list/get/describe only; nothing modified) plus a read-only inspection of the production database (information_schema and routine definitions only). Fills the runtime gaps the source-only docs couldn’t answer. No secret values appear in these pages.
Contents
Section titled “Contents”| Page | Covers |
|---|---|
| lambda-inventory.md | All deployed functions, the extraction Lambdas’ real config, template-vs-deployed drift |
| schedules-and-queues.md | Every EventBridge schedule (the sync heartbeat) and SQS queue/DLQ wiring |
| apis-auth-hosting.md | API Gateways, live authorizer state, Cognito pools, CloudFront/S3 hosting, RDS instances/proxies, VPC/network layout |
| database.md | The jbwst schema: all tables with row counts, views, and every stored procedure’s logic (matching engine, agreement factory, claims detection) |
| deployment-history.md | Origin of the system (Jan 2024 Maktix handover) and the manual deploy procedure |
Headline Findings
Section titled “Headline Findings”- CloudFormation is 2 years stale. Stack
jbw-prod-apilast updated 2024-05-06,jbw-stage-api2024-04-27 — yet many Lambdas show 2025–2026 modification dates. Everything since May 2024 was deployed outside SAM. The repo’stemplate.yamldescribes May 2024, not today. - A full dev/stage environment exists (99
dev_*functions, own API Gateway, Cognito pool, queue,jbw360-stage.jbwarranties.com) even thoughsamconfig.tomlonly definesprod. - Cognito auth IS currently attached to both portal APIs — the template’s “deploys with no authorizer” risk is real at deploy time but remediated in the live account.
- ~40 prod Lambdas are not in the template; about a dozen have no source anywhere in the repo.
- A second, newer API exists:
JB360IntegrationAPI(created 2026-01-13) fronting thejb360dealerJava Lambdas — none of it in this repo.
Follow-ups Worth Considering
Section titled “Follow-ups Worth Considering”- Decide the source of truth: re-adopt SAM (import drift, fix the template’s indentation bug) or officially treat the console as truth.
- Dev and Workiz queues have no DLQ — failures are silently dropped after retries.
- Duplicate daily schedules on
prod_getTenantInfoandprod_jbwequipmentsyncstoredpro. - Recover/track source for the ~12 repo-less prod functions (incl. the
jb360dealerAPI).