{ "__inputs": [ { "name": "DS_INFLUXDB", "label": "InfluxDB", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "7.0.0" }, { "type": "panel", "id": "grafana-piechart-panel", "name": "Pie Chart", "version": "1.5.0" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "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 using the new Telegraf plugin (Grafana 7)", "editable": true, "gnetId": 8162, "graphTooltip": 0, "id": null, "iteration": 1590713463753, "links": [ { "asDropdown": true, "icon": "external link", "includeVars": true, "keepTime": true, "tags": [ "vSphere Telegraf" ], "targetBlank": true, "title": "More Dashboards", "type": "dashboards" } ], "panels": [ { "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": {}, "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": 12, "w": 24, "x": 0, "y": 0 }, "hideTimeOverride": false, "id": 123, "interval": "1h", "links": [], "options": { "displayMode": "lcd", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "values": false }, "showUnfilled": true }, "pluginVersion": "7.0.0", "targets": [ { "alias": "$tag_source", "groupBy": [ { "params": [ "$__interval" ], "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($__interval) , \"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}", "gridPos": { "h": 1, "w": 24, "x": 0, "y": 12 }, "id": 55, "panels": [], "repeat": "datastore", "title": "$datastore", "type": "row" }, { "cacheTimeout": null, "datasource": "${DS_INFLUXDB}", "fieldConfig": { "defaults": { "custom": {}, "decimals": 2, "mappings": [ { "id": 0, "op": "=", "text": "N/A", "type": 1, "value": "null" } ], "min": 0, "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "dark-blue", "value": null } ] }, "unit": "deckbytes" }, "overrides": [] }, "gridPos": { "h": 8, "w": 9, "x": 0, "y": 13 }, "hideTimeOverride": true, "id": 48, "interval": "1h", "links": [], "maxDataPoints": 100, "options": { "colorMode": "background", "fieldOptions": { "calcs": [ "mean" ] }, "graphMode": "none", "justifyMode": "center", "orientation": "auto", "reduceOptions": { "calcs": [ "lastNotNull" ], "values": false } }, "pluginVersion": "7.0.0", "targets": [ { "alias": "Total Capacity", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "source" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "capacity_latest" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "source", "operator": "=~", "value": "/^$datastore$/" } ] }, { "alias": "Free Capacity", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "source" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT mean(\"capacity_latest\") - mean(\"used_latest\") FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($__interval), \"source\" fill(null)", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "capacity_latest" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "source", "operator": "=~", "value": "/^$datastore$/" } ] } ], "timeFrom": "3h", "title": "Total Capacity", "type": "stat" }, { "aliasColors": { "Free Space": "#5195ce", "Used Space": "#ea6460" }, "breakPoint": "50%", "cacheTimeout": null, "combine": { "label": "Others", "threshold": 0 }, "datasource": "${DS_INFLUXDB}", "decimals": 2, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fontSize": "80%", "format": "deckbytes", "gridPos": { "h": 8, "w": 15, "x": 9, "y": 13 }, "id": 51, "interval": "1h", "legend": { "header": "", "percentage": true, "show": true, "values": true }, "legendType": "Right side", "links": [], "maxDataPoints": 3, "nullPointMode": "connected", "pieType": "donut", "strokeWidth": "2", "targets": [ { "alias": "Used Space", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "source" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "used_latest" ], "type": "field" }, { "params": [], "type": "last" } ] ], "tags": [ { "key": "source", "operator": "=~", "value": "/^$datastore$/" } ] }, { "alias": "Free Space", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "source" ], "type": "tag" }, { "params": [ "null" ], "type": "fill" } ], "measurement": "vsphere_datastore_disk", "orderByTime": "ASC", "policy": "default", "query": "SELECT last(\"capacity_latest\") - last(\"used_latest\") FROM \"vsphere_datastore_disk\" WHERE (\"source\" =~ /^$datastore$/) AND $timeFilter GROUP BY time($__interval), \"source\" fill(null)", "rawQuery": true, "refId": "B", "resultFormat": "time_series", "select": [ [ { "params": [ "capacity_latest" ], "type": "field" }, { "params": [], "type": "mean" } ] ], "tags": [ { "key": "source", "operator": "=~", "value": "/^$datastore$/" } ] } ], "timeFrom": "3h", "title": "Capacity Summary", "type": "grafana-piechart-panel", "valueName": "current" } ], "refresh": "5m", "schemaVersion": 25, "style": "dark", "tags": [ "VMware", "vSphere Datastore", "vSphere Telegraf" ], "templating": { "list": [ { "current": { "selected": false, "text": "default", "value": "default" }, "hide": 0, "includeAll": false, "label": null, "multi": false, "name": "datasource", "options": [], "query": "influxdb", "refresh": 1, "regex": "", "skipUrlSync": false, "type": "datasource" }, { "auto": true, "auto_count": 100, "auto_min": "30s", "current": { "selected": true, "text": "auto", "value": "$__auto_interval_inter" }, "hide": 0, "label": "Sampling", "name": "inter", "options": [ { "selected": true, "text": "auto", "value": "$__auto_interval_inter" }, { "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", "refresh": 2, "skipUrlSync": false, "type": "interval" }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "", "hide": 0, "includeAll": true, "label": "vCenter Server", "multi": true, "name": "vcenter", "options": [], "query": "SHOW TAG VALUES FROM vsphere_host_cpu WITH KEY=vcenter", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "SHOW TAG VALUES FROM vsphere_host_cpu WITH KEY=clustername WHERE \"vcenter\" =~ /$vcenter/", "hide": 0, "includeAll": true, "label": "Cluster", "multi": true, "name": "clustername", "options": [], "query": "SHOW TAG VALUES FROM vsphere_host_cpu WITH KEY=clustername WHERE \"vcenter\" =~ /$vcenter/", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "SHOW TAG VALUES FROM vsphere_host_cpu WITH KEY=esxhostname WHERE \"vcenter\" =~ /$vcenter/", "hide": 0, "includeAll": true, "label": "ESXi Server", "multi": true, "name": "esxi", "options": [], "query": "SHOW TAG VALUES FROM vsphere_host_cpu WITH KEY=esxhostname WHERE \"vcenter\" =~ /$vcenter/", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "SHOW TAG VALUES FROM vsphere_datastore_disk WITH KEY=source WHERE \"vcenter\" =~ /$vcenter/", "hide": 0, "includeAll": true, "label": "Datastore", "multi": true, "name": "datastore", "options": [], "query": "SHOW TAG VALUES FROM vsphere_datastore_disk WITH KEY=source WHERE \"vcenter\" =~ /$vcenter/", "refresh": 1, "regex": "/^(?!VeeamBackup_)/", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": ".*", "current": {}, "datasource": "${DS_INFLUXDB}", "definition": "SHOW TAG VALUES FROM vsphere_vm_cpu WITH KEY=vmname WHERE \"vcenter\" =~ /$vcenter/", "hide": 0, "includeAll": true, "label": "VM", "multi": true, "name": "virtualmachine", "options": [], "query": "SHOW TAG VALUES FROM vsphere_vm_cpu WITH KEY=vmname WHERE \"vcenter\" =~ /$vcenter/", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false } ] }, "time": { "from": "now-24h", "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 - Datastore", "uid": "nr_QGP0iz", "version": 5 }