{ "__inputs": [ { "name": "DS_INFLUXDB", "label": "InfluxDB", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "panel", "id": "gauge", "name": "Gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "7.5.3" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "text", "name": "Text", "version": "" }, { "type": "panel", "id": "timeseries", "name": "Time series", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "description": "VMware vSphere Dashboard (Grafana 7.5 / new Time-Series Panel)", "editable": true, "gnetId": 8159, "graphTooltip": 0, "id": null, "iteration": 1619098072100, "links": [ { "asDropdown": true, "icon": "external link", "includeVars": true, "keepTime": true, "tags": [ "vSphere Telegraf" ], "targetBlank": true, "title": "More Dashboards", "type": "dashboards" } ], "panels": [ { "collapsed": false, "datasource": "${DS_INFLUXDB}", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 61, "panels": [], "title": "Cluster Status", "type": "row" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "decimals": 1, "mappings": [ { "id": 0, "op": "=", "text": "N/A", "type": 1, "value": "null" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "#d44a3a", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 0.001 }, { "color": "#1F60C4", "value": 0.002 } ] }, "unit": "s" }, "overrides": [ { "matcher": { "id": "byName", "options": "vCenter Summary" }, "properties": [ { "id": "unit", "value": "locale" }, { "id": "color", "value": { "fixedColor": "dark-purple", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "ESXi Summary" }, "properties": [ { "id": "unit", "value": "locale" }, { "id": "color", "value": { "fixedColor": "dark-purple", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "VM Summary" }, "properties": [ { "id": "unit", "value": "locale" }, { "id": "color", "value": { "fixedColor": "dark-purple", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Datastore Summary" }, "properties": [ { "id": "unit", "value": "locale" }, { "id": "color", "value": { "fixedColor": "dark-purple", "mode": "fixed" } } ] }, { "matcher": { "id": "byName", "options": "Cluster Summary" }, "properties": [ { "id": "unit", "value": "locale" }, { "id": "color", "value": { "fixedColor": "dark-purple", "mode": "fixed" } } ] } ] }, "gridPos": { "h": 4, "w": 24, "x": 0, "y": 1 }, "id": 142, "interval": null, "links": [], "maxDataPoints": 100, "options": { "colorMode": "background", "fieldOptions": { "calcs": [ "lastNotNull" ] }, "graphMode": "none", "justifyMode": "center", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "text": {}, "textMode": "auto" }, "pluginVersion": "7.5.3", "targets": [ { "alias": "vCenter Summary", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT count(distinct(\"vcenter\")) AS \"vCenter\" FROM (SELECT \"overhead_average\", \"vcenter\" FROM \"vsphere_cluster_mem\" WHERE $timeFilter)", "rawQuery": true, "refId": "C", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Cluster Summary", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT count(distinct(\"clustername\")) AS \"Cluster\" FROM (SELECT \"totalmhz_average\", \"clustername\" FROM \"vsphere_cluster_cpu\" WHERE $timeFilter)", "rawQuery": true, "refId": "E", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "ESXi Summary", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT count(distinct(\"esxhostname\")) AS \"ESXi\" FROM (SELECT \"coreUtilization_average\", \"esxhostname\" FROM \"vsphere_host_cpu\" WHERE $timeFilter)", "rawQuery": true, "refId": "F", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "VM Summary", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT count(distinct(\"vmname\")) AS \"VM\" FROM (SELECT \"usage_average\", \"vmname\" FROM \"vsphere_vm_cpu\" WHERE $timeFilter)", "rawQuery": true, "refId": "G", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] }, { "alias": "Datastore Summary", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT count(distinct(\"dsname\")) AS \"Datastore\" FROM (SELECT \"capacity_latest\", \"dsname\" FROM \"vsphere_datastore_disk\" WHERE $timeFilter)", "rawQuery": true, "refId": "H", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "title": "vSphere Overview", "transformations": [], "type": "stat" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "description": "", "fieldConfig": { "defaults": { "decimals": 1, "mappings": [ { "id": 0, "op": "=", "text": "N/A", "type": 1, "value": "null" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "#d44a3a", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 0.001 }, { "color": "#1F60C4", "value": 0.002 } ] }, "unit": "s" }, "overrides": [ { "matcher": { "id": "byName", "options": "CPU Usage" }, "properties": [ { "id": "unit", "value": "percent" }, { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "semi-dark-green", "value": null }, { "color": "dark-orange", "value": 70 }, { "color": "dark-red", "value": 85 } ] } }, { "id": "decimals", "value": 2 } ] }, { "matcher": { "id": "byName", "options": "RAM Usage" }, "properties": [ { "id": "unit", "value": "percent" }, { "id": "thresholds", "value": { "mode": "absolute", "steps": [ { "color": "semi-dark-green", "value": null }, { "color": "dark-orange", "value": 70 }, { "color": "dark-red", "value": 85 } ] } }, { "id": "decimals", "value": 2 } ] } ] }, "gridPos": { "h": 4, "w": 8, "x": 0, "y": 5 }, "id": 28, "interval": null, "links": [], "maxDataPoints": 100, "options": { "colorMode": "background", "fieldOptions": { "calcs": [ "lastNotNull" ] }, "graphMode": "none", "justifyMode": "center", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "text": {}, "textMode": "auto" }, "pluginVersion": "7.5.3", "repeat": "clustername", "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_host_sys", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"uptime_latest\") AS \"Uptime\" FROM \"vsphere_host_sys\" WHERE (\"vcenter\" =~ /^$vcenter$/ AND \"clustername\" =~ /^$clustername$/) AND $timeFilter GROUP BY time($inter) fill(null)", "rawQuery": false, "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "uptime_latest" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "Uptime" ], "type": "alias" } ] ], "tags": [ { "key": "vcenter", "operator": "=~", "value": "/^$vcenter$/" }, { "condition": "AND", "key": "clustername", "operator": "=~", "value": "/^$clustername$/" } ] }, { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_host_cpu", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"usage_average\") FROM \"vsphere_host_cpu\" WHERE (\"vcenter\" =~ /^$vcenter$/ AND \"clustername\" =~ /^$clustername$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": false, "refId": "D", "resultFormat": "table", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" }, { "params": [ "CPU Usage" ], "type": "alias" } ] ], "tags": [ { "key": "vcenter", "operator": "=~", "value": "/^$vcenter$/" }, { "condition": "AND", "key": "clustername", "operator": "=~", "value": "/^$clustername$/" }, { "condition": "AND", "key": "cpu", "operator": "=", "value": "instance-total" } ] }, { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_host_mem", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"usage_average\") FROM \"vsphere_host_cpu\" WHERE (\"vcenter\" =~ /^$vcenter$/ AND \"clustername\" =~ /^$clustername$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": false, "refId": "B", "resultFormat": "table", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "last" }, { "params": [ "RAM Usage" ], "type": "alias" } ] ], "tags": [ { "key": "vcenter", "operator": "=~", "value": "/^$vcenter$/" }, { "condition": "AND", "key": "clustername", "operator": "=~", "value": "/^$clustername$/" } ] } ], "title": "$clustername Overview", "transformations": [], "type": "stat" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Usage Average %", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 5, "w": 6, "x": 0, "y": 9 }, "id": 23, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_clustername", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "clustername" ], "type": "tag" }, { "params": [ "cpu" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_cpu", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"usagemhz_average\") FROM \"vsphere_host_cpu\" WHERE (\"clustername\" =~ /^$clustername$/) AND $timeFilter GROUP BY time($inter), \"clustername\" fill(none)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "clustername", "operator": "=~", "value": "/^$clustername$/" }, { "condition": "AND", "key": "cpu", "operator": "=", "value": "instance-total" } ] } ], "timeFrom": null, "timeShift": null, "title": "Cluster CPU Usage %", "transformations": [], "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Usage Average %", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": false }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 5, "w": 7, "x": 6, "y": 9 }, "id": 26, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_clustername", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "clustername" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_mem", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"totalCapacity_average\") * (last(\"usage_average\")) / 100 * 1024 FROM \"vsphere_host_mem\" WHERE (\"clustername\" =~ /^$clustername$/) AND $timeFilter GROUP BY time($inter), \"clustername\" fill(none)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "vcenter", "operator": "=~", "value": "/^$vcenter$/" }, { "condition": "AND", "key": "clustername", "operator": "=~", "value": "/^$clustername$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Cluster RAM Usage in %", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "decimals": 0, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-yellow", "value": 65 }, { "color": "dark-orange", "value": 75 }, { "color": "dark-red", "value": 90 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 9, "w": 11, "x": 13, "y": 9 }, "hideTimeOverride": false, "id": 123, "interval": "1h", "links": [], "options": { "displayMode": "lcd", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "showUnfilled": true, "text": {} }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_source", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"used_latest\") * (100 / last(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) , \"source\" fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "timeFrom": "3h", "timeShift": null, "title": "Datastores - Usage Capacity", "type": "bargauge" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Usage Network MBps", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "KBs" }, "overrides": [] }, "gridPos": { "h": 4, "w": 6, "x": 0, "y": 14 }, "id": 90, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_clustername - Received", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "clustername" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_net", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"usage_average\") FROM \"vsphere_host_cpu\" WHERE \"esxhostname\" = ($esxi) AND $timeFilter GROUP BY time($inter), \"host\" fill(none)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "bytesRx_average" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "clustername", "operator": "=~", "value": "/^$clustername$/" } ] }, { "alias": "$tag_clustername - Transmited", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "clustername" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_net", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"usage_average\") FROM \"vsphere_host_cpu\" WHERE \"esxhostname\" = ($esxi) AND $timeFilter GROUP BY time($inter), \"host\" fill(none)", "rawQuery": false, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "bytesTx_average" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "clustername", "operator": "=~", "value": "/^$clustername$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Cluster Network Usage", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "ms", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "decimals": 0, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "ms" }, "overrides": [] }, "gridPos": { "h": 4, "w": 7, "x": 6, "y": 14 }, "id": 91, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_clustername - ReadAverage", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "clustername" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_storageAdapter", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"usage_average\") FROM \"vsphere_host_cpu\" WHERE \"esxhostname\" = ($esxi) AND $timeFilter GROUP BY time($inter), \"host\" fill(none)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "totalReadLatency_average" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "clustername", "operator": "=~", "value": "/^$clustername$/" } ] }, { "alias": "$tag_clustername - WriteAverage", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "clustername" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_storageAdapter", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"usage_average\") FROM \"vsphere_host_cpu\" WHERE \"esxhostname\" = ($esxi) AND $timeFilter GROUP BY time($inter), \"host\" fill(none)", "rawQuery": false, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "totalWriteLatency_average" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "clustername", "operator": "=~", "value": "/^$clustername$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Cluster Storage Adapter", "type": "timeseries" }, { "collapsed": true, "datasource": "${DS_INFLUXDB}", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 18 }, "id": 25, "panels": [ { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 21 }, "hideTimeOverride": true, "id": 34, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": "datastore", "repeatDirection": "h", "scopedVars": { "datastore": { "selected": false, "text": "ISOS-OS", "value": "ISOS-OS" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 4, "y": 21 }, "hideTimeOverride": true, "id": 145, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "VMS", "value": "VMS" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 8, "y": 21 }, "hideTimeOverride": true, "id": 146, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZEXT-QNAP-001", "value": "ZEXT-QNAP-001" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 12, "y": 21 }, "hideTimeOverride": true, "id": 147, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZEXT-VSA-001", "value": "ZEXT-VSA-001" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 16, "y": 21 }, "hideTimeOverride": true, "id": 148, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi-NVME-01", "value": "ZINT-ESXi-NVME-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 20, "y": 21 }, "hideTimeOverride": true, "id": 149, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi-NVME-02", "value": "ZINT-ESXi-NVME-02" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 25 }, "hideTimeOverride": true, "id": 150, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi0-01", "value": "ZINT-ESXi0-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 4, "y": 25 }, "hideTimeOverride": true, "id": 151, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi0-SSD-01", "value": "ZINT-ESXi0-SSD-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 8, "y": 25 }, "hideTimeOverride": true, "id": 152, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi1-SATADOM", "value": "ZINT-ESXi1-SATADOM" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 12, "y": 25 }, "hideTimeOverride": true, "id": 153, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi2-00", "value": "ZINT-ESXi2-00" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 16, "y": 25 }, "hideTimeOverride": true, "id": 154, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi2-01", "value": "ZINT-ESXi2-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 20, "y": 25 }, "hideTimeOverride": true, "id": 155, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi2-02", "value": "ZINT-ESXi2-02" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 29 }, "hideTimeOverride": true, "id": 156, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi2-SSD-01", "value": "ZINT-ESXi2-SSD-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 4, "y": 29 }, "hideTimeOverride": true, "id": 157, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi2-SSD-02", "value": "ZINT-ESXi2-SSD-02" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 8, "y": 29 }, "hideTimeOverride": true, "id": 158, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi3-01", "value": "ZINT-ESXi3-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 12, "y": 29 }, "hideTimeOverride": true, "id": 159, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi3-NVME-01", "value": "ZINT-ESXi3-NVME-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 16, "y": 29 }, "hideTimeOverride": true, "id": 160, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi3-SSD-01", "value": "ZINT-ESXi3-SSD-01" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 20, "y": 29 }, "hideTimeOverride": true, "id": 161, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "ZINT-ESXi4-USB", "value": "ZINT-ESXi4-USB" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-green", "value": null }, { "color": "dark-orange", "value": 65 }, { "color": "dark-red", "value": 85 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 4, "w": 4, "x": 0, "y": 33 }, "hideTimeOverride": true, "id": 162, "links": [], "maxPerRow": 6, "options": { "orientation": "auto", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "showThresholdLabels": false, "showThresholdMarkers": true }, "pluginVersion": "7.1.3", "repeat": null, "repeatDirection": "h", "repeatIteration": 1603466459224, "repeatPanelId": 34, "scopedVars": { "datastore": { "selected": false, "text": "vsanDatastore", "value": "vsanDatastore" } }, "targets": [ { "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"used_latest\") * (100 / mean(\"capacity_latest\")) FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($inter) fill(none)", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=", "value": "ZEXT-NETAPP-01" } ] } ], "timeFrom": "3h", "title": "$datastore", "type": "gauge" } ], "title": "Datastore Status", "type": "row" }, { "collapsed": false, "datasource": "${DS_INFLUXDB}", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 19 }, "id": 20, "panels": [], "repeat": null, "title": "Hypervisor Status", "type": "row" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "CPU Usage Avg. %", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 0, "y": 20 }, "id": 15, "links": [], "options": { "graph": {}, "legend": { "calcs": [ "last", "min", "max" ], "displayMode": "table", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_esxhostname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "esxhostname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_cpu", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"usage_average\") FROM \"vsphere_host_cpu\" WHERE \"esxhostname\" = ($esxi) AND $timeFilter GROUP BY time($inter), \"host\" fill(none)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "esxhostname", "operator": "=~", "value": "/^$esxi$/" }, { "condition": "AND", "key": "cpu", "operator": "=", "value": "instance-total" } ] } ], "timeFrom": null, "timeShift": null, "title": "Hypervisor CPU", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Memory Usage Avg. %", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 6, "y": 20 }, "id": 16, "links": [], "options": { "graph": {}, "legend": { "calcs": [ "last", "min", "max" ], "displayMode": "table", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_esxhostname mem usage average", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "esxhostname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_mem", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "esxhostname", "operator": "=~", "value": "/^$esxi$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Hypervisor Memory", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "KBs" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 12, "y": 20 }, "id": 17, "links": [], "options": { "graph": {}, "legend": { "calcs": [ "last", "min", "max" ], "displayMode": "table", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_esxhostname net usage average", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "esxhostname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_host_net", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "esxhostname", "operator": "=~", "value": "/^$esxi$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Hypervisor Net Usage", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "CPU Usage", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 18, "y": 20 }, "id": 19, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vcenter CPU", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vcenter" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_vm_cpu", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "vcenter", "operator": "=~", "value": "/^$vcenter$/" }, { "condition": "AND", "key": "cpu", "operator": "=", "value": "instance-total" } ] }, { "alias": "$tag_vcenter RAM", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vcenter" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_vm_mem", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "vcenter", "operator": "=~", "value": "/^$vcenter$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "vCenter CPU/RAM", "type": "timeseries" }, { "collapsed": false, "datasource": "${DS_INFLUXDB}", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 27 }, "id": 21, "panels": [], "repeat": null, "title": "Virtual Machine Status", "type": "row" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "CPU Usage % per VM", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 0, "y": 28 }, "id": 14, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "cpu" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_vm_cpu", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" }, { "condition": "AND", "key": "cpu", "operator": "=", "value": "instance-total" } ] } ], "timeFrom": null, "timeShift": null, "title": "Virtual Machine CPU Usage in %", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Memory Usage Avg. %", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "max": 100, "min": 0, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "percent" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 6, "y": 28 }, "id": 13, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_vm_mem", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Virtual Machine Memory Usage Avg.", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "CPU READY in ms", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "ms" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 12, "y": 28 }, "hideTimeOverride": false, "id": 10, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_vm_cpu", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"ready_summation\") FROM \"vsphere_vm_cpu\" WHERE (\"vmname\" =~ /^$virtualmachine$/) AND $timeFilter GROUP BY time($inter), \"vmname\" fill(none)", "rawQuery": false, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "ready_summation" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Virtual Machine CPU READY ms", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Net Usage Avg.", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "KBs" }, "overrides": [] }, "gridPos": { "h": 7, "w": 6, "x": 18, "y": 28 }, "id": 12, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "measurement": "vsphere_vm_net", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "usage_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Virtual Machine Network Usage Avg (Kbps)", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Block Read IOPS", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "iops" }, "overrides": [] }, "gridPos": { "h": 7, "w": 8, "x": 0, "y": 35 }, "id": 3, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "limit": "", "measurement": "vsphere_vm_virtualDisk", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "numberReadAveraged_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "slimit": "", "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Virtual Machine Disk Performance (Read VMFS Block IOPS)", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Block Write IOPS", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "iops" }, "overrides": [] }, "gridPos": { "h": 7, "w": 8, "x": 8, "y": 35 }, "id": 18, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "list", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "limit": "", "measurement": "vsphere_vm_virtualDisk", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "numberWriteAveraged_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "slimit": "", "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Virtual Machine Disk Performance (Write VMFS Block IOPS)", "type": "timeseries" }, { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "palette-classic" }, "custom": { "axisLabel": "Block Latency Total", "axisPlacement": "auto", "barAlignment": 0, "drawStyle": "line", "fillOpacity": 30, "gradientMode": "hue", "hideFrom": { "graph": false, "legend": false, "tooltip": false }, "lineInterpolation": "smooth", "lineWidth": 2, "pointSize": 5, "scaleDistribution": { "type": "linear" }, "showPoints": "never", "spanNulls": true }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "ms" }, "overrides": [] }, "gridPos": { "h": 7, "w": 8, "x": 16, "y": 35 }, "id": 9, "links": [], "options": { "graph": {}, "legend": { "calcs": [], "displayMode": "hidden", "placement": "bottom" }, "tooltipOptions": { "mode": "multi" } }, "pluginVersion": "7.5.3", "targets": [ { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "limit": "", "measurement": "vsphere_vm_virtualDisk", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "totalReadLatency_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "slimit": "", "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" } ] }, { "alias": "$tag_vmname", "dsType": "influxdb", "groupBy": [ { "params": [ "$inter" ], "type": "time" }, { "params": [ "vmname" ], "type": "tag" }, { "params": [ "none" ], "type": "fill" } ], "limit": "", "measurement": "vsphere_vm_virtualDisk", "orderByTime": "ASC", "policy": "default", "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "totalWriteLatency_average" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "slimit": "", "tags": [ { "key": "vmname", "operator": "=~", "value": "/^$virtualmachine$/" } ] } ], "timeFrom": null, "timeShift": null, "title": "Virtual Machine Disk Performance (Block Latency Total)", "type": "timeseries" }, { "datasource": null, "fieldConfig": { "defaults": {}, "overrides": [] }, "gridPos": { "h": 3, "w": 5, "x": 19, "y": 42 }, "id": 166, "options": { "content": "", "mode": "html" }, "pluginVersion": "7.5.3", "targets": [ { "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "null" ], "type": "fill" } ], "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [] } ], "timeFrom": null, "timeShift": null, "transparent": true, "type": "text" } ], "refresh": false, "schemaVersion": 27, "style": "dark", "tags": [ "VMware", "vSphere Overview", "vSphere Telegraf" ], "templating": { "list": [ { "auto": true, "auto_count": 100, "auto_min": "20s", "current": { "selected": false, "text": "auto", "value": "$__auto_interval_inter" }, "description": null, "error": null, "hide": 0, "label": "Sampling", "name": "inter", "options": [ { "selected": true, "text": "auto", "value": "$__auto_interval_inter" }, { "selected": false, "text": "20s", "value": "20s" }, { "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": "20s,1m,10m,30m,1h,6h,12h,1d,7d,14d,30d", "queryValue": "", "refresh": 2, "skipUrlSync": false, "type": "interval" }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "", "description": null, "error": null, "hide": 0, "includeAll": true, "label": "vCenter Server", "multi": true, "name": "vcenter", "options": [], "query": "select DISTINCT(\"vcenter\") from (select \"usage_average\",\"vcenter\" from \"vsphere_host_cpu\" WHERE $timeFilter)", "refresh": 2, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "", "description": null, "error": null, "hide": 0, "includeAll": true, "label": "Cluster", "multi": true, "name": "clustername", "options": [], "query": "select DISTINCT(\"clustername\") from (select \"usage_average\",\"clustername\" from \"vsphere_host_cpu\" WHERE $timeFilter AND \"vcenter\" =~ /$vcenter/)", "refresh": 2, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "", "description": null, "error": null, "hide": 0, "includeAll": true, "label": "ESXi Server", "multi": true, "name": "esxi", "options": [], "query": "select DISTINCT(\"esxhostname\") from (select \"usage_average\",\"esxhostname\" from \"vsphere_host_cpu\" WHERE $timeFilter AND \"vcenter\" =~ /$vcenter/)", "refresh": 2, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "", "description": null, "error": null, "hide": 0, "includeAll": true, "label": "Datastore", "multi": true, "name": "datastore", "options": [], "query": "select DISTINCT(\"dsname\") from (select \"used_latest\",\"dsname\" from \"vsphere_datastore_disk\" WHERE $timeFilter AND \"vcenter\" =~ /$vcenter/)", "refresh": 2, "regex": "/^(?!VeeamBackup_)/", "skipUrlSync": false, "sort": 1, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": "", "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "", "description": null, "error": null, "hide": 0, "includeAll": true, "label": "VM", "multi": true, "name": "virtualmachine", "options": [], "query": "select DISTINCT(\"vmname\") from (select \"ready_summation\",\"vmname\" from \"vsphere_vm_cpu\" WHERE $timeFilter AND \"vcenter\" =~ /$vcenter/)", "refresh": 2, "regex": "/^(?![a-zA-Z0-9-_]+_)/", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false } ] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": { "refresh_intervals": [ "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "browser", "title": "VMware vSphere - Overview", "uid": "kwtyVaAmz", "version": 15 }