Self-Assessment-Uebersicht

Automatische Aggregation aller Self-Assessment-Reifegrade pro Norm. Aktualisiert via Dataview.

---

Durchschnittlicher Reifegrad pro Norm

TABLE WITHOUT ID
  norm AS "Norm",
  round(average(rows.reifegrad), 1) AS "Ø Reifegrad",
  min(rows.reifegrad) AS "Min",
  max(rows.reifegrad) AS "Max",
  length(rows) AS "Controls"
FROM "IMS" OR "ISMSI" OR "QMS" OR "ISDS2"
WHERE type = "control" AND reifegrad != null
GROUP BY norm
SORT norm ASC

---

Controls mit Reifegrad < 3 (Handlungsbedarf)

TABLE
  title AS "Control",
  norm AS "Norm",
  chapter AS "Kapitel",
  reifegrad AS "Reifegrad",
  bewertet_am AS "Bewertet am"
FROM "IMS" OR "ISMSI" OR "QMS" OR "ISDS2"
WHERE type = "control" AND reifegrad < 3
SORT reifegrad ASC

---

Reifegrad pro Kapitel (ISO 27001)

TABLE WITHOUT ID
  chapter AS "Kapitel",
  round(average(rows.reifegrad), 1) AS "Ø Reifegrad",
  length(rows) AS "Controls",
  length(filter(rows, (r) => r.reifegrad < 3)) AS "< Stufe 3"
FROM "ISMSI"
WHERE type = "control" AND norm = "ISO 27001"
GROUP BY chapter
SORT chapter ASC

---

Reifegrad-Verteilung (alle Normen)

TABLE WITHOUT ID
  reifegrad AS "Reifegrad",
  length(rows) AS "Anzahl Controls",
  round(length(rows) / 10 * 100, 0) + "%" AS "Anteil"
FROM "IMS" OR "ISMSI" OR "QMS" OR "ISDS2"
WHERE type = "control" AND reifegrad != null
GROUP BY reifegrad
SORT reifegrad ASC

---

ISO 27001 — Detailansicht

TABLE
  title AS "Control",
  chapter AS "Kapitel",
  reifegrad AS "Reifegrad",
  bewertet_am AS "Bewertet am"
FROM "ISMSI"
WHERE type = "control" AND norm = "ISO 27001"
SORT chapter ASC

---

VDA ISA (TISAX) — Detailansicht

TABLE
  title AS "Control",
  chapter AS "Kapitel",
  reifegrad AS "Reifegrad",
  bewertet_am AS "Bewertet am"
FROM "ISMSI"
WHERE type = "control" AND norm = "VDA ISA"
SORT chapter ASC

---

ISO 9001 — Detailansicht

TABLE
  title AS "Control",
  chapter AS "Kapitel",
  reifegrad AS "Reifegrad",
  bewertet_am AS "Bewertet am"
FROM "QMS"
WHERE type = "control" AND norm = "ISO 9001"
SORT chapter ASC

---

NIS2 — Detailansicht

TABLE
  title AS "Control",
  chapter AS "Kapitel",
  reifegrad AS "Reifegrad",
  bewertet_am AS "Bewertet am"
FROM "ISMSI"
WHERE type = "control" AND norm = "NIS2"
SORT chapter ASC

---

DSGVO — Detailansicht

TABLE
  title AS "Control",
  chapter AS "Kapitel",
  reifegrad AS "Reifegrad",
  bewertet_am AS "Bewertet am"
FROM "ISDS2"
WHERE type = "control" AND norm = "DSGVO"
SORT chapter ASC

---

Änderungshistorie

Datum	Autor	Änderung
2026-02-15	Visitrans	Execute SPEC-03: Plugins, templates, dashboards, placeholder replacement
2026-02-14	Visitrans	Execute SPEC-01: Bulk-Export 646 Confluence pages to Obsidian vault