USC/Api-Keys

---

API Keys für UTM Monitoring nutzen

Neuer Artikel zur Version: 1.15

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.

---

Anwendungsbeispiel

Hinweis
Dieser Artikel 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)

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

<Als bearer_token wird der Wert des API Keys (mit Hochkommata) eingetragen./li>

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