API Keys

API Keys für UTM Monitoring nutzen

Letzte Anpassung: 07.2023

Neu:

Bestehendes Dashboard-Beispiel aktualisiert
Neues Dashboard-Beispiele ergänzt

notempty

Dieser Artikel bezieht sich auf eine Resellerpreview

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

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.

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:

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: 30s # Do not edit scrape_timeout: 10s 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.

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
Burger-Menü oben links: Connections
Menü Links: 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

Das Ergebnis sollte in etwa so wie dieses Dashboard aussehen.

Burger-Menü oben links: Dashboards
Blaues Dropdownmenü rechts: New 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

Burger-Menü oben links: Dashboards
Blaues Dropdownmenü rechts: New 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