Created
October 3, 2017 06:05
-
-
Save bergquist/1f9e5cf56c65f4ea2260583c45527810 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "annotations": { | |
| "enable": false, | |
| "list": [] | |
| }, | |
| "editable": true, | |
| "gnetId": null, | |
| "graphTooltip": 0, | |
| "hideControls": false, | |
| "id": 2, | |
| "links": [], | |
| "refresh": false, | |
| "rows": [ | |
| { | |
| "collapse": false, | |
| "height": "350px", | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "InfluxDB", | |
| "editable": true, | |
| "error": false, | |
| "fill": 2, | |
| "grid": {}, | |
| "id": 1, | |
| "interval": "$summarize", | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "resolution": 100, | |
| "scale": 1, | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "span": 12, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_hostname", | |
| "dsType": "influxdb", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "auto" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "hostname" | |
| ], | |
| "type": "tag" | |
| } | |
| ], | |
| "measurement": "logins.count", | |
| "policy": "default", | |
| "query": "SELECT mean(\"value\") FROM \"logins.count\" WHERE \"hostname\" =~ /$Hostname$/ AND $timeFilter GROUP BY time($interval), \"hostname\"", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "datacenter", | |
| "operator": "=~", | |
| "value": "/^$datacenter$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "hostname", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ], | |
| "target": "" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Selected Servers", | |
| "tooltip": { | |
| "msResolution": false, | |
| "query_as_alias": true, | |
| "shared": false, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ], | |
| "zerofill": true | |
| } | |
| ], | |
| "repeat": null, | |
| "repeatIteration": null, | |
| "repeatRowId": null, | |
| "showTitle": false, | |
| "title": "New row", | |
| "titleSize": "h6" | |
| } | |
| ], | |
| "schemaVersion": 14, | |
| "style": "dark", | |
| "tags": [ | |
| "influxdb", | |
| "templated", | |
| "misc", | |
| "presentation" | |
| ], | |
| "templating": { | |
| "enable": true, | |
| "list": [ | |
| { | |
| "allValue": null, | |
| "current": { | |
| "text": "Asia", | |
| "value": "Asia" | |
| }, | |
| "datasource": "InfluxDB", | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "datacenter", | |
| "options": [], | |
| "query": "SHOW TAG VALUES WITH KEY = \"datacenter\" ", | |
| "refresh": 1, | |
| "regex": "", | |
| "sort": 0, | |
| "tagValuesQuery": null, | |
| "tags": [], | |
| "tagsQuery": null, | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allFormat": "regex values", | |
| "allValue": null, | |
| "current": { | |
| "text": "All", | |
| "value": "$__all" | |
| }, | |
| "datasource": "InfluxDB", | |
| "hide": 0, | |
| "includeAll": true, | |
| "label": null, | |
| "multi": true, | |
| "multiFormat": "regex values", | |
| "name": "host", | |
| "options": [], | |
| "query": "SHOW TAG VALUES WITH KEY = \"hostname\" WHERE \"datacenter\" =~ /^$datacenter$/", | |
| "refresh": 1, | |
| "refresh_on_load": false, | |
| "regex": "", | |
| "sort": 0, | |
| "tagValuesQuery": null, | |
| "tags": [], | |
| "tagsQuery": null, | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allFormat": "glob", | |
| "auto": true, | |
| "auto_count": 5, | |
| "auto_min": "10s", | |
| "current": { | |
| "text": "1m", | |
| "value": "1m" | |
| }, | |
| "datasource": null, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "", | |
| "name": "summarize", | |
| "options": [ | |
| { | |
| "selected": false, | |
| "text": "auto", | |
| "value": "$__auto_interval" | |
| }, | |
| { | |
| "selected": true, | |
| "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, | |
| "refresh_on_load": false, | |
| "type": "interval" | |
| }, | |
| { | |
| "datasource": "InfluxDB", | |
| "filters": [], | |
| "hide": 0, | |
| "label": null, | |
| "name": "adhoc", | |
| "type": "adhoc" | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-1h", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "collapse": false, | |
| "enable": true, | |
| "notice": false, | |
| "now": true, | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ], | |
| "status": "Stable", | |
| "time_options": [ | |
| "5m", | |
| "15m", | |
| "1h", | |
| "6h", | |
| "12h", | |
| "24h", | |
| "2d", | |
| "7d", | |
| "30d" | |
| ], | |
| "type": "timepicker" | |
| }, | |
| "timezone": "browser", | |
| "title": "InfluxDB Templated Queries", | |
| "version": 11 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment