USC/Api-Keys

| Grafana Configuration }}

---

API Keys für UTM Monitoring nutzen

Letzte Anpassung zur Version: 1.28

Neu:

• Konfiguration aktualisiert

notempty

Dieser Artikel bezieht sich auf eine Resellerpreview

-

Aufruf: portal.securepoint.cloud  Allgemein API Keys

---

Funktionsumfang

API Keys im USC Portal

API Keys ermöglichen für andere Anwendungen eine Authentifizierung im USC Portal.
Dabei haben die API Keys einen festgelegten Geltungsbereich der z.Zt. ausschließlich Metriken für ein Monitoring umfasst.

---

API Key hinzufügen

 API Key hinzufügen

Beschriftung	Wert	Beschreibung	API Key
Name	UTMs TTT-Point	Aussagekräftiger Name für den API-Key
Mandanten	TTT-Point AG	Mandanten, für die die API Werte ausgibt. Wird kein Mandant angegeben, werden Werte für sämtliche Mandanten und den Reseller selbst ausgegeben! Dieses Feld kann nachträglich nicht geändert werden
Geltungsbereich	Metrics	Geltungsbereich für den API-Key. Z.Zt. ausschließlich Metrics verfügbar Dieses Feld kann nachträglich nicht geändert werden
Ablaufdatum	Wählen Sie ein Datum	Es muss ein Ablaufdatum gewählt werden. Soll die Geltungsdauer später geändert werden, ist es lediglich möglich, den API-Key zu löschen. Dieses Feld kann nachträglich nicht geändert werden
Kommentar		Freies Textfeld
Speichern	Legt den API-Key an und schließt den Dialog. Die Werte für Mandanten, Geltungsbereich und Ablaufdatum können anschließend nicht mehr geändert werden.
In Zwischenablage kopieren	Kopiert den API Key in die Zwischenablage. Von hier kann er in andere Anwendungen eingefügt werden.
Abgelaufene API Keys ausblenden notempty Neu ab: 1.28	API Keys die abgelaufen sind, lassen sich über diese Schaltfläche ausblenden. Diese API Keys besitzen das Label  Abgelaufen.

---

Anwendungsbeispiel

Hinweis
Dieser Abschnitt beinhaltet Beschreibungen der Software von Drittanbietern und basiert auf dem Stand zum Zeitpunkt der Erstellung dieser Seite.
Änderungen an der Benutzeroberfläche durch den Hersteller sind jederzeit möglich und müssen in der Durchführung entsprechend berücksichtigt werden.
Alle Angaben ohne Gewähr.

Das folgende Beispiel setzt eine funktionsfähige Installation folgender Produkte voraus:

• Linux VM
• Prometheus (Opensource Monitroing)
• Grafana (Open-Source-Anwendung zur grafischen Darstellung von Daten)
• ngninx (Webserver)
  

notempty

Keine Unterstützung durch unseren Support für Fremdprodukte
Wir leisten keinerlei Support für diese Anwendungen und können keine Unterstützung für Installation oder Konfiguration geben.
Es werden hier lediglich Anwendungs-Szenarien für API Keys gezeigt.

---

Prometheus Konfiguration bearbeiten

Öffnen der Konfigurationsdatei von Prometheus z. B. mit Editor nano sudo nano /etc/prometheus/prometheus.yml

Abschnitt scrape_configs: notempty

Aktualisiert zu v1.28

scrape_configs: # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config. - job_name: 'securepoint_cloud_metrics_2.2' scrape_interval: 60s # Do not edit scrape_timeout: 30s metrics_path: /sms-mgt-api/api/2.0/metrics params: version: [2.2] scheme: https bearer_token: 'eyJhbGciOiJIUzI1NiIsInR5...' static_configs: - targets: - portal.securepoint.cloud

Als bearer_token wird der Wert des API Keys (mit Hochkommata) eingetragen.

Anschließend Konfiguration speichern und den Dienst neu starten. sudo systemctl restart prometheus

Der Befehl sudo systemctl status prometheus.service zeigt, ob der Dienst korrekt starten konnte.

verlassen der Ergebnis-Anzeige mit Taste q

Ein Aufruf der Prometheus-Seite im Menü Status / Targets im Browser sollte ein Ergebnis ähnlich dem nebenstehend gezeigten bieten.

---

Grafana Konfiguration

Datenquelle hinzufügen

• Aufruf von Grafana im Webbrowser
• Im Seitenmenü: Connections
  In älteren Versionen Burger Menü oben links
• Menüpunkt Data soures
• Schaltfläche: Add new data source
• Prometheus wählen
• URL des Prometheus-Servers mit Port angeben, z.B.: http://localhost:9090
• Speichern mit Save & test

Grafana Dashboard konfigurieren

Beispiel 1 - Grafische Darstellung

Beispiel 1

UTMs Online/offline/Firmware-Version (Graphische Darstellung)

Das Ergebnis sollte in etwa so wie dieses Dashboard aussehen.

• in der Menüleiste
• Schaltfläche  Import
• Im Feld Import via panel json folgenden Code eintragen:

{ "__inputs": [ { "name": "DS_PROMETHEUS", "label": "Prometheus", "description": "", "type": "datasource", "pluginId": "prometheus", "pluginName": "Prometheus" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "9.3.6" }, { "type": "datasource", "id": "prometheus", "name": "Prometheus", "version": "1.0.0" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": null, "links": [], "liveNow": false, "panels": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "decimals": 0, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "UTMs" }, "overrides": [] }, "gridPos": { "h": 5, "w": 20, "x": 0, "y": 0 }, "id": 5, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "expr": "sum(utm_usc_online_status == 1)", "legendFormat": "__auto", "range": true, "refId": "A" } ], "title": "UTMs online", "type": "timeseries" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-green", "value": 100 } ] }, "unit": "string" }, "overrides": [] }, "gridPos": { "h": 5, "w": 4, "x": 20, "y": 0 }, "id": 7, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "last" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": false }, "pluginVersion": "9.3.6", "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "expr": "sum(utm_usc_online_status == 1)", "legendFormat": "__auto", "range": true, "refId": "A" } ], "title": "UTMs online", "type": "gauge" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "dark-green", "mode": "thresholds" }, "custom": { "align": "left", "displayMode": "auto", "inspect": false }, "mappings": [ { "options": { "0": { "index": 0, "text": "OFFLINE" }, "1": { "index": 1, "text": "ONLINE" }, "-1": { "index": 2, "text": "⁣" } }, "type": "value" } ], "max": 1, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-green", "value": 1 } ] }, "unit": "none" }, "overrides": [ { "matcher": { "id": "byName", "options": "Status" }, "properties": [ { "id": "custom.displayMode", "value": "color-background" }, { "id": "custom.width", "value": 77 }, { "id": "custom.align", "value": "center" } ] }, { "matcher": { "id": "byName", "options": "device_id" }, "properties": [ { "id": "links", "value": [ { "targetBlank": true, "title": "UTM im Unified Security Portal anzeigen", "url": "https://portal.securepoint.cloud/sms/#show-tenant-${__data.fields.Domäne}-usc-utms-${__data.fields.Geräte-ID}" } ] } ] }, { "matcher": { "id": "byName", "options": "last_contact" }, "properties": [ { "id": "unit", "value": "dateTimeFromNow" } ] }, { "matcher": { "id": "byName", "options": "update" }, "properties": [ { "id": "custom.displayMode", "value": "color-background" }, { "id": "mappings", "value": [ { "options": { "none": { "color": "transparent", "index": 1, "text": "Nicht verfügbar" } }, "type": "value" }, { "options": { "pattern": "\\s*", "result": { "color": "transparent", "index": 0, "text": "Nicht verfügbar" } }, "type": "regex" }, { "options": { "pattern": ".+", "result": { "color": "dark-green", "index": 2 } }, "type": "regex" } ] } ] }, { "matcher": { "id": "byName", "options": "virusscanner_lastrun" }, "properties": [ { "id": "unit", "value": "dateTimeFromNow" } ] }, { "matcher": { "id": "byName", "options": "virusscanner_updated" }, "properties": [ { "id": "unit", "value": "dateTimeFromNow" } ] }, { "matcher": { "id": "byName", "options": "update_version" }, "properties": [ { "id": "mappings", "value": [ { "options": { "pattern": "\\d+.*", "result": { "color": "dark-green", "index": 0 } }, "type": "regex" }, { "options": { "pattern": ".+", "result": { "color": "transparent", "index": 1 } }, "type": "regex" }, { "options": { "match": "empty", "result": { "color": "transparent", "index": 2 } }, "type": "special" } ] }, { "id": "custom.displayMode", "value": "color-background" } ] } ] }, "gridPos": { "h": 8, "w": 24, "x": 0, "y": 5 }, "id": 3, "options": { "footer": { "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [ { "desc": true, "displayName": "Update-Version" } ] }, "pluginVersion": "9.3.6", "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "exemplar": false, "expr": "sort(utm_usc_online_status{})", "format": "table", "hide": false, "instant": true, "legendFormat": "__auto", "range": false, "refId": "A" } ], "title": "UTMs", "transformations": [ { "id": "organize", "options": { "excludeByName": { "Time": true, "__name__": true, "instance": true, "job": true }, "indexByName": { "Time": 4, "Value": 3, "__name__": 5, "accountname": 1, "device_id": 9, "hostname": 2, "instance": 13, "job": 14, "last_contact": 6, "tenant_domain": 0, "update_version": 8, "version": 7, "virusscanner_lastrun": 11, "virusscanner_status": 10, "virusscanner_updated": 12 }, "renameByName": { "Time": "", "Value": "Status", "__name__": "", "accountname": "Account-Name", "device_id": "Geräte-ID", "hostname": "Hostname", "instance": "", "job": "", "last_contact": "Letzter Kontakt", "name": "UTM-Name", "tenant_domain": "Domäne", "update": "Firmware-Update", "update_version": "Update-Version", "version": "Firmware-Version", "virusscanner_lastrun": "Virusscanner-Lauf", "virusscanner_status": "Virusscanner-Status", "virusscanner_updated": "Virusscanner-Update" } } }, { "id": "convertFieldType", "options": { "conversions": [ { "destinationType": "number", "targetField": "Letzter Kontakt" }, { "destinationType": "number", "targetField": "virusscanner_lastrun" }, { "destinationType": "number", "targetField": "virusscanner_updated" } ], "fields": {} } }, { "id": "organize", "options": { "excludeByName": {}, "indexByName": { "Account-Name": 1, "Domäne": 0, "Firmware-Version": 5, "Geräte-ID": 7, "Hostname": 2, "Letzter Kontakt": 4, "Status": 3, "Update-Version": 6, "Virusscanner-Lauf": 8, "Virusscanner-Status": 10, "Virusscanner-Update": 9 }, "renameByName": {} } } ], "type": "table" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "custom": { "align": "left", "displayMode": "auto", "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-orange", "value": 30 }, { "color": "dark-green", "value": 60 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "Value" }, "properties": [ { "id": "custom.displayMode", "value": "color-background" } ] }, { "matcher": { "id": "byName", "options": "Noch gültig" }, "properties": [ { "id": "unit", "value": "Tage" } ] }, { "matcher": { "id": "byName", "options": "NFR" }, "properties": [ { "id": "mappings", "value": [ { "options": { "false": { "index": 1, "text": "Nein" }, "true": { "index": 0, "text": "Ja" } }, "type": "value" } ] }, { "id": "custom.width", "value": 68 } ] }, { "matcher": { "id": "byName", "options": "Lizenz-Typ" }, "properties": [ { "id": "custom.width", "value": 116 } ] }, { "matcher": { "id": "byName", "options": "Lizenz-ID" }, "properties": [ { "id": "custom.width", "value": 89 } ] }, { "matcher": { "id": "byName", "options": "Lizenz-ID" }, "properties": [ { "id": "links", "value": [ { "targetBlank": true, "title": "Lizenz im Reseller-Portal anzeigen", "url": "https://my.securepoint.de/2.0/licenses/${__data.fields.Lizenz-ID}" } ] } ] }, { "matcher": { "id": "byName", "options": "license_uuid" }, "properties": [ { "id": "links", "value": [ { "targetBlank": true, "title": "UTM im Unified Security Portal anzeigen", "url": "https://portal.securepoint.cloud/sms/#show-tenant-${__data.fields.Domäne}-usc-utms-${__data.fields.Geräte-ID}" } ] }, { "id": "custom.width", "value": 108 } ] }, { "matcher": { "id": "byName", "options": "Domäne" }, "properties": [ { "id": "custom.width", "value": 102 } ] } ] }, "gridPos": { "h": 8, "w": 24, "x": 0, "y": 13 }, "id": 1, "options": { "footer": { "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [] }, "pluginVersion": "9.3.6", "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "exemplar": false, "expr": "sort(utm_license_days_valid)", "format": "table", "hide": false, "instant": true, "interval": "", "key": "Q-9474a811-7756-42b1-ba32-22e507638503-0", "legendFormat": "__auto", "range": false, "refId": "A" } ], "title": "Lizenzen", "transformations": [ { "id": "filterFieldsByName", "options": { "include": { "names": [ "accountname", "license_creation_date", "license_displayname", "license_expiration_date", "license_id", "license_nfr", "license_type", "license_user", "license_uuid", "permission_affix", "tenant_domain", "Value" ] } } }, { "id": "organize", "options": { "excludeByName": { "permission_affix": true }, "indexByName": { "Value": 3, "accountname": 1, "license_creation_date": 4, "license_displayname": 2, "license_expiration_date": 5, "license_id": 6, "license_nfr": 7, "license_type": 8, "license_user": 9, "license_uuid": 10, "permission_affix": 11, "tenant_domain": 0 }, "renameByName": { "Value": "Noch gültig", "accountname": "Account-Name", "license_creation_date": "Erstellt am", "license_displayname": "Lizenz-Name", "license_expiration_date": "Gültig bis", "license_id": "Lizenz-ID", "license_nfr": "NFR", "license_type": "Lizenz-Typ", "license_user": "Anzahl Benutzer", "license_uuid": "Geräte-ID", "permission_affix": "", "tenant_domain": "Domäne" } } } ], "type": "table" } ], "refresh": "30s", "schemaVersion": 37, "style": "dark", "tags": [], "templating": { "list": [ { "datasource": { "type": "prometheus", "uid": "ftmKeWRRz" }, "filters": [], "hide": 0, "name": "Filters", "skipUrlSync": false, "type": "adhoc" } ] }, "time": { "from": "now-15m", "to": "now" }, "timepicker": {}, "timezone": "", "title": "USC Monitoring II", "uid": "r38u25RRz", "version": 43, "weekStart": "" }

• Schaltfläche Load
• Datenquelle wählen: Select a Prometheus data source
• Schaltfläche Import

---

Beispiel 2 - UTMs Tabellarische Darstellung

Beispiel 2

UTMs Tabellarische Darstellung

Dashboard mit grafischer Anzeige der UTM (online/offline/Firmware-Version)

• in der Menüleiste
• Schaltfläche  Import
• Im Feld Import via panel json folgenden Code eintragen:

{ "__inputs": [ { "name": "DS_PROMETHEUS", "label": "Prometheus", "description": "", "type": "datasource", "pluginId": "prometheus", "pluginName": "Prometheus" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "9.3.6" }, { "type": "datasource", "id": "prometheus", "name": "Prometheus", "version": "1.0.0" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "grafana", "uid": "-- Grafana --" }, "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "target": { "limit": 100, "matchAny": false, "tags": [], "type": "dashboard" }, "type": "dashboard" } ] }, "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 0, "id": 16, "links": [], "liveNow": false, "panels": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "text", "value": null }, { "color": "green", "value": 1 } ] } }, "overrides": [] }, "gridPos": { "h": 8, "w": 5, "x": 0, "y": 0 }, "id": 10, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "10.0.2", "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "expr": "sum(utm_usc_online_total)", "legendFormat": "__auto", "range": true, "refId": "A" } ], "title": "UTMs online", "type": "gauge" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 1 } ] } }, "overrides": [] }, "gridPos": { "h": 8, "w": 5, "x": 5, "y": 0 }, "id": 9, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "10.0.2", "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "expr": "sum(utm_usc_offline_total)", "legendFormat": "__auto", "range": true, "refId": "A" } ], "title": "UTMs offline", "type": "gauge" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "hideFrom": { "legend": false, "tooltip": false, "viz": false } }, "mappings": [], "unit": "none" }, "overrides": [] }, "gridPos": { "h": 8, "w": 4, "x": 10, "y": 0 }, "id": 8, "options": { "legend": { "displayMode": "table", "placement": "bottom", "showLegend": true, "values": [ "value", "percent" ] }, "pieType": "pie", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "exemplar": false, "expr": "sum by (version) (utm_usc_online_status{last_contact!=\"-1\"})", "format": "heatmap", "hide": false, "instant": false, "interval": "", "legendFormat": "{{label_name}}", "range": true, "refId": "A" } ], "title": "Firmware - Verteilung", "type": "piechart" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 0, "gradientMode": "none", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "lineInterpolation": "linear", "lineWidth": 1, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "auto", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "decimals": 0, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "UTMs" }, "overrides": [] }, "gridPos": { "h": 8, "w": 10, "x": 14, "y": 0 }, "id": 5, "options": { "legend": { "calcs": [], "displayMode": "list", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "expr": "sum by (accountname) (utm_usc_online_status)", "legendFormat": "__auto", "range": true, "refId": "A" } ], "title": "UTMs online", "type": "timeseries" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "dark-green", "mode": "thresholds" }, "custom": { "align": "left", "cellOptions": { "type": "auto" }, "inspect": false }, "mappings": [ { "options": { "0": { "index": 0, "text": "OFFLINE" }, "1": { "index": 1, "text": "ONLINE" }, "-1": { "index": 2, "text": "⁣" } }, "type": "value" } ], "max": 1, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-green", "value": 1 } ] }, "unit": "none" }, "overrides": [ { "matcher": { "id": "byName", "options": "Status" }, "properties": [ { "id": "custom.cellOptions", "value": { "mode": "gradient", "type": "color-background" } }, { "id": "custom.width", "value": 77 }, { "id": "custom.align", "value": "center" } ] }, { "matcher": { "id": "byName", "options": "device_id" }, "properties": [ { "id": "links", "value": [ { "targetBlank": true, "title": "UTM im Unified Security Portal anzeigen", "url": "https://portal.securepoint.cloud/sms/#show-tenant-${__data.fields.Domäne}-usc-utms-${__data.fields.Geräte-ID}" } ] } ] }, { "matcher": { "id": "byName", "options": "last_contact" }, "properties": [ { "id": "unit", "value": "dateTimeFromNow" } ] }, { "matcher": { "id": "byName", "options": "update" }, "properties": [ { "id": "custom.cellOptions", "value": { "mode": "gradient", "type": "color-background" } }, { "id": "mappings", "value": [ { "options": { "none": { "color": "transparent", "index": 1, "text": "Nicht verfügbar" } }, "type": "value" }, { "options": { "pattern": "\\s*", "result": { "color": "transparent", "index": 0, "text": "Nicht verfügbar" } }, "type": "regex" }, { "options": { "pattern": ".+", "result": { "color": "dark-green", "index": 2 } }, "type": "regex" } ] } ] }, { "matcher": { "id": "byName", "options": "WebSession" }, "properties": [ { "id": "mappings", "value": [ { "options": { "0": { "index": 0, "text": "⁣" }, "1": { "index": 1, "text": "Starte WebSession" } }, "type": "value" } ] }, { "id": "links", "value": [ { "title": "Starte WebSession", "url": "" } ] } ] }, { "matcher": { "id": "byName", "options": "virusscanner_lastrun" }, "properties": [ { "id": "unit", "value": "dateTimeFromNow" }, { "id": "mappings", "value": [] } ] }, { "matcher": { "id": "byName", "options": "virusscanner_updated" }, "properties": [ { "id": "unit", "value": "dateTimeFromNow" } ] }, { "matcher": { "id": "byName", "options": "update_version" }, "properties": [ { "id": "mappings", "value": [ { "options": { "none": { "color": "green", "index": 3 } }, "type": "value" }, { "options": { "pattern": "\\d+.*", "result": { "color": "yellow", "index": 0 } }, "type": "regex" }, { "options": { "pattern": ".+", "result": { "color": "transparent", "index": 1 } }, "type": "regex" }, { "options": { "match": "empty", "result": { "color": "transparent", "index": 2 } }, "type": "special" } ] }, { "id": "custom.cellOptions", "value": { "mode": "gradient", "type": "color-background" } } ] }, { "matcher": { "id": "byName", "options": "Hostname" }, "properties": [ { "id": "links", "value": [ { "targetBlank": true, "title": "", "url": "https://${__value.text}:11115" } ] } ] } ] }, "gridPos": { "h": 8, "w": 24, "x": 0, "y": 8 }, "id": 3, "options": { "cellHeight": "sm", "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [ { "desc": false, "displayName": "Domäne" } ] }, "pluginVersion": "10.0.2", "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "exemplar": false, "expr": "sort(utm_usc_online_status)", "format": "table", "hide": false, "instant": true, "legendFormat": "__auto", "range": false, "refId": "A" } ], "title": "UTMs", "transformations": [ { "id": "organize", "options": { "excludeByName": { "Time": true, "__name__": true, "instance": true, "job": true }, "indexByName": { "Time": 4, "Value": 3, "__name__": 5, "accountname": 1, "device_id": 9, "hostname": 2, "instance": 13, "job": 14, "last_contact": 6, "tenant_domain": 0, "update_version": 8, "version": 7, "virusscanner_lastrun": 11, "virusscanner_status": 10, "virusscanner_updated": 12 }, "renameByName": { "Time": "", "Value": "Status", "__name__": "", "accountname": "Account-Name", "device_id": "Geräte-ID", "hostname": "Hostname", "instance": "", "job": "", "last_contact": "Letzter Kontakt", "name": "UTM-Name", "tenant_domain": "Domäne", "update": "Firmware-Update", "update_version": "Update-Version", "version": "Firmware-Version", "virusscanner_lastrun": "Virusscanner-Lauf", "virusscanner_status": "Virusscanner-Status", "virusscanner_updated": "Virusscanner-Update" } } }, { "disabled": true, "id": "calculateField", "options": { "alias": "WebSession", "mode": "reduceRow", "reduce": { "include": [ "Status" ], "reducer": "last" } } }, { "id": "convertFieldType", "options": { "conversions": [ { "destinationType": "number", "targetField": "Letzter Kontakt" }, { "destinationType": "number", "targetField": "virusscanner_lastrun" }, { "destinationType": "number", "targetField": "virusscanner_updated" } ], "fields": {} } }, { "id": "organize", "options": { "excludeByName": {}, "indexByName": { "Account-Name": 1, "Domäne": 0, "Firmware-Version": 6, "Geräte-ID": 8, "Hostname": 2, "Letzter Kontakt": 5, "Status": 4, "Update-Version": 7, "Virusscanner-Lauf": 9, "Virusscanner-Status": 11, "Virusscanner-Update": 10, "WebSession": 3 }, "renameByName": {} } } ], "type": "table" }, { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "fieldConfig": { "defaults": { "custom": { "align": "left", "cellOptions": { "type": "auto" }, "filterable": true, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-orange", "value": 14 }, { "color": "dark-green", "value": 31 } ] } }, "overrides": [ { "matcher": { "id": "byName", "options": "Value" }, "properties": [ { "id": "custom.cellOptions", "value": { "mode": "gradient", "type": "color-background" } } ] }, { "matcher": { "id": "byName", "options": "Noch gültig" }, "properties": [ { "id": "unit", "value": "Tage" } ] }, { "matcher": { "id": "byName", "options": "NFR" }, "properties": [ { "id": "mappings", "value": [ { "options": { "false": { "index": 1, "text": "Nein" }, "true": { "index": 0, "text": "Ja" } }, "type": "value" } ] }, { "id": "custom.width", "value": 68 } ] }, { "matcher": { "id": "byName", "options": "Lizenz-Typ" }, "properties": [ { "id": "custom.width", "value": 116 } ] }, { "matcher": { "id": "byName", "options": "Lizenz-ID" }, "properties": [ { "id": "custom.width", "value": 89 } ] }, { "matcher": { "id": "byName", "options": "Lizenz-ID" }, "properties": [ { "id": "links", "value": [ { "targetBlank": true, "title": "Lizenz im Reseller-Portal anzeigen", "url": "https://my.securepoint.de/2.0/licenses/${__data.fields.Lizenz-ID}" } ] } ] }, { "matcher": { "id": "byName", "options": "license_uuid" }, "properties": [ { "id": "links", "value": [ { "targetBlank": true, "title": "UTM im Unified Security Portal anzeigen", "url": "https://portal.securepoint.cloud/sms/#show-tenant-${__data.fields.Domäne}-usc-utms-${__data.fields.Geräte-ID}" } ] }, { "id": "custom.width", "value": 108 } ] }, { "matcher": { "id": "byName", "options": "Domäne" }, "properties": [ { "id": "custom.width", "value": 102 } ] } ] }, "gridPos": { "h": 14, "w": 24, "x": 0, "y": 16 }, "id": 1, "options": { "cellHeight": "sm", "footer": { "countRows": false, "fields": "", "reducer": [ "sum" ], "show": false }, "showHeader": true, "sortBy": [ { "desc": false, "displayName": "Noch gültig" } ] }, "pluginVersion": "10.0.2", "targets": [ { "datasource": { "type": "prometheus", "uid": "${DS_PROMETHEUS}" }, "editorMode": "code", "exemplar": false, "expr": "utm_license_days_valid > 0", "format": "table", "hide": false, "instant": true, "interval": "", "key": "Q-9474a811-7756-42b1-ba32-22e507638503-0", "legendFormat": "{{label_name}}", "range": false, "refId": "A" } ], "title": "Lizenzen", "transformations": [ { "id": "filterFieldsByName", "options": { "include": { "names": [ "accountname", "license_creation_date", "license_displayname", "license_expiration_date", "license_id", "license_nfr", "license_type", "license_user", "license_uuid", "permission_affix", "tenant_domain", "Value" ] } } }, { "id": "organize", "options": { "excludeByName": { "permission_affix": true }, "indexByName": { "Value": 3, "accountname": 1, "license_creation_date": 4, "license_displayname": 2, "license_expiration_date": 5, "license_id": 6, "license_nfr": 7, "license_type": 8, "license_user": 9, "license_uuid": 10, "permission_affix": 11, "tenant_domain": 0 }, "renameByName": { "Value": "Noch gültig", "accountname": "Account-Name", "license_creation_date": "Erstellt am", "license_displayname": "Lizenz-Name", "license_expiration_date": "Gültig bis", "license_id": "Lizenz-ID", "license_nfr": "NFR", "license_type": "Lizenz-Typ", "license_user": "Anzahl Benutzer", "license_uuid": "Geräte-ID", "permission_affix": "", "tenant_domain": "Domäne" } } } ], "type": "table" } ], "refresh": "5m", "schemaVersion": 38, "style": "dark", "tags": [], "templating": { "list": [] }, "time": { "from": "now-2d", "to": "now" }, "timepicker": {}, "timezone": "", "title": "USC Monitoring I", "uid": "r38u25RRz", "version": 2, "weekStart": "" }

• Schaltfläche Load
• Datenquelle wählen: Select a Prometheus data source
• Schaltfläche Import

---

Dashboard mit Übersicht zu den betriebenen UTMs (online/offline/USC aktiv/Firmware-Verteilung/UTMs pro Endkunde)

Beispiel 3 - UTMs inkl. USC

Beispiel 3

notempty

Neu ab v1.28

UTMs inkl. USC

• in der Menüleiste
• Schaltfläche  Import
• Im Feld Import via grafana.com folgende ID eintragen: 20896
• Schaltfläche Load
• Datenquelle wählen: Select a Prometheus data source
• Schaltfläche Import

---

Dashboard mit nützlichen Informationen zu den Lizenzen (aktiv/weniger als 30 Tage/abgelaufen)

Beispiel 4 - Übersicht der Lizenzen

Beispiel 4

notempty

Neu ab v1.28

Übersicht der Lizenzen

• in der Menüleiste
• Schaltfläche  Import
• Im Feld Import via grafana.com folgende ID eintragen: 20898
• Schaltfläche Load
• Datenquelle wählen: Select a Prometheus data source
• Schaltfläche Import

---

Dashboard mit Übersicht zu dem MDM (Anzahl/Firmwareverteilung)

Beispiel 5 - MDM Dashboard

Beispiel 5

notempty

Neu ab v1.28

MDM Dashboard

Mobilgeräte mit Firmware Versionen

• in der Menüleiste
• Schaltfläche  Import
• Im Feld Import via grafana.com folgende ID eintragen: 20874
• Schaltfläche Load
• Datenquelle wählen: Select a Prometheus data source
• Schaltfläche Import

---

Dashboard mit Übersicht zu VPN Verbidnungen/Tunneln (MobSec Verbindungen/Tunnel Status/USC VPN Verbindungen)

Beispiel 6 - VPN Übersicht

Beispiel 6

notempty

Neu ab v1.28

VPN Verbindungen/Tunnel Übersicht

• in der Menüleiste
• Schaltfläche  Import
• Im Feld Import via grafana.com folgende ID eintragen: 20897
• Schaltfläche Load
• Datenquelle wählen: Select a Prometheus data source
• Schaltfläche Import