{"$schema":"https://json.schemastore.org/sarif-2.1.0.json","version":"2.1.0","runs":[{"tool":{"driver":{"name":"codehealth","informationUri":"https://codehealth.canine.dev","rules":[{"id":"D1","name":"Cyclomatic Complexity","shortDescription":{"text":"Cyclomatic Complexity"},"helpUri":"https://codehealth.canine.dev/dimensions/D1"},{"id":"D2","name":"Cognitive Complexity","shortDescription":{"text":"Cognitive Complexity"},"helpUri":"https://codehealth.canine.dev/dimensions/D2"},{"id":"D3","name":"God Classes","shortDescription":{"text":"God Classes"},"helpUri":"https://codehealth.canine.dev/dimensions/D3"},{"id":"D4","name":"Code Duplication","shortDescription":{"text":"Code Duplication"},"helpUri":"https://codehealth.canine.dev/dimensions/D4"},{"id":"D5","name":"Coupling","shortDescription":{"text":"Coupling"},"helpUri":"https://codehealth.canine.dev/dimensions/D5"},{"id":"D6","name":"Cohesion (LCOM4)","shortDescription":{"text":"Cohesion (LCOM4)"},"helpUri":"https://codehealth.canine.dev/dimensions/D6"},{"id":"D8","name":"Code Coverage","shortDescription":{"text":"Code Coverage"},"helpUri":"https://codehealth.canine.dev/dimensions/D8"},{"id":"D9","name":"Test Distribution","shortDescription":{"text":"Test Distribution"},"helpUri":"https://codehealth.canine.dev/dimensions/D9"},{"id":"D10","name":"Test Quality","shortDescription":{"text":"Test Quality"},"helpUri":"https://codehealth.canine.dev/dimensions/D10"},{"id":"D11","name":"Test Reliability","shortDescription":{"text":"Test Reliability"},"helpUri":"https://codehealth.canine.dev/dimensions/D11"},{"id":"D12","name":"Dependency Hygiene","shortDescription":{"text":"Dependency Hygiene"},"helpUri":"https://codehealth.canine.dev/dimensions/D12"},{"id":"D13","name":"Secret Scanning","shortDescription":{"text":"Secret Scanning"},"helpUri":"https://codehealth.canine.dev/dimensions/D13","relationships":[{"target":{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]}]},{"id":"D14","name":"License Compliance","shortDescription":{"text":"License Compliance"},"helpUri":"https://codehealth.canine.dev/dimensions/D14"},{"id":"D15","name":"Churn \u00D7 Complexity Hotspots","shortDescription":{"text":"Churn \u00D7 Complexity Hotspots"},"helpUri":"https://codehealth.canine.dev/dimensions/D15"},{"id":"D16","name":"Bus Factor","shortDescription":{"text":"Bus Factor"},"helpUri":"https://codehealth.canine.dev/dimensions/D16"},{"id":"D17","name":"Explicit Debt","shortDescription":{"text":"Explicit Debt"},"helpUri":"https://codehealth.canine.dev/dimensions/D17"},{"id":"D18","name":"Solution Shape","shortDescription":{"text":"Solution Shape"},"helpUri":"https://codehealth.canine.dev/dimensions/D18"},{"id":"D19","name":"Documentation Quality","shortDescription":{"text":"Documentation Quality"},"helpUri":"https://codehealth.canine.dev/dimensions/D19"},{"id":"D20","name":"ADR Quality","shortDescription":{"text":"ADR Quality"},"helpUri":"https://codehealth.canine.dev/dimensions/D20"},{"id":"D21","name":"Naming Consistency","shortDescription":{"text":"Naming Consistency"},"helpUri":"https://codehealth.canine.dev/dimensions/D21"},{"id":"D23","name":"Boundary Type-Coupling","shortDescription":{"text":"Boundary Type-Coupling"},"helpUri":"https://codehealth.canine.dev/dimensions/D23"},{"id":"D24","name":"Comment Value","shortDescription":{"text":"Comment Value"},"helpUri":"https://codehealth.canine.dev/dimensions/D24"},{"id":"D26","name":"Project Cohesion","shortDescription":{"text":"Project Cohesion"},"helpUri":"https://codehealth.canine.dev/dimensions/D26"},{"id":"D27","name":"Navigability","shortDescription":{"text":"Navigability"},"helpUri":"https://codehealth.canine.dev/dimensions/D27"},{"id":"D28","name":"Secrets (history)","shortDescription":{"text":"Secrets (history)"},"helpUri":"https://codehealth.canine.dev/dimensions/D28","relationships":[{"target":{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]}]},{"id":"D29","name":"Static Analysis (SAST)","shortDescription":{"text":"Static Analysis (SAST)"},"helpUri":"https://codehealth.canine.dev/dimensions/D29"},{"id":"D30","name":"Dependency Vulnerabilities","shortDescription":{"text":"Dependency Vulnerabilities"},"helpUri":"https://codehealth.canine.dev/dimensions/D30","relationships":[{"target":{"id":"CWE-1395","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]}]},{"id":"D31","name":"IaC \u0026 Container Security","shortDescription":{"text":"IaC \u0026 Container Security"},"helpUri":"https://codehealth.canine.dev/dimensions/D31"},{"id":"D35","name":"Change Coupling","shortDescription":{"text":"Change Coupling"},"helpUri":"https://codehealth.canine.dev/dimensions/D35"},{"id":"D36","name":"Supply-chain Provenance \u0026 Signing","shortDescription":{"text":"Supply-chain Provenance \u0026 Signing"},"helpUri":"https://codehealth.canine.dev/dimensions/D36","relationships":[{"target":{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]}]},{"id":"D39","name":"IL Efficiency","shortDescription":{"text":"IL Efficiency"},"helpUri":"https://codehealth.canine.dev/dimensions/D39"}]}},"results":[{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: DboDbContext: TooManyMethods \u2014 152 lines, 31 methods."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"FarmToTableData/Implementations/DboDbContext.cs"},"region":{"startLine":0}}}],"partialFingerprints":{"codehealthFindingId/v1":"d5aff3ede4030bb28ca2efdeb8c1f4ab944cc6aa7dbebdc2edb6e485dbbbd3ee"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (12 lines \u00D7 4): FarmToTableSubscribers/Implementations/Moisture.cs:48-59 | FarmToTableSubscribers/Implementations/SentinelStatus.cs:44-55 | FarmToTableSubscribers/Implementations/Soil.cs:44-55 | FarmToTableSubscribers/Implementations/Temperature.cs:45-56"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"FarmToTableSubscribers/Implementations/Moisture.cs"},"region":{"startLine":48}}}],"partialFingerprints":{"codehealthFindingId/v1":"b29ade49117bd6ad983a7b28ff0ec5dab51be43d3b94b905cd8cef11f7747ca0"}},{"ruleId":"D5","level":"warning","message":{"text":"Off the main sequence: KeyVaultAccessLib: KeyVaultAccessLib: abstractness 0.00, instability 0.00, distance 1.00 \u2014 zone of pain \u2014 concrete and heavily depended-on, so it\u0027s rigid to change."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"cadeb689a284670a143e8d6b719fa8d4a53f8b1f5b6e3fc3bc21fa3f30c522b9"}},{"ruleId":"D5","level":"warning","message":{"text":"Off the main sequence: FarmToTableData: FarmToTableData: abstractness 0.13, instability 0.00, distance 0.87 \u2014 zone of pain \u2014 concrete and heavily depended-on, so it\u0027s rigid to change."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"02a74fc892e639af01a585585d207898ceb77b1411adc497b8f06cb6bd2dd91a"}},{"ruleId":"D12","level":"warning","message":{"text":"Deprecated: Azure.Identity: Azure.Identity 1.14.2 \u2014 Other"},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"2c48b8b518e33f322169a01b4e304c093ae4e143a4f32e23f92274ffeccb9051"}},{"ruleId":"D16","level":"warning","message":{"text":"single-maintainer \u2014 knowledge-concentration (bus factor) risk: single-maintainer \u2014 knowledge-concentration (bus factor) risk (1 author(s) across 23 commit(s) sampled)."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"b4b49d961df742f0e507f4cc5c8094fb077ba0391a27fd015d18320865187719"}},{"ruleId":"D18","level":"note","message":{"text":"Thin analysable surface across projects: 2 project(s) carry only a thin slice of real code (e.g. \u0060FarmToTableTests\u0060 with 20 significant line(s)). The mean analysable-surface weight is 78 %, lowering Solution Shape by about 1.7 point(s). Consolidate thin projects or grow them into substantial, well-scoped assemblies."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"dd0b92fd965c2065080f16843920964ee00f7696ea03d87cdf61aed4cd2c746a"}},{"ruleId":"D20","level":"note","message":{"text":"No ADRs found: No ADRs found at common paths; consider documenting architectural decisions in Docs/ADL/ or similar."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"d2bea044ff79d7d275f5a91a6e2f548586178eaf480274c33960ad020c854631"}},{"ruleId":"D23","level":"note","message":{"text":"Bounded contexts not declared: At 20k LoC across six projects the codebase is large and multi-module, so explicit bounded contexts are needed. Declare architecture.contexts (\u22652) in config to assess cross-boundary type coupling."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"1c7e276c9c682731f01819ed5378b90ca320cde1b583c90920172911598362b3"}},{"ruleId":"D24","level":"note","message":{"text":"misleading comment: \u0022no changes ever in db\u0022 \u2014 fix - the line actually creates a new change; this is a stale no-op comment"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"FarmToTablePublisher/Data/ProducerClientBase.cs"},"region":{"startLine":57}}}],"partialFingerprints":{"codehealthFindingId/v1":"59dec42aeadc582fb30e61774a9391b00bef0e6828a4fa48ea96d381893c94ca"}},{"ruleId":"D24","level":"note","message":{"text":"misleading comment: \u0022log sequence numbrs are always byte[10]\u0022 \u2014 fix - the field is an int, not byte[10]; correct the comment or remove it"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"FarmToTablePublisher/Data/ProducerClientBase.cs"},"region":{"startLine":129}}}],"partialFingerprints":{"codehealthFindingId/v1":"59dec42aeadc582fb30e61774a9391b00bef0e6828a4fa48ea96d381893c94ca"}},{"ruleId":"D24","level":"note","message":{"text":"redundant comment: \u0022poll CDC tables and publish loop\u0022 \u2014 trim - the while loop already says poll; keep only the non-obvious WHY part"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"FarmToTablePublisher/Program.cs"},"region":{"startLine":29}}}],"partialFingerprints":{"codehealthFindingId/v1":"d1307ac63d1d84e971e08aad1818fbacdfade50a78f48b6d859e7334eedb6de3"}},{"ruleId":"D31","level":"error","message":{"text":"Critical IaC: AZU-0004: Ensure the Function App can only be accessed via HTTPS. The default is false."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"458cd3106a37041c38bc02b174d72b5390af4938853d1cfc0760a110cde95761"}},{"ruleId":"D31","level":"error","message":{"text":"Critical IaC: AZU-0012: The default action on Storage account network rules should be set to deny"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"bb74fdf71c66a0cc81730a9be1550bef5a75c61ce4816108b72eaf442faae336"}},{"ruleId":"D31","level":"error","message":{"text":"Critical IaC: AZU-0013: Key vault should have the network acl block specified"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"6695feab98b8b3d2ec35fde7395e3493986111e878104738ce38e5d4e1b9f3ff"}},{"ruleId":"D31","level":"warning","message":{"text":"Medium IaC: AZU-0003: App Service authentication is activated"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"d1aeb30a88527b2616d7a3dbc2f90616cf98574db3962952b555242cf3b2008b"}},{"ruleId":"D31","level":"warning","message":{"text":"Medium IaC: AZU-0016: Key vault should have purge protection enabled"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"1e82d7531e214db581aaaec66ace127cc6d4308c4db4819e4b16665d19ac5511"}},{"ruleId":"D31","level":"warning","message":{"text":"Medium IaC: AZU-0057: Storage account should have logging enabled"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"6864733721ec3937d6f0112920e006652e47077f2d9c741b5fae052f4c09d205"}},{"ruleId":"D31","level":"warning","message":{"text":"Medium IaC: AZU-0060: Storage account should use customer-managed keys for encryption"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"585928bc356a667c012b5ba50451c149e834deaf4f702175d68bda3d79445ff3"}},{"ruleId":"D31","level":"warning","message":{"text":"Medium IaC: AZU-0061: Storage account should have infrastructure encryption enabled"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"a64288843ff91cf8af405e111cb5f549a98a3df77a5017aef6d49918987c57a3"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0001: Web App accepts incoming client certificate"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"36b4e3d42376d96960a332bf0db72d7ac99a431eef6cb79163d07d23464635c3"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0002: Web App has registration with AD enabled"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"07b15854cb27dc2c32cc018e37291939bce88d1baf51b0c70b6f16ca12d114f9"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0005: Web App uses the latest HTTP version"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"f9555680964b693768f01d38ebc4e02c3dbeab1dcf6c79730182c3989a4cf426"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0015: Key vault Secret should have a content type set"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"21ca64bd0460f5e7a166d8d47c130415ec59c405e2c0fc3a70756a93061b9afd"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0015: Key vault Secret should have a content type set"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"21ca64bd0460f5e7a166d8d47c130415ec59c405e2c0fc3a70756a93061b9afd"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0017: Key Vault Secret should have an expiration date set"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"4df8191e58d7cd832a04e968ba518df5a6845cc99e5450d68123e15fcb772da5"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0017: Key Vault Secret should have an expiration date set"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"4df8191e58d7cd832a04e968ba518df5a6845cc99e5450d68123e15fcb772da5"}},{"ruleId":"D31","level":"note","message":{"text":"Low IaC: AZU-0058: Storage account should use geo-redundant replication"},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"infrastructure/main.tf"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"69cfca12373616a937a8f051b1631b785003d53b6ff16b4d3d3f069f3dba3293"}},{"ruleId":"D36","level":"note","message":{"text":"No build provenance: No SLSA provenance generation or build attestation found in CI (e.g. slsa-github-generator, actions/attest-build-provenance)."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"1b213f6eedd4b140d0bc37bdf1496f72811a643f34064f12518b32e9e83bcfc7"}},{"ruleId":"D36","level":"note","message":{"text":"No artifact signing: No artifact signing found in CI (e.g. cosign / sigstore / gitsign)."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"0e17f71490e4d120a48b2b2881ab866c93b272bef2febb673a3e8e42b2c288ab"}},{"ruleId":"D36","level":"note","message":{"text":"No SBOM: No SBOM generation or committed SBOM found (e.g. syft / anchore/sbom-action / *.spdx.json / *.cdx.json)."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"eb00976a698a5d68999b7ee6d27206fd374e916853e7ff1ead5eed42386f043f"}},{"ruleId":"D36","level":"warning","message":{"text":"Unpinned build actions: CI references GitHub Actions by a floating ref (@main / @tag) rather than a pinned commit SHA, weakening build integrity."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"90f83b4fa27db32740afe9540c905f3c0499caed87f61049a8a903ecc95b41c3"}}],"taxonomies":[{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d","organization":"MITRE","shortDescription":{"text":"The MITRE Common Weakness Enumeration (CWE)."},"taxa":[{"id":"CWE-1357","name":"Reliance on Insufficiently Trustworthy Component"},{"id":"CWE-1395","name":"Dependency on Vulnerable Third-Party Component"},{"id":"CWE-798","name":"Use of Hard-coded Credentials"}]}],"properties":{"codehealthPublication":{"public":true,"notice":"This is the PUBLIC form of this artifact. Findings are listed in full, but the details of SECURITY findings \u2014 which rule fired, in which file, on which line, and how to fix it \u2014 are deliberately withheld, and any secret-scanner results are excluded entirely. Where detail is absent here it was REMOVED FOR PUBLICATION; it is not missing from the analysis. The complete artifact is available from the repository owner.","securityFindingsRedacted":0,"secretScannerRunsExcluded":0}}}]}