Letzte Anpassung: 08.2023
- Der Wert für scrape_timeout in der Prometheus Beispiel Konfiguration wurde auf 30s erhöht
- Der Wert für scrape_interval in der Prometheus Beispiel Konfiguration wurde auf 60s erhöht
- Bestehendes Dashboard-Beispiel aktualisiert 07.2023
- Neues Dashboard-Beispiele ergänzt 07.2023
Funktionsumfang
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
In Zwischenablage kopieren Kopiert den API Key in die Zwischenablage. Von hier kann er in andere Anwendungen eingefügt werden.
Anwendungsbeispiel
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)
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:
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'
scrape_interval: 60s # Do not edit
scrape_timeout: 30s
metrics_path: /sms-mgt-api/api/2.0/metrics
scheme: https
bearer_token: 'eyJhbGciOiJIUzI1NiIsInR5...'
static_configs:
- targets:
- portal.securepoint.cloud
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.Ein Aufruf der Prometheus-Seite im Menü / Targets im Browser sollte ein Ergebnis ähnlich dem nebenstehend gezeigten bieten.
Grafana Konfiguration
Datenquelle hinzufügen
- Aufruf von Grafana im Webbrowser
- Burger-Menü oben links: Connections
- Menü Links:
- Schaltfläche:
- Prometheus wählen
- URL des Prometheus-Servers mit Port angeben. Z.B.: http://localhost:9090
- Speichern mit
Grafana Dashboard konfigurieren
Beispiel 1
- Burger-Menü oben links: Dashboards
- Blaues Dropdownmenü rechts:
- 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": "" }
Beispiel 2
- Burger-Menü oben links: Dashboards
- Blaues Dropdownmenü rechts:
- 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": "" }