Created
June 19, 2023 10:36
-
-
Save samm-git/3524577f52f38b7bb8ecd7f4aa422caa to your computer and use it in GitHub Desktop.
grafana PSU dashboard
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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" | |
| } | |
| ] | |
| }, | |
| "description": "Power supply unit statistic", | |
| "editable": true, | |
| "fiscalYearStartMonth": 0, | |
| "graphTooltip": 0, | |
| "id": 9, | |
| "links": [], | |
| "liveNow": false, | |
| "panels": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "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" | |
| } | |
| }, | |
| "mappings": [], | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "mvolt" | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Voltage" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "unit", | |
| "value": "mvolt" | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Current" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "unit", | |
| "value": "mamp" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 12, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 6, | |
| "interval": "10s", | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "displayMode": "list", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "targets": [ | |
| { | |
| "alias": "Voltage", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "ubntPowerOutVoltage.1" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Current", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "ubntPowerOutCurrent.1" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Output voltage/current", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "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": "dashed" | |
| } | |
| }, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "mvolt" | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Voltage" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "unit", | |
| "value": "mvolt" | |
| }, | |
| { | |
| "id": "thresholds", | |
| "value": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "light-red", | |
| "value": 22000 | |
| } | |
| ] | |
| } | |
| }, | |
| { | |
| "id": "min", | |
| "value": 0 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "Current" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "unit", | |
| "value": "amp" | |
| }, | |
| { | |
| "id": "thresholds", | |
| "value": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 0 | |
| } | |
| ] | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 12, | |
| "x": 12, | |
| "y": 0 | |
| }, | |
| "id": 12, | |
| "interval": "10s", | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "displayMode": "list", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "targets": [ | |
| { | |
| "alias": "Voltage", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "batteryvoltage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Current", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "psu_ssh", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "batt_current" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Battery voltage/current", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "description": "", | |
| "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": "smooth", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "celsius" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 12, | |
| "x": 0, | |
| "y": 6 | |
| }, | |
| "id": 2, | |
| "interval": "10s", | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "displayMode": "list", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "targets": [ | |
| { | |
| "alias": "Board 1", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "query": "SELECT mean(\"temp.board1\")/1000 FROM \"autogen\".\"psu\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "temp.board1" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 1000" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Board 2", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "query": "SELECT mean(\"temp.board1\")/1000 FROM \"autogen\".\"psu\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "temp.board2" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 1000" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Board 3", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "query": "SELECT mean(\"temp.board1\")/1000 FROM \"autogen\".\"psu\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "C", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "temp.board3" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 1000" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "PSU#2", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "query": "SELECT mean(\"temp.board1\")/1000 FROM \"autogen\".\"psu\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "D", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "temp.psu2" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 1000" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "PSU Temperature", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "continuous-GrYlRd" | |
| }, | |
| "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": "dashed" | |
| } | |
| }, | |
| "mappings": [], | |
| "max": 150, | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 142 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 12, | |
| "x": 12, | |
| "y": 6 | |
| }, | |
| "id": 4, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "displayMode": "list", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "targets": [ | |
| { | |
| "alias": "Usage", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "ubntPowerOutPower.1" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " /1000" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Power usage", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "dtdhms" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 6, | |
| "x": 0, | |
| "y": 12 | |
| }, | |
| "id": 10, | |
| "interval": "10s", | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.3", | |
| "targets": [ | |
| { | |
| "alias": "Uptime", | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "uptime" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 100" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Uptime", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "max": 100, | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "percent" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 4, | |
| "x": 6, | |
| "y": 12 | |
| }, | |
| "id": 8, | |
| "options": { | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showThresholdLabels": false, | |
| "showThresholdMarkers": true | |
| }, | |
| "pluginVersion": "9.5.3", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "A", | |
| "resultFormat": "table", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "ubntPowerOutPower.1" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " *100/150000" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Power consumption", | |
| "type": "gauge" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [ | |
| { | |
| "options": { | |
| "0": { | |
| "index": 0, | |
| "text": "Off" | |
| }, | |
| "1": { | |
| "index": 1, | |
| "text": "On" | |
| } | |
| }, | |
| "type": "value" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "blue", | |
| "value": null | |
| }, | |
| { | |
| "color": "green", | |
| "value": 0 | |
| }, | |
| { | |
| "color": "yellow", | |
| "value": 1 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 4, | |
| "x": 10, | |
| "y": 12 | |
| }, | |
| "id": 14, | |
| "interval": "10s", | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.3", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "query": "SELECT 2-max(\"charging_status\") FROM \"autogen\".\"psu\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "charging_status" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "max" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Charging", | |
| "transformations": [], | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [ | |
| { | |
| "options": { | |
| "0": { | |
| "index": 0, | |
| "text": "Off" | |
| }, | |
| "1": { | |
| "index": 1, | |
| "text": "On" | |
| } | |
| }, | |
| "type": "value" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "red", | |
| "value": null | |
| }, | |
| { | |
| "color": "green", | |
| "value": 1 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 4, | |
| "x": 14, | |
| "y": 12 | |
| }, | |
| "id": 15, | |
| "interval": "10s", | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.3", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "ac_status" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "AC Supply", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "short" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 6, | |
| "x": 18, | |
| "y": 12 | |
| }, | |
| "id": 17, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [], | |
| "fields": "/.*/", | |
| "values": true | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.3", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "influxdb", | |
| "uid": "VZcbAFwGk" | |
| }, | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "psu", | |
| "orderByTime": "ASC", | |
| "policy": "autogen", | |
| "query": "SELECT last(\"battery_date\") FROM \"autogen\".\"psu\"", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "logs", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "battery_date" | |
| ], | |
| "type": "field" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "title": "Battery installation date", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Time": true | |
| }, | |
| "indexByName": {}, | |
| "renameByName": { | |
| "Time": "", | |
| "last": "Battery installation date" | |
| } | |
| } | |
| } | |
| ], | |
| "type": "stat" | |
| } | |
| ], | |
| "refresh": "5s", | |
| "revision": 1, | |
| "schemaVersion": 38, | |
| "style": "dark", | |
| "tags": [], | |
| "templating": { | |
| "list": [] | |
| }, | |
| "time": { | |
| "from": "now-6h", | |
| "to": "now" | |
| }, | |
| "timepicker": {}, | |
| "timezone": "", | |
| "title": "PSU", | |
| "uid": "u8tNOIQ4z", | |
| "version": 32, | |
| "weekStart": "" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment