{ "__inputs": [ { "name": "DS_INFLUXDB", "label": "influxdb", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__elements": {}, "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "11.1.3" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "table", "name": "Table", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "datasource", "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": "Dashboard to display metrics relating to APC Smart-UPS devices.", "editable": true, "fiscalYearStartMonth": 0, "gnetId": 21635, "graphTooltip": 2, "id": null, "links": [], "liveNow": false, "panels": [ { "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 50, "title": "${ups} System Specs", "type": "row" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "", "fieldConfig": { "defaults": { "color": { "fixedColor": "dark-green", "mode": "fixed" }, "custom": { "align": "center", "cellOptions": { "applyToRow": false, "mode": "gradient", "type": "color-background" }, "filterable": false, "inspect": false, "minWidth": 50 }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null } ] } }, "overrides": [] }, "gridPos": { "h": 3, "w": 24, "x": 0, "y": 1 }, "id": 48, "options": { "cellHeight": "md", "footer": { "countRows": false, "enablePagination": false, "fields": "", "reducer": [ "sum" ], "show": false }, "frameIndex": 0, "showHeader": true, "sortBy": [] }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "hide": false, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsBasicIdentModel\" or r[\"_field\"] == \"upsBasicIdentName\" or r[\"_field\"] == \"upsAdvIdentFirmwareRevision\" or r[\"_field\"] == \"upsAdvIdentDateOfManufacture\" or r[\"_field\"] == \"upsAdvIdentSerialNumber\" or r[\"_field\"] == \"upsAdvIdentSkuNumber\" or r[\"_field\"] == \"upsBasicBatteryLastReplaceDate\" or r[\"_field\"] == \"upsAdvBatteryInternalSKU\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> last()\r\n |> pivot(rowKey: [\"source\"], columnKey: [\"_field\"], valueColumn: \"_value\")\r\n |> group()\r\n", "refId": "A" } ], "transformations": [ { "id": "organize", "options": { "excludeByName": { "_measurement": true, "_start": true, "_stop": true, "host": true, "source": true, "sysName": true }, "includeByName": {}, "indexByName": { "agent_host": 0, "upsAdvBatteryInternalSKU": 7, "upsAdvIdentDateOfManufacture": 6, "upsAdvIdentFirmwareRevision": 3, "upsAdvIdentSerialNumber": 5, "upsAdvIdentSkuNumber": 4, "upsBasicBatteryLastReplaceDate": 8, "upsBasicIdentModel": 2, "upsBasicIdentName": 1 }, "renameByName": { "agent_host": "", "upsAdvBatteryInternalSKU": "Internal Battery SKU", "upsAdvIdentDateOfManufacture": "Manufacture Date", "upsAdvIdentFirmwareRevision": "Firmware", "upsAdvIdentSerialNumber": "Serial", "upsAdvIdentSkuNumber": "SKU", "upsBasicBatteryLastReplaceDate": "Battery Replace Date", "upsBasicIdentModel": "Model", "upsBasicIdentName": "Name" } } } ], "transparent": true, "type": "table" }, { "collapsed": false, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 4 }, "id": 51, "panels": [], "title": "${ups} System Snapshot", "type": "row" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The time seconds since the network management portion of the system was last re-initialized.", "fieldConfig": { "defaults": { "decimals": 2, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-orange", "value": 120 }, { "color": "dark-green", "value": 300 } ] }, "unit": "s" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 5 }, "id": 2, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"sysUpTime\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> map(fn: (r) => ({r with _value: r._value / 100}))\r\n |> group() \r\n |> last() \r\n |> keep(columns: [\"_value\"]) \r\n", "refId": "A" } ], "title": "System Uptime", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The current internal UPS temperature expressed in Fahrenheit.", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "displayName": "System Temperature", "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 77 }, { "color": "dark-red", "value": 95 } ] }, "unit": "fahrenheit" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 4, "y": 5 }, "id": 21, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "center", "orientation": "vertical", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "value_and_name", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvBatteryTemperature\")\r\n |> map(fn: (r) => ({ r with _value: float(v: r._value) *9.0/5.0 + 32.0}))\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The current UPS load expressed in percent of rated capacity.", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "displayName": "System Load", "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 70 }, { "color": "dark-red", "value": 90 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 8, "y": 5 }, "id": 17, "options": { "colorMode": "background", "graphMode": "area", "justifyMode": "center", "orientation": "vertical", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "textMode": "value_and_name", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvOutputLoad\")\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The remaining battery capacity expressed in percent of full capacity.", "fieldConfig": { "defaults": { "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-orange", "value": 20 }, { "color": "dark-green", "value": 50 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 12, "y": 5 }, "id": 24, "interval": "", "options": { "displayMode": "lcd", "maxVizHeight": 300, "minVizHeight": 16, "minVizWidth": 8, "namePlacement": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showUnfilled": true, "sizing": "auto", "text": {}, "valueMode": "color" }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvBatteryCapacity\")\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "title": "Battery Capacity", "type": "bargauge" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The elapsed time since the UPS has switched to battery power in seconds.", "fieldConfig": { "defaults": { "decimals": 0, "mappings": [ { "options": { "0": { "color": "dark-green", "index": 1, "text": "0" } }, "type": "value" }, { "options": { "match": "null", "result": { "index": 0, "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-red", "value": 1 } ] }, "unit": "s" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 15, "y": 5 }, "id": 37, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "center", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsBasicBatteryTimeOnBattery\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> map(fn: (r) => ({r with _value: r._value / 100}))\r\n |> group() \r\n |> last() \r\n |> keep(columns: [\"_value\"])\r\n", "refId": "A" } ], "title": "Time On Battery", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The reason for the occurrence of the last transfer to UPS battery power.", "fieldConfig": { "defaults": { "mappings": [ { "options": { "1": { "text": "noTransfer" }, "2": { "text": "highLineVoltage" }, "3": { "text": "brownout" }, "4": { "text": "blackout" }, "5": { "text": "smallMomentarySag" }, "6": { "text": "deepMomentarySag" }, "7": { "text": "smallMomentarySpike" }, "8": { "text": "largeMomentarySpike" }, "9": { "text": "selfTest" }, "10": { "text": "rateOfVoltageChange" } }, "type": "value" }, { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null } ] }, "unit": "none" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 18, "y": 5 }, "id": 38, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "center", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvInputLineFailCause\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "title": "Last Battery Transfer Reason", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "Indicates whether the UPS battery need replacing.", "fieldConfig": { "defaults": { "mappings": [ { "options": { "1": { "text": "noBatteryNeedsReplacing" }, "2": { "text": "batteryNeedsReplacing" } }, "type": "value" }, { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-green", "value": 1 }, { "color": "dark-red", "value": 2 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 21, "y": 5 }, "id": 42, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "center", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvBatteryReplaceIndicator\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "title": "Battery Status", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The UPS battery run time remaining before battery exhaustion.", "fieldConfig": { "defaults": { "decimals": 0, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-red", "value": 5 }, { "color": "dark-orange", "value": 30 } ] }, "unit": "s" }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 12, "y": 7 }, "id": 40, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "center", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvBatteryRunTimeRemaining\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> map(fn: (r) => ({r with _value: r._value / 100}))\r\n |> group() \r\n |> last() \r\n |> keep(columns: [\"_value\"])\r\n", "refId": "A" } ], "title": "Battery Uptime Remaining", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The current state of the UPS. If the UPS is unable to determine the state of the UPS this variable is set to unknown.", "fieldConfig": { "defaults": { "mappings": [ { "options": { "1": { "text": "unknown" }, "2": { "text": "onLine" }, "3": { "text": "onBattery" }, "4": { "text": "onSmartBoost" }, "5": { "text": "timedSleeping" }, "6": { "text": "softwareBypass" }, "7": { "text": "off" }, "8": { "text": "rebooting" }, "9": { "text": "switchedBypass" }, "10": { "text": "hardwareFailureBypass" }, "11": { "text": "sleepingUntilPowerReturn" }, "12": { "text": "onSmartTrim" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-green", "value": 2 }, { "color": "dark-red", "value": 3 }, { "color": "#EAB839", "value": 13 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 15, "y": 7 }, "id": 35, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "center", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "repeat": "upshostname", "repeatDirection": "v", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsBasicOutputStatus\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "title": "Status", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The result of the last UPS diagnostic test performed. ", "fieldConfig": { "defaults": { "mappings": [ { "options": { "1": { "text": "ok" }, "2": { "text": "failed" }, "3": { "text": "invalidTest" }, "4": { "text": "testInProgress" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-red", "value": 2 }, { "color": "dark-orange", "value": 4 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 18, "y": 7 }, "id": 36, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "center", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvTestDiagnosticsResults\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "title": "Last Self-test Result", "type": "stat" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The UPS system's automatic battery test schedule. ", "fieldConfig": { "defaults": { "mappings": [ { "options": { "1": { "text": "unknown" }, "2": { "text": "biweekly" }, "3": { "text": "weekly" }, "4": { "text": "atTurnOn" }, "5": { "text": "never" }, "6": { "text": "fourWeeks" }, "7": { "text": "twelveWeeks" }, "8": { "text": "biweeklySinceLastTest" }, "9": { "text": "weeklySinceLastTest" } }, "type": "value" }, { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-red", "value": 4 }, { "color": "dark-red", "value": 5 }, { "color": "dark-green", "value": 6 } ] } }, "overrides": [] }, "gridPos": { "h": 2, "w": 3, "x": 21, "y": 7 }, "id": 45, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "center", "orientation": "horizontal", "percentChangeColorMode": "standard", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showPercentChange": false, "text": {}, "textMode": "auto", "wideLayout": true }, "pluginVersion": "11.1.3", "repeat": "upshostname", "repeatDirection": "v", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvTestDiagnosticSchedule\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "title": "Self-test Schedule", "type": "stat" }, { "collapsed": false, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 9 }, "id": 52, "panels": [], "title": "${ups} System Usage", "type": "row" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The current internal UPS temperature expressed in Fahrenheit.", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "Temperature in F", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "dashed" } }, "displayName": "${ups}", "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 77 }, { "color": "dark-red", "value": 95 } ] }, "unit": "fahrenheit" }, "overrides": [] }, "gridPos": { "h": 9, "w": 12, "x": 0, "y": 10 }, "id": 8, "options": { "legend": { "calcs": [ "min", "max", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvBatteryTemperature\")\r\n |> map(fn: (r) => ({ r with _value: float(v: r._value) *9.0/5.0 + 32.0}))\r\n |> aggregateWindow(every: ${interval}, fn: last, createEmpty: false)\r\n |> yield(name: \"last\")\r\n", "refId": "A" } ], "title": "System Temperature", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The current UPS load expressed in percent of rated capacity.", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "System Load in %", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "dashed" } }, "displayName": "${ups}", "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 70 }, { "color": "dark-red", "value": 90 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 9, "w": 12, "x": 12, "y": 10 }, "id": 16, "options": { "legend": { "calcs": [ "min", "max", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvOutputLoad\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "A" } ], "title": "System Load", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The remaining battery capacity expressed in percent of full capacity.", "fieldConfig": { "defaults": { "color": { "fixedColor": "dark-green", "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "Battery Capacity %", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "dashed" } }, "displayName": "${ups}", "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-red", "value": null }, { "color": "dark-orange", "value": 20 }, { "color": "dark-green", "value": 50 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 9, "w": 12, "x": 0, "y": 19 }, "id": 6, "options": { "legend": { "calcs": [ "min", "max", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvBatteryCapacity\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "A" } ], "title": "Battery Capacity", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "Frequency in Hz", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "opacity", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "stepBefore", "lineStyle": { "fill": "solid" }, "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null } ] }, "unit": "hertz" }, "overrides": [ { "matcher": { "id": "byFrameRefID", "options": "A" }, "properties": [ { "id": "displayName", "value": "${ups} (input)" } ] }, { "matcher": { "id": "byFrameRefID", "options": "B" }, "properties": [ { "id": "displayName", "value": "${ups} (output)" } ] } ] }, "gridPos": { "h": 9, "w": 12, "x": 12, "y": 19 }, "id": 14, "options": { "legend": { "calcs": [ "min", "max", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvInputFrequency\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "A" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "hide": false, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvOutputFrequency\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "B" } ], "title": "Frequency", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The current utility line voltage in VAC.", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "Line Voltage in V", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "stepBefore", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null } ] }, "unit": "volt" }, "overrides": [ { "matcher": { "id": "byFrameRefID", "options": "A" }, "properties": [ { "id": "displayName", "value": "${ups} (input)" } ] }, { "matcher": { "id": "byFrameRefID", "options": "B" }, "properties": [ { "id": "displayName", "value": "${ups} (output)" } ] } ] }, "gridPos": { "h": 9, "w": 12, "x": 0, "y": 28 }, "id": 12, "options": { "legend": { "calcs": [ "min", "max", "mean", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvInputLineVoltage\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "A" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "hide": false, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvOutputVoltage\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "B" } ], "title": "Line Voltage", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The total output active power of the UPS system in W and A. The total active power is the sum of phase 1, phase 2 and phase 3 power. ", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "stepBefore", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "fieldMinMax": false, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null } ] } }, "overrides": [ { "matcher": { "id": "byFrameRefID", "options": "A" }, "properties": [ { "id": "displayName", "value": "${ups} (watt)" } ] }, { "matcher": { "id": "byFrameRefID", "options": "B" }, "properties": [ { "id": "displayName", "value": "${ups} (ampere)" } ] }, { "matcher": { "id": "byFrameRefID", "options": "C" }, "properties": [ { "id": "displayName", "value": "${ups} (volt-ampere)" } ] } ] }, "gridPos": { "h": 9, "w": 12, "x": 12, "y": 28 }, "id": 19, "options": { "legend": { "calcs": [ "min", "max", "mean", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "hide": false, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvOutputApparentPower\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "A" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvOutputActivePower\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "B" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "hide": false, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsHighPrecOutputCurrent\")\r\n |> aggregateWindow(every: ${interval}, fn: mean, createEmpty: false)\r\n", "refId": "C" } ], "title": "Power Usage (W, A, VA)", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The actual battery bus voltage in Volts.", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "Battery Bus Voltage in V", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "stepBefore", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "${ups}", "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null } ] }, "unit": "volt" }, "overrides": [] }, "gridPos": { "h": 9, "w": 12, "x": 0, "y": 37 }, "id": 10, "options": { "legend": { "calcs": [ "min", "max", "mean", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "multi", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvBatteryActualVoltage\")\r\n |> aggregateWindow(every: 1h, fn: mean, createEmpty: false)\r\n", "refId": "A" } ], "title": "Battery Bus Voltage", "type": "timeseries" }, { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "description": "The total output active power of the UPS system in kWh.", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisBorderShow": false, "axisCenteredZero": false, "axisColorMode": "text", "axisLabel": "Power Usage in kWh", "axisPlacement": "auto", "barAlignment": 1, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "legend": false, "tooltip": false, "viz": false }, "insertNulls": false, "lineInterpolation": "stepBefore", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false, "stacking": { "group": "A", "mode": "none" }, "thresholdsStyle": { "mode": "off" } }, "displayName": "${ups}", "fieldMinMax": false, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null } ] }, "unit": "kwatth" }, "overrides": [] }, "gridPos": { "h": 9, "w": 12, "x": 12, "y": 37 }, "id": 49, "options": { "legend": { "calcs": [ "min", "max", "mean", "lastNotNull" ], "displayMode": "table", "placement": "bottom", "showLegend": true }, "tooltip": { "mode": "single", "sort": "none" } }, "pluginVersion": "8.2.0-33922pre", "targets": [ { "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsAdvOutputActivePower\")\r\n |> aggregateWindow(every: 1h, fn: mean, createEmpty: false)\r\n", "refId": "A" } ], "title": "Power Usage (kWh)", "type": "timeseries" } ], "refresh": "10s", "schemaVersion": 39, "tags": [ "apcups" ], "templating": { "list": [ { "auto": true, "auto_count": 100, "auto_min": "30s", "current": { "selected": false, "text": "auto", "value": "$__auto_interval_interval" }, "hide": 0, "label": "Sampling", "name": "interval", "options": [ { "selected": true, "text": "auto", "value": "$__auto_interval_interval" }, { "selected": false, "text": "1m", "value": "1m" }, { "selected": false, "text": "10m", "value": "10m" }, { "selected": false, "text": "30m", "value": "30m" }, { "selected": false, "text": "1h", "value": "1h" }, { "selected": false, "text": "6h", "value": "6h" }, { "selected": false, "text": "12h", "value": "12h" }, { "selected": false, "text": "1d", "value": "1d" }, { "selected": false, "text": "7d", "value": "7d" }, { "selected": false, "text": "14d", "value": "14d" }, { "selected": false, "text": "30d", "value": "30d" } ], "query": "1m,10m,30m,1h,6h,12h,1d,7d,14d,30d", "queryValue": "", "refresh": 2, "skipUrlSync": false, "type": "interval" }, { "current": {}, "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "definition": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> keep(columns: [\"source\"])\r\n |> distinct(column: \"source\")\r\n |> group()\r\n", "description": "UPS Hostname Variable", "hide": 0, "includeAll": false, "label": "Hostname", "multi": false, "name": "upshostname", "options": [], "query": { "0": "S", "1": "H", "2": "O", "3": "W", "4": " ", "5": "T", "6": "A", "7": "G", "8": " ", "9": "V", "10": "A", "11": "L", "12": "U", "13": "E", "14": "S", "15": " ", "16": "F", "17": "R", "18": "O", "19": "M", "20": " ", "21": "\"", "22": "s", "23": "n", "24": "m", "25": "p", "26": ".", "27": "U", "28": "P", "29": "S", "30": "\"", "31": " ", "32": "W", "33": "I", "34": "T", "35": "H", "36": " ", "37": "K", "38": "E", "39": "Y", "40": " ", "41": "=", "42": " ", "43": "\"", "44": "a", "45": "g", "46": "e", "47": "n", "48": "t", "49": "_", "50": "h", "51": "o", "52": "s", "53": "t", "54": "\"", "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> keep(columns: [\"source\"])\r\n |> distinct(column: \"source\")\r\n |> group()\r\n" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tagsQuery": "", "type": "query", "useTags": false }, { "current": {}, "datasource": { "type": "influxdb", "uid": "${DS_INFLUXDB}" }, "definition": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsBasicIdentName\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> keep(columns: [\"_value\"])\r\n |> distinct(column: \"_value\")\r\n |> group()\r\n", "description": "UPS Variable", "hide": 0, "includeAll": false, "label": "UPS", "multi": false, "name": "ups", "options": [], "query": { "0": "S", "1": "H", "2": "O", "3": "W", "4": " ", "5": "T", "6": "A", "7": "G", "8": " ", "9": "V", "10": "A", "11": "L", "12": "U", "13": "E", "14": "S", "15": " ", "16": "F", "17": "R", "18": "O", "19": "M", "20": " ", "21": "\"", "22": "s", "23": "n", "24": "m", "25": "p", "26": ".", "27": "U", "28": "P", "29": "S", "30": "\"", "31": " ", "32": "W", "33": "I", "34": "T", "35": "H", "36": " ", "37": "K", "38": "E", "39": "Y", "40": " ", "41": "=", "42": " ", "43": "\"", "44": "a", "45": "g", "46": "e", "47": "n", "48": "t", "49": "_", "50": "h", "51": "o", "52": "s", "53": "t", "54": "\"", "query": "from(bucket: v.defaultBucket)\r\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\r\n |> filter(fn: (r) => r[\"_measurement\"] == \"snmp.UPS\")\r\n |> filter(fn: (r) => r[\"_field\"] == \"upsBasicIdentName\")\r\n |> filter(fn: (r) => r[\"source\"] =~ /${upshostname:regex}/)\r\n |> keep(columns: [\"_value\"])\r\n |> distinct(column: \"_value\")\r\n |> group()\r\n" }, "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tagsQuery": "", "type": "query", "useTags": false } ] }, "time": { "from": "now-24h", "to": "now" }, "timepicker": { "refresh_intervals": [ "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ] }, "timezone": "", "title": "APC SmartUPS Dashboard", "uid": "mleZBL2Gz", "version": 92, "weekStart": "" }