Hi,

Yeah my bad, I modify it.

2017-06-26 16:05 GMT+02:00 sebb <seb...@gmail.com>:

> On 8 June 2017 at 13:53,  <mchassagn...@apache.org> wrote:
> > Author: mchassagneux
> > Date: Thu Jun  8 12:53:52 2017
> > New Revision: 1798053
> >
> > URL: http://svn.apache.org/viewvc?rev=1798053&view=rev
> > Log:
> > Add a Grafana Template
> > Bugzilla Id: 61167
> >
> > Added:
> >     jmeter/trunk/extras/GrafanaJMeterTemplate.json   (with props)
> >
> > Added: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> > URL: http://svn.apache.org/viewvc/jmeter/trunk/extras/
> GrafanaJMeterTemplate.json?rev=1798053&view=auto
> > ============================================================
> ==================
> > --- jmeter/trunk/extras/GrafanaJMeterTemplate.json (added)
> > +++ jmeter/trunk/extras/GrafanaJMeterTemplate.json Thu Jun  8 12:53:52
> 2017
> > @@ -0,0 +1,1459 @@
> > +{
>
> The characters before the '{' don't look right.
>
> Maybe a spurious UTF BOM?
>
> > +  "id": 97,
> > +  "title": "JMeter Metric Template",
> > +  "tags": [],
> > +  "style": "dark",
> > +  "timezone": "browser",
> > +  "editable": true,
> > +  "sharedCrosshair": true,
> > +  "hideControls": false,
> > +  "time": {
> > +    "from": "2017-06-08T01:09:30.935Z",
> > +    "to": "2017-06-08T02:55:58.972Z"
> > +  },
> > +  "timepicker": {
> > +    "now": true,
> > +    "refresh_intervals": [
> > +      "10s",
> > +      "30s",
> > +      "1m",
> > +      "5m",
> > +      "15m",
> > +      "30m",
> > +      "1h",
> > +      "2h",
> > +      "1d"
> > +    ],
> > +    "time_options": [
> > +      "5m",
> > +      "15m",
> > +      "1h",
> > +      "6h",
> > +      "12h",
> > +      "24h",
> > +      "2d",
> > +      "7d",
> > +      "30d"
> > +    ]
> > +  },
> > +  "templating": {
> > +    "list": [
> > +      {
> > +        "allValue": ".*",
> > +        "datasource": "jmeterdb",
> > +        "hide": 0,
> > +        "includeAll": false,
> > +        "label": null,
> > +        "multi": true,
> > +        "name": "app",
> > +        "options": [],
> > +        "query": "SHOW TAG VALUES FROM \"process\" WITH KEY =
> \"application\"",
> > +        "refresh": 2,
> > +        "regex": "",
> > +        "sort": 1,
> > +        "tagValuesQuery": "",
> > +        "tagsQuery": "SHOW TAG VALUES FROM \"events\" WITH KEY =
> \"tags\"",
> > +        "type": "query"
> > +      },
> > +      {
> > +        "allFormat": "regex wildcard",
> > +        "auto": false,
> > +        "auto_count": 10,
> > +        "auto_min": "10s",
> > +        "current": {
> > +          "text": "1m",
> > +          "value": "1m"
> > +        },
> > +        "datasource": "jmeterdb",
> > +        "hide": 0,
> > +        "includeAll": true,
> > +        "label": "",
> > +        "multi": false,
> > +        "multiFormat": "glob",
> > +        "name": "granularity",
> > +        "options": [
> > +          {
> > +            "text": "1m",
> > +            "value": "1m",
> > +            "selected": true
> > +          },
> > +          {
> > +            "text": "5m",
> > +            "value": "5m",
> > +            "selected": false
> > +          },
> > +          {
> > +            "text": "1h",
> > +            "value": "1h",
> > +            "selected": false
> > +          },
> > +          {
> > +            "text": "5s",
> > +            "value": "5s",
> > +            "selected": false
> > +          },
> > +          {
> > +            "text": "15s",
> > +            "value": "15s",
> > +            "selected": false
> > +          },
> > +          {
> > +            "text": "30s",
> > +            "value": "30s",
> > +            "selected": false
> > +          }
> > +        ],
> > +        "query": "1m,5m,1h,5s,15s,30s",
> > +        "refresh": 2,
> > +        "regex": "",
> > +        "type": "interval"
> > +      },
> > +      {
> > +        "allValue": null,
> > +        "current": {
> > +          "text": "default",
> > +          "value": "default",
> > +          "tags": []
> > +        },
> > +        "datasource": "jmeterdb",
> > +        "hide": 0,
> > +        "includeAll": false,
> > +        "label": null,
> > +        "multi": false,
> > +        "name": "retention",
> > +        "options": [],
> > +        "query": "SHOW RETENTION POLICIES ON \"jmeterdb\"",
> > +        "refresh": 1,
> > +        "regex": "",
> > +        "sort": 0,
> > +        "tagValuesQuery": null,
> > +        "tagsQuery": null,
> > +        "type": "query"
> > +      },
> > +      {
> > +        "allValue": ".*",
> > +        "current": {
> > +          "value": [
> > +            "$__all"
> > +          ],
> > +          "text": "All"
> > +        },
> > +        "datasource": "jmeterdb",
> > +        "hide": 0,
> > +        "includeAll": true,
> > +        "label": null,
> > +        "multi": true,
> > +        "name": "transaction",
> > +        "options": [],
> > +        "query": "SHOW TAG VALUES FROM \"jmeter\" WITH KEY IN
> (\"transaction\",\"application\") where application =~ /$app/ and
> transaction  !~ /all/",
> > +        "refresh": 2,
> > +        "regex": "",
> > +        "sort": 0,
> > +        "tagValuesQuery": null,
> > +        "tagsQuery": null,
> > +        "type": "query"
> > +      }
> > +    ]
> > +  },
> > +  "annotations": {
> > +    "list": [
> > +      {
> > +        "datasource": "jmeterdb",
> > +        "enable": true,
> > +        "iconColor": "rgb(237, 18, 18)",
> > +        "iconSize": 17,
> > +        "lineColor": "rgb(0, 21, 255)",
> > +        "name": "Annotation",
> > +        "query": "select text,tags,title from \"$retention\".\"events\"
> where application =~ /$app/ AND $timeFilter",
> > +        "showLine": true,
> > +        "textColumn": "text",
> > +        "titleColumn": "title",
> > +        "tagsColumn": "tags"
> > +      }
> > +    ]
> > +  },
> > +  "refresh": false,
> > +  "schemaVersion": 13,
> > +  "version": 0,
> > +  "links": [
> > +    {
> > +      "asDropdown": true,
> > +      "icon": "dashboard",
> > +      "includeVars": true,
> > +      "keepTime": true,
> > +      "tags": [],
> > +      "targetBlank": true,
> > +      "tooltip": "",
> > +      "type": "dashboards",
> > +      "url": ""
> > +    }
> > +  ],
> > +  "gnetId": null,
> > +  "rows": [
> > +    {
> > +      "title": "Jmeter Metrics",
> > +      "panels": [
> > +        {
> > +          "cacheTimeout": null,
> > +          "colorBackground": false,
> > +          "colorValue": false,
> > +          "colors": [
> > +            "rgba(245, 54, 54, 0.9)",
> > +            "rgba(237, 129, 40, 0.89)",
> > +            "rgba(50, 172, 45, 0.97)"
> > +          ],
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "format": "none",
> > +          "gauge": {
> > +            "maxValue": 100,
> > +            "minValue": 0,
> > +            "show": false,
> > +            "thresholdLabels": false,
> > +            "thresholdMarkers": true
> > +          },
> > +          "id": 19,
> > +          "interval": "$granularity",
> > +          "links": [],
> > +          "mappingType": 1,
> > +          "mappingTypes": [
> > +            {
> > +              "name": "value to text",
> > +              "value": 1
> > +            },
> > +            {
> > +              "name": "range to text",
> > +              "value": 2
> > +            }
> > +          ],
> > +          "maxDataPoints": 100,
> > +          "nullPointMode": "connected",
> > +          "nullText": null,
> > +          "postfix": " users",
> > +          "postfixFontSize": "50%",
> > +          "prefix": "",
> > +          "prefixFontSize": "50%",
> > +          "rangeMaps": [
> > +            {
> > +              "from": "null",
> > +              "text": "N/A",
> > +              "to": "null"
> > +            }
> > +          ],
> > +          "span": 4,
> > +          "sparkline": {
> > +            "fillColor": "rgba(31, 118, 189, 0.18)",
> > +            "full": true,
> > +            "lineColor": "rgb(31, 120, 193)",
> > +            "show": true
> > +          },
> > +          "targets": [
> > +            {
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "$granularity"
> > +                  ],
> > +                  "type": "time"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "null"
> > +                  ],
> > +                  "type": "fill"
> > +                }
> > +              ],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT last(\"startedT\") FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity)
> fill(null)",
> > +              "refId": "A",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "meanAT"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "last"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": "",
> > +          "title": "Active Users",
> > +          "type": "singlestat",
> > +          "valueFontSize": "80%",
> > +          "valueMaps": [
> > +            {
> > +              "op": "=",
> > +              "text": "0",
> > +              "value": "null"
> > +            }
> > +          ],
> > +          "valueName": "current"
> > +        },
> > +        {
> > +          "cacheTimeout": null,
> > +          "colorBackground": false,
> > +          "colorValue": false,
> > +          "colors": [
> > +            "rgba(245, 54, 54, 0.9)",
> > +            "rgba(237, 129, 40, 0.89)",
> > +            "rgba(50, 172, 45, 0.97)"
> > +          ],
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "format": "none",
> > +          "gauge": {
> > +            "maxValue": 100,
> > +            "minValue": 0,
> > +            "show": false,
> > +            "thresholdLabels": false,
> > +            "thresholdMarkers": true
> > +          },
> > +          "id": 17,
> > +          "interval": "",
> > +          "links": [],
> > +          "mappingType": 1,
> > +          "mappingTypes": [
> > +            {
> > +              "name": "value to text",
> > +              "value": 1
> > +            },
> > +            {
> > +              "name": "range to text",
> > +              "value": 2
> > +            }
> > +          ],
> > +          "maxDataPoints": 100,
> > +          "nullPointMode": "connected",
> > +          "nullText": null,
> > +          "postfix": " TPS",
> > +          "postfixFontSize": "50%",
> > +          "prefix": "",
> > +          "prefixFontSize": "50%",
> > +          "rangeMaps": [
> > +            {
> > +              "from": "null",
> > +              "text": "N/A",
> > +              "to": "null"
> > +            }
> > +          ],
> > +          "span": 4,
> > +          "sparkline": {
> > +            "fillColor": "rgba(31, 118, 189, 0.18)",
> > +            "full": true,
> > +            "lineColor": "rgb(31, 120, 193)",
> > +            "show": true
> > +          },
> > +          "targets": [
> > +            {
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "$granularity"
> > +                  ],
> > +                  "type": "time"
> > +                }
> > +              ],
> > +              "measurement": "jmeter",
> > +              "policy": "default",
> > +              "query": "SELECT sum(\"hit\")  / 30 FROM
> \"$retention\".\"jmeter\" WHERE \"application\" = '$app' AND
> \"transaction\" = 'all' AND $timeFilter GROUP BY time(30s)",
> > +              "rawQuery": true,
> > +              "refId": "A",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "hit"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "last"
> > +                  },
> > +                  {
> > +                    "params": [
> > +                      " / 5"
> > +                    ],
> > +                    "type": "math"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "transaction",
> > +                  "operator": "=",
> > +                  "value": "all"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": "",
> > +          "title": "Currents hits per Second",
> > +          "type": "singlestat",
> > +          "valueFontSize": "80%",
> > +          "valueMaps": [
> > +            {
> > +              "op": "=",
> > +              "text": "0",
> > +              "value": "null"
> > +            }
> > +          ],
> > +          "valueName": "current"
> > +        },
> > +        {
> > +          "cacheTimeout": null,
> > +          "colorBackground": false,
> > +          "colorValue": true,
> > +          "colors": [
> > +            "rgba(50, 172, 45, 0.97)",
> > +            "rgba(237, 129, 40, 0.89)",
> > +            "rgba(245, 54, 54, 0.9)"
> > +          ],
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "format": "percentunit",
> > +          "gauge": {
> > +            "maxValue": 100,
> > +            "minValue": 0,
> > +            "show": false,
> > +            "thresholdLabels": false,
> > +            "thresholdMarkers": true
> > +          },
> > +          "id": 21,
> > +          "interval": "$granularity",
> > +          "links": [],
> > +          "mappingType": 1,
> > +          "mappingTypes": [
> > +            {
> > +              "name": "value to text",
> > +              "value": 1
> > +            },
> > +            {
> > +              "name": "range to text",
> > +              "value": 2
> > +            }
> > +          ],
> > +          "maxDataPoints": 100,
> > +          "nullPointMode": "connected",
> > +          "nullText": null,
> > +          "postfix": "",
> > +          "postfixFontSize": "50%",
> > +          "prefix": "",
> > +          "prefixFontSize": "50%",
> > +          "rangeMaps": [
> > +            {
> > +              "from": "null",
> > +              "text": "N/A",
> > +              "to": "null"
> > +            }
> > +          ],
> > +          "span": 4,
> > +          "sparkline": {
> > +            "fillColor": "rgba(31, 118, 189, 0.18)",
> > +            "full": true,
> > +            "lineColor": "rgb(31, 120, 193)",
> > +            "show": true
> > +          },
> > +          "targets": [
> > +            {
> > +              "dsType": "influxdb",
> > +              "groupBy": [],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT sum(\"countError\")  / sum(\"count\")
> FROM \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND
> \"transaction\" = 'all' AND $timeFilter",
> > +              "rawQuery": true,
> > +              "refId": "B",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "countError"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "sum"
> > +                  },
> > +                  {
> > +                    "params": [
> > +                      " / sum(\"count\")"
> > +                    ],
> > +                    "type": "math"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "transaction",
> > +                  "operator": "=",
> > +                  "value": "all"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": "0.1,0.2",
> > +          "title": "% Errors",
> > +          "type": "singlestat",
> > +          "valueFontSize": "80%",
> > +          "valueMaps": [
> > +            {
> > +              "op": "=",
> > +              "text": "0",
> > +              "value": "null"
> > +            }
> > +          ],
> > +          "valueName": "total"
> > +        },
> > +        {
> > +          "aliasColors": {},
> > +          "bars": false,
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "fill": 1,
> > +          "grid": {},
> > +          "id": 27,
> > +          "interval": "$granularity",
> > +          "legend": {
> > +            "avg": false,
> > +            "current": false,
> > +            "max": false,
> > +            "min": false,
> > +            "show": false,
> > +            "total": false,
> > +            "values": false
> > +          },
> > +          "lines": true,
> > +          "linewidth": 1,
> > +          "links": [],
> > +          "nullPointMode": "null as zero",
> > +          "percentage": false,
> > +          "pointradius": 5,
> > +          "points": false,
> > +          "renderer": "flot",
> > +          "seriesOverrides": [],
> > +          "span": 4,
> > +          "stack": false,
> > +          "steppedLine": true,
> > +          "targets": [
> > +            {
> > +              "alias": "Hits",
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "$granularity"
> > +                  ],
> > +                  "type": "time"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "null"
> > +                  ],
> > +                  "type": "fill"
> > +                }
> > +              ],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT last(\"hit\")  / 5 FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity)
> fill(null)",
> > +              "refId": "A",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "hit"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "last"
> > +                  },
> > +                  {
> > +                    "params": [
> > +                      " / 5"
> > +                    ],
> > +                    "type": "math"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": [],
> > +          "timeFrom": null,
> > +          "timeShift": null,
> > +          "title": "Hits per Second",
> > +          "tooltip": {
> > +            "msResolution": false,
> > +            "shared": true,
> > +            "sort": 0,
> > +            "value_type": "cumulative"
> > +          },
> > +          "type": "graph",
> > +          "xaxis": {
> > +            "mode": "time",
> > +            "name": null,
> > +            "show": false,
> > +            "values": []
> > +          },
> > +          "yaxes": [
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": 0,
> > +              "show": true
> > +            },
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            }
> > +          ]
> > +        },
> > +        {
> > +          "cacheTimeout": null,
> > +          "colorBackground": false,
> > +          "colorValue": false,
> > +          "colors": [
> > +            "rgba(245, 54, 54, 0.9)",
> > +            "rgba(237, 129, 40, 0.89)",
> > +            "rgba(50, 172, 45, 0.97)"
> > +          ],
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "format": "none",
> > +          "gauge": {
> > +            "maxValue": 100,
> > +            "minValue": 0,
> > +            "show": false,
> > +            "thresholdLabels": false,
> > +            "thresholdMarkers": true
> > +          },
> > +          "id": 22,
> > +          "interval": "$granularity",
> > +          "links": [],
> > +          "mappingType": 1,
> > +          "mappingTypes": [
> > +            {
> > +              "name": "value to text",
> > +              "value": 1
> > +            },
> > +            {
> > +              "name": "range to text",
> > +              "value": 2
> > +            }
> > +          ],
> > +          "maxDataPoints": 100,
> > +          "nullPointMode": "connected",
> > +          "nullText": null,
> > +          "postfix": "",
> > +          "postfixFontSize": "50%",
> > +          "prefix": "",
> > +          "prefixFontSize": "50%",
> > +          "rangeMaps": [
> > +            {
> > +              "from": "null",
> > +              "text": "N/A",
> > +              "to": "null"
> > +            }
> > +          ],
> > +          "span": 4,
> > +          "sparkline": {
> > +            "fillColor": "rgba(31, 118, 189, 0.18)",
> > +            "full": true,
> > +            "lineColor": "rgb(31, 120, 193)",
> > +            "show": true
> > +          },
> > +          "targets": [
> > +            {
> > +              "dsType": "influxdb",
> > +              "groupBy": [],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT \"hit\" FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND \"statut\" = 'all' AND $timeFilter",
> > +              "rawQuery": false,
> > +              "refId": "A",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "hit"
> > +                    ],
> > +                    "type": "field"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "statut",
> > +                  "operator": "=",
> > +                  "value": "all"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": "",
> > +          "title": "Total Hits",
> > +          "type": "singlestat",
> > +          "valueFontSize": "80%",
> > +          "valueMaps": [
> > +            {
> > +              "op": "=",
> > +              "text": "0",
> > +              "value": "null"
> > +            }
> > +          ],
> > +          "valueName": "total"
> > +        },
> > +        {
> > +          "aliasColors": {},
> > +          "bars": false,
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "fill": 1,
> > +          "grid": {},
> > +          "id": 28,
> > +          "interval": "$granularity",
> > +          "legend": {
> > +            "avg": false,
> > +            "current": false,
> > +            "max": false,
> > +            "min": false,
> > +            "show": false,
> > +            "total": false,
> > +            "values": false
> > +          },
> > +          "lines": true,
> > +          "linewidth": 1,
> > +          "links": [],
> > +          "nullPointMode": "null",
> > +          "percentage": false,
> > +          "pointradius": 5,
> > +          "points": false,
> > +          "renderer": "flot",
> > +          "seriesOverrides": [],
> > +          "span": 4,
> > +          "stack": false,
> > +          "steppedLine": true,
> > +          "targets": [
> > +            {
> > +              "alias": "Errors",
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "$granularity"
> > +                  ],
> > +                  "type": "time"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "0"
> > +                  ],
> > +                  "type": "fill"
> > +                }
> > +              ],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT mean(\"countError\")  / 5 FROM
> \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY
> time($granularity) fill(0)",
> > +              "rawQuery": false,
> > +              "refId": "A",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "countError"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "mean"
> > +                  },
> > +                  {
> > +                    "params": [
> > +                      " / 5"
> > +                    ],
> > +                    "type": "math"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": [],
> > +          "timeFrom": null,
> > +          "timeShift": null,
> > +          "title": "Errors per Second",
> > +          "tooltip": {
> > +            "msResolution": false,
> > +            "shared": true,
> > +            "sort": 0,
> > +            "value_type": "cumulative"
> > +          },
> > +          "type": "graph",
> > +          "xaxis": {
> > +            "mode": "time",
> > +            "name": null,
> > +            "show": false,
> > +            "values": []
> > +          },
> > +          "yaxes": [
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": 0,
> > +              "show": true
> > +            },
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            }
> > +          ]
> > +        }
> > +      ],
> > +      "showTitle": true,
> > +      "titleSize": "h6",
> > +      "height": "150px",
> > +      "repeat": null,
> > +      "repeatRowId": null,
> > +      "repeatIteration": null,
> > +      "collapse": false
> > +    },
> > +    {
> > +      "title": "Application Metrics",
> > +      "panels": [
> > +        {
> > +          "aliasColors": {},
> > +          "bars": false,
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "fill": 1,
> > +          "grid": {},
> > +          "height": "",
> > +          "id": 25,
> > +          "interval": "$granularity",
> > +          "legend": {
> > +            "alignAsTable": true,
> > +            "avg": true,
> > +            "current": true,
> > +            "hideEmpty": false,
> > +            "max": true,
> > +            "min": true,
> > +            "rightSide": false,
> > +            "show": true,
> > +            "total": false,
> > +            "values": true
> > +          },
> > +          "lines": true,
> > +          "linewidth": 1,
> > +          "links": [],
> > +          "minSpan": 12,
> > +          "nullPointMode": "null",
> > +          "percentage": false,
> > +          "pointradius": 5,
> > +          "points": false,
> > +          "renderer": "flot",
> > +          "seriesOverrides": [],
> > +          "span": 12,
> > +          "stack": false,
> > +          "steppedLine": true,
> > +          "targets": [
> > +            {
> > +              "alias": "$tag_transaction",
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "$granularity"
> > +                  ],
> > +                  "type": "time"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "transaction"
> > +                  ],
> > +                  "type": "tag"
> > +                }
> > +              ],
> > +              "hide": false,
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT mean(\"avg\") FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity),
> \"transaction\"",
> > +              "rawQuery": false,
> > +              "refId": "A",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "avg"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "mean"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "statut",
> > +                  "operator": "=",
> > +                  "value": "all"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": [],
> > +          "timeFrom": null,
> > +          "timeShift": null,
> > +          "title": "Average Response Time",
> > +          "tooltip": {
> > +            "msResolution": false,
> > +            "shared": false,
> > +            "sort": 0,
> > +            "value_type": "cumulative"
> > +          },
> > +          "transparent": false,
> > +          "type": "graph",
> > +          "xaxis": {
> > +            "mode": "time",
> > +            "name": null,
> > +            "show": true,
> > +            "values": []
> > +          },
> > +          "yaxes": [
> > +            {
> > +              "format": "ms",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            },
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            }
> > +          ]
> > +        },
> > +        {
> > +          "aliasColors": {},
> > +          "bars": false,
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "fill": 1,
> > +          "grid": {},
> > +          "height": "",
> > +          "id": 26,
> > +          "interval": "$granularity",
> > +          "legend": {
> > +            "alignAsTable": true,
> > +            "avg": true,
> > +            "current": true,
> > +            "hideEmpty": false,
> > +            "max": true,
> > +            "min": true,
> > +            "rightSide": false,
> > +            "show": true,
> > +            "sort": "current",
> > +            "sortDesc": true,
> > +            "total": false,
> > +            "values": true
> > +          },
> > +          "lines": true,
> > +          "linewidth": 1,
> > +          "links": [],
> > +          "minSpan": 12,
> > +          "nullPointMode": "null",
> > +          "percentage": false,
> > +          "pointradius": 5,
> > +          "points": false,
> > +          "renderer": "flot",
> > +          "seriesOverrides": [],
> > +          "span": 12,
> > +          "stack": false,
> > +          "steppedLine": true,
> > +          "targets": [
> > +            {
> > +              "alias": "$tag_transaction",
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "30s"
> > +                  ],
> > +                  "type": "time"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "transaction"
> > +                  ],
> > +                  "type": "tag"
> > +                }
> > +              ],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT mean(\"count\")  / 5 FROM \"jmeter\"
> WHERE \"application\" =~ /$app$/ AND \"transaction\" <> 'all' AND
> $timeFilter GROUP BY time($granularity), \"transaction\"",
> > +              "rawQuery": false,
> > +              "refId": "A",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "count"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "sum"
> > +                  },
> > +                  {
> > +                    "params": [
> > +                      " / 30"
> > +                    ],
> > +                    "type": "math"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "transaction",
> > +                  "operator": "<>",
> > +                  "value": "all"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "statut",
> > +                  "operator": "=",
> > +                  "value": "all"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": [],
> > +          "timeFrom": null,
> > +          "timeShift": null,
> > +          "title": "Transaction Per Second",
> > +          "tooltip": {
> > +            "msResolution": false,
> > +            "shared": false,
> > +            "sort": 0,
> > +            "value_type": "cumulative"
> > +          },
> > +          "transparent": false,
> > +          "type": "graph",
> > +          "xaxis": {
> > +            "mode": "time",
> > +            "name": null,
> > +            "show": true,
> > +            "values": []
> > +          },
> > +          "yaxes": [
> > +            {
> > +              "format": "ops",
> > +              "label": "",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            },
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            }
> > +          ]
> > +        },
> > +        {
> > +          "aliasColors": {},
> > +          "bars": false,
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "fill": 1,
> > +          "grid": {},
> > +          "height": "",
> > +          "id": 29,
> > +          "interval": "$granularity",
> > +          "legend": {
> > +            "alignAsTable": true,
> > +            "avg": true,
> > +            "current": true,
> > +            "hideEmpty": false,
> > +            "max": true,
> > +            "min": true,
> > +            "rightSide": false,
> > +            "show": true,
> > +            "total": false,
> > +            "values": true
> > +          },
> > +          "lines": true,
> > +          "linewidth": 1,
> > +          "links": [],
> > +          "minSpan": 12,
> > +          "nullPointMode": "null",
> > +          "percentage": false,
> > +          "pointradius": 5,
> > +          "points": false,
> > +          "renderer": "flot",
> > +          "seriesOverrides": [],
> > +          "span": 12,
> > +          "stack": false,
> > +          "steppedLine": true,
> > +          "targets": [
> > +            {
> > +              "alias": "$tag_transaction",
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "30s"
> > +                  ],
> > +                  "type": "time"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "transaction"
> > +                  ],
> > +                  "type": "tag"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "null"
> > +                  ],
> > +                  "type": "fill"
> > +                }
> > +              ],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT last(\"count\")  / 30 FROM
> \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" =
> 'ko' AND $timeFilter GROUP BY time(30s), \"transaction\" fill(null)",
> > +              "rawQuery": false,
> > +              "refId": "B",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "count"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "sum"
> > +                  },
> > +                  {
> > +                    "params": [
> > +                      " / 30"
> > +                    ],
> > +                    "type": "math"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "statut",
> > +                  "operator": "=",
> > +                  "value": "ko"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": [],
> > +          "timeFrom": null,
> > +          "timeShift": null,
> > +          "title": "Error Per Second",
> > +          "tooltip": {
> > +            "msResolution": false,
> > +            "shared": false,
> > +            "sort": 0,
> > +            "value_type": "cumulative"
> > +          },
> > +          "transparent": false,
> > +          "type": "graph",
> > +          "xaxis": {
> > +            "mode": "time",
> > +            "name": null,
> > +            "show": true,
> > +            "values": []
> > +          },
> > +          "yaxes": [
> > +            {
> > +              "format": "ops",
> > +              "label": "",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            },
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            }
> > +          ]
> > +        },
> > +        {
> > +          "aliasColors": {},
> > +          "bars": false,
> > +          "datasource": "jmeterdb",
> > +          "editable": true,
> > +          "error": false,
> > +          "fill": 1,
> > +          "grid": {},
> > +          "height": "",
> > +          "id": 34,
> > +          "interval": "",
> > +          "legend": {
> > +            "alignAsTable": true,
> > +            "avg": true,
> > +            "current": true,
> > +            "hideEmpty": true,
> > +            "hideZero": true,
> > +            "max": true,
> > +            "min": true,
> > +            "rightSide": false,
> > +            "show": true,
> > +            "total": false,
> > +            "values": true
> > +          },
> > +          "lines": true,
> > +          "linewidth": 1,
> > +          "links": [],
> > +          "minSpan": 12,
> > +          "nullPointMode": "null",
> > +          "percentage": false,
> > +          "pointradius": 1,
> > +          "points": false,
> > +          "renderer": "flot",
> > +          "seriesOverrides": [],
> > +          "span": 12,
> > +          "stack": false,
> > +          "steppedLine": true,
> > +          "targets": [
> > +            {
> > +              "alias": "$tag_transaction - $tag_responseCode :
> $tag_responseMessage",
> > +              "dsType": "influxdb",
> > +              "groupBy": [
> > +                {
> > +                  "params": [
> > +                    "30s"
> > +                  ],
> > +                  "type": "time"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "responseMessage"
> > +                  ],
> > +                  "type": "tag"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "responseCode"
> > +                  ],
> > +                  "type": "tag"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "transaction"
> > +                  ],
> > +                  "type": "tag"
> > +                },
> > +                {
> > +                  "params": [
> > +                    "null"
> > +                  ],
> > +                  "type": "fill"
> > +                }
> > +              ],
> > +              "measurement": "jmeter",
> > +              "policy": "$retention",
> > +              "query": "SELECT sum(\"count\")  / 5 FROM \"jmeter\"
> WHERE \"application\" =~ /$app$/ AND \"statut\" = 'ko' AND $timeFilter
> GROUP BY time($granularity), \"responseCode\" fill(null)",
> > +              "rawQuery": false,
> > +              "refId": "B",
> > +              "resultFormat": "time_series",
> > +              "select": [
> > +                [
> > +                  {
> > +                    "params": [
> > +                      "count"
> > +                    ],
> > +                    "type": "field"
> > +                  },
> > +                  {
> > +                    "params": [],
> > +                    "type": "sum"
> > +                  },
> > +                  {
> > +                    "params": [
> > +                      " / 30"
> > +                    ],
> > +                    "type": "math"
> > +                  }
> > +                ]
> > +              ],
> > +              "tags": [
> > +                {
> > +                  "key": "application",
> > +                  "operator": "=~",
> > +                  "value": "/$app$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "responseCode",
> > +                  "operator": "!~",
> > +                  "value": "/^0$|^$/"
> > +                },
> > +                {
> > +                  "condition": "AND",
> > +                  "key": "transaction",
> > +                  "operator": "=~",
> > +                  "value": "/$transaction/"
> > +                }
> > +              ]
> > +            }
> > +          ],
> > +          "thresholds": [],
> > +          "timeFrom": null,
> > +          "timeShift": null,
> > +          "title": "Error detail",
> > +          "tooltip": {
> > +            "msResolution": false,
> > +            "shared": true,
> > +            "sort": 0,
> > +            "value_type": "cumulative"
> > +          },
> > +          "transparent": false,
> > +          "type": "graph",
> > +          "xaxis": {
> > +            "mode": "time",
> > +            "name": null,
> > +            "show": true,
> > +            "values": []
> > +          },
> > +          "yaxes": [
> > +            {
> > +              "format": "none",
> > +              "label": "",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            },
> > +            {
> > +              "format": "short",
> > +              "logBase": 1,
> > +              "max": null,
> > +              "min": null,
> > +              "show": true
> > +            }
> > +          ]
> > +        }
> > +      ],
> > +      "showTitle": true,
> > +      "titleSize": "h6",
> > +      "height": "700px",
> > +      "repeat": null,
> > +      "repeatRowId": null,
> > +      "repeatIteration": null,
> > +      "collapse": false
> > +    }
> > +  ]
> > +}
> > \ No newline at end of file
> >
> > Propchange: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> > ------------------------------------------------------------
> ------------------
> >     svn:eol-style = native
> >
> >
>
>

Reply via email to