Parsing And Visualizing Squid Proxy logs in Graylog and Grafana
Squid Proxy logs json
Tutorial from this video: Parsing And Visualizing Squid Proxy logs in Graylog and Grafana :
This is the json for the Grafana graph:
{
“annotations”: {
“list”: [
{
“builtIn”: 1,
“datasource”: “– Grafana –“,
“enable”: true,
“hide”: true,
“iconColor”: “rgba(0, 211, 255, 1)”,
“name”: “Annotations & Alerts”,
“type”: “dashboard”
}
]
},
“editable”: true,
“gnetId”: null,
“graphTooltip”: 0,
“id”: 43,
“links”: [],
“panels”: [
{
“cacheTimeout”: null,
“colorBackground”: true,
“colorValue”: false,
“colors”: [
“#299c46”,
“#0a437c”,
“#967302”
],
“datasource”: “Graylog”,
“format”: “decbytes”,
“gauge”: {
“maxValue”: 100,
“minValue”: 0,
“show”: false,
“thresholdLabels”: false,
“thresholdMarkers”: true
},
“gridPos”: {
“h”: 2,
“w”: 5,
“x”: 0,
“y”: 0
},
“id”: 13,
“interval”: null,
“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”: “100%”,
“rangeMaps”: [
{
“from”: “null”,
“text”: “N/A”,
“to”: “null”
}
],
“sparkline”: {
“fillColor”: “rgba(31, 118, 189, 0.18)”,
“full”: false,
“lineColor”: “rgb(31, 120, 193)”,
“show”: false
},
“tableColumn”: “Count”,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“fake”: true,
“field”: “Bytes”,
“id”: “3”,
“settings”: {
“interval”: 1000,
“min_doc_count”: 1
},
“type”: “histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“thresholds”: “”,
“title”: “Total Traffic”,
“transparent”: true,
“type”: “singlestat”,
“valueFontSize”: “80%”,
“valueMaps”: [
{
“op”: “=”,
“text”: “N/A”,
“value”: “null”
}
],
“valueName”: “avg”
},
{
“cacheTimeout”: null,
“colorBackground”: true,
“colorPrefix”: false,
“colorValue”: false,
“colors”: [
“#fceaca”,
“rgba(237, 129, 40, 0.89)”,
“#fce2de”
],
“datasource”: “Graylog”,
“format”: “none”,
“gauge”: {
“maxValue”: 100,
“minValue”: 0,
“show”: false,
“thresholdLabels”: false,
“thresholdMarkers”: true
},
“gridPos”: {
“h”: 2,
“w”: 7,
“x”: 5,
“y”: 0
},
“id”: 10,
“interval”: null,
“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”: “80%”,
“rangeMaps”: [
{
“from”: “null”,
“text”: “N/A”,
“to”: “null”
}
],
“sparkline”: {
“fillColor”: “rgba(31, 118, 189, 0.18)”,
“full”: false,
“lineColor”: “rgb(31, 120, 193)”,
“show”: false
},
“tableColumn”: “User”,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“fake”: true,
“field”: “User”,
“id”: “3”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_term”,
“size”: “0”
},
“type”: “terms”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“thresholds”: “”,
“title”: “Top Visited Site”,
“transparent”: true,
“type”: “singlestat”,
“valueFontSize”: “70%”,
“valueMaps”: [
{
“op”: “=”,
“text”: “N/A”,
“value”: “null”
}
],
“valueName”: “avg”
},
{
“bgColor”: “rgb(6, 5, 0)”,
“clockType”: “24 hour”,
“countdownSettings”: {
“customFormat”: null,
“endCountdownTime”: “2019-08-09T23:37:00.000Z”,
“endText”: “00:00:00”
},
“dateSettings”: {
“dateFormat”: “YYYY-MM-DD”,
“fontSize”: “20px”,
“fontWeight”: “normal”,
“showDate”: false
},
“gridPos”: {
“h”: 2,
“w”: 7,
“x”: 12,
“y”: 0
},
“id”: 21,
“links”: [],
“mode”: “time”,
“offsetFromUtc”: null,
“offsetFromUtcMinutes”: null,
“refreshSettings”: {
“syncWithDashboard”: false
},
“timeSettings”: {
“customFormat”: “HH:mm:ss”,
“fontSize”: “50px”,
“fontWeight”: “normal”
},
“title”: “Current Time”,
“type”: “grafana-clock-panel”
},
{
“cacheTimeout”: null,
“colorBackground”: true,
“colorValue”: false,
“colors”: [
“#f9d9f9”,
“#0a437c”,
“#967302”
],
“datasource”: “Graylog”,
“format”: “none”,
“gauge”: {
“maxValue”: 100,
“minValue”: 0,
“show”: false,
“thresholdLabels”: false,
“thresholdMarkers”: true
},
“gridPos”: {
“h”: 2,
“w”: 5,
“x”: 19,
“y”: 0
},
“id”: 16,
“interval”: null,
“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”: “100%”,
“rangeMaps”: [
{
“from”: “null”,
“text”: “N/A”,
“to”: “null”
}
],
“sparkline”: {
“fillColor”: “rgba(31, 118, 189, 0.18)”,
“full”: false,
“lineColor”: “rgb(31, 120, 193)”,
“show”: false
},
“tableColumn”: “Client_Address”,
“targets”: [
{
“bucketAggs”: [
{
“field”: “Client_Address”,
“id”: “2”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_count”,
“size”: “1”
},
“type”: “terms”
}
],
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“query”: “*”,
“refId”: “B”,
“timeField”: “timestamp”
}
],
“thresholds”: “”,
“title”: “Top Client/User”,
“transparent”: true,
“type”: “singlestat”,
“valueFontSize”: “80%”,
“valueMaps”: [
{
“op”: “=”,
“text”: “N/A”,
“value”: “null”
}
],
“valueName”: “avg”
},
{
“aliasColors”: {},
“bars”: false,
“dashLength”: 10,
“dashes”: false,
“datasource”: “Graylog”,
“fill”: 0,
“gridPos”: {
“h”: 6,
“w”: 24,
“x”: 0,
“y”: 2
},
“id”: 15,
“legend”: {
“avg”: false,
“current”: false,
“max”: false,
“min”: false,
“show”: true,
“total”: false,
“values”: false
},
“lines”: true,
“linewidth”: 1,
“links”: [],
“nullPointMode”: “null”,
“percentage”: false,
“pointradius”: 5,
“points”: false,
“renderer”: “flot”,
“seriesOverrides”: [],
“spaceLength”: 10,
“stack”: false,
“steppedLine”: false,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“field”: “timestamp”,
“id”: “2”,
“settings”: {
“interval”: “auto”,
“min_doc_count”: 0,
“trimEdges”: 0
},
“type”: “date_histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“thresholds”: [],
“timeFrom”: null,
“timeShift”: null,
“title”: “Events”,
“tooltip”: {
“shared”: true,
“sort”: 0,
“value_type”: “individual”
},
“type”: “graph”,
“xaxis”: {
“buckets”: null,
“mode”: “time”,
“name”: null,
“show”: true,
“values”: []
},
“yaxes”: [
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
},
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
}
],
“yaxis”: {
“align”: false,
“alignLevel”: null
}
},
{
“circleMaxSize”: 30,
“circleMinSize”: 2,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“datasource”: “Graylog”,
“decimals”: 0,
“esMetric”: “Count”,
“gridPos”: {
“h”: 7,
“w”: 11,
“x”: 0,
“y”: 8
},
“hideEmpty”: false,
“hideZero”: false,
“id”: 19,
“initialZoom”: 1,
“links”: [],
“locationData”: “countries”,
“mapCenter”: “(0°, 0°)”,
“mapCenterLatitude”: 0,
“mapCenterLongitude”: 0,
“maxDataPoints”: 1,
“mouseWheelZoom”: false,
“showLegend”: true,
“stickyLabels”: false,
“tableQueryOptions”: {
“geohashField”: “geohash”,
“latitudeField”: “latitude”,
“longitudeField”: “longitude”,
“metricField”: “metric”,
“queryType”: “geohash”
},
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“field”: “gl2_remote_ip”,
“id”: “2”,
“settings”: {
“precision”: 3
},
“type”: “geohash_grid”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“thresholds”: “0,10”,
“title”: “IP Geo-Location”,
“type”: “grafana-worldmap-panel”,
“unitPlural”: “”,
“unitSingle”: “”,
“valueName”: “total”
},
{
“aliasColors”: {},
“breakPoint”: “50%”,
“cacheTimeout”: null,
“combine”: {
“label”: “Others”,
“threshold”: 0
},
“datasource”: “Graylog”,
“fontSize”: “80%”,
“format”: “short”,
“gridPos”: {
“h”: 7,
“w”: 6,
“x”: 11,
“y”: 8
},
“id”: 12,
“interval”: null,
“legend”: {
“show”: true,
“values”: true
},
“legendType”: “Under graph”,
“links”: [],
“maxDataPoints”: 3,
“nullPointMode”: “connected”,
“pieType”: “pie”,
“strokeWidth”: 1,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“fake”: true,
“field”: “Result_Code”,
“id”: “3”,
“settings”: {
“min_doc_count”: 1,
“order”: “asc”,
“orderBy”: “_term”,
“size”: “5”
},
“type”: “terms”
},
{
“field”: “timestamp”,
“id”: “2”,
“settings”: {
“interval”: “auto”,
“min_doc_count”: 0,
“trimEdges”: 0
},
“type”: “date_histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“title”: “Squid Codes”,
“type”: “grafana-piechart-panel”,
“valueName”: “current”
},
{
“aliasColors”: {},
“breakPoint”: “50%”,
“cacheTimeout”: null,
“combine”: {
“label”: “Others”,
“threshold”: 0
},
“datasource”: “Graylog”,
“fontSize”: “80%”,
“format”: “short”,
“gridPos”: {
“h”: 7,
“w”: 7,
“x”: 17,
“y”: 8
},
“id”: 17,
“interval”: null,
“legend”: {
“percentage”: true,
“show”: true,
“values”: true
},
“legendType”: “Under graph”,
“links”: [],
“maxDataPoints”: 3,
“nullPointMode”: “connected”,
“pieType”: “pie”,
“strokeWidth”: 1,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“fake”: true,
“field”: “Peer_Host”,
“id”: “3”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_term”,
“size”: “5”
},
“type”: “terms”
},
{
“field”: “timestamp”,
“id”: “2”,
“settings”: {
“interval”: “auto”,
“min_doc_count”: 0,
“trimEdges”: 0
},
“type”: “date_histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“title”: “Top Destinations”,
“type”: “grafana-piechart-panel”,
“valueName”: “total”
},
{
“columns”: [],
“datasource”: “Graylog”,
“fontSize”: “100%”,
“gridPos”: {
“h”: 6,
“w”: 24,
“x”: 0,
“y”: 15
},
“id”: 23,
“links”: [],
“pageSize”: null,
“scroll”: true,
“showHeader”: true,
“sort”: {
“col”: 0,
“desc”: true
},
“styles”: [
{
“alias”: “Time”,
“dateFormat”: “YYYY-MM-DD HH:mm:ss”,
“link”: false,
“pattern”: “Time”,
“type”: “date”
},
{
“alias”: “”,
“colorMode”: null,
“colors”: [
“rgba(245, 54, 54, 0.9)”,
“rgba(237, 129, 40, 0.89)”,
“rgba(50, 172, 45, 0.97)”
],
“decimals”: 2,
“pattern”: “/.*/”,
“thresholds”: [],
“type”: “number”,
“unit”: “short”
}
],
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“fake”: true,
“field”: “Client_Address”,
“id”: “4”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_term”,
“size”: “10”
},
“type”: “terms”
},
{
“fake”: true,
“field”: “Result_Code”,
“id”: “5”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_term”,
“size”: “10”
},
“type”: “terms”
},
{
“fake”: true,
“field”: “Peer_Host”,
“id”: “6”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_term”,
“size”: “10”
},
“type”: “terms”
},
{
“fake”: true,
“field”: “User”,
“id”: “3”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_term”,
“size”: “10”
},
“type”: “terms”
},
{
“field”: “timestamp”,
“id”: “2”,
“settings”: {
“interval”: “auto”,
“min_doc_count”: 0,
“trimEdges”: 0
},
“type”: “date_histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“title”: “Messages”,
“transform”: “timeseries_to_rows”,
“type”: “table”
},
{
“aliasColors”: {},
“bars”: false,
“dashLength”: 10,
“dashes”: false,
“datasource”: “Graylog”,
“fill”: 1,
“gridPos”: {
“h”: 9,
“w”: 12,
“x”: 0,
“y”: 21
},
“id”: 8,
“legend”: {
“avg”: false,
“current”: false,
“max”: false,
“min”: false,
“show”: true,
“total”: false,
“values”: false
},
“lines”: true,
“linewidth”: 1,
“links”: [],
“nullPointMode”: “null”,
“percentage”: false,
“pointradius”: 5,
“points”: false,
“renderer”: “flot”,
“seriesOverrides”: [],
“spaceLength”: 10,
“stack”: true,
“steppedLine”: false,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“fake”: true,
“field”: “Client_Address”,
“id”: “3”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_term”,
“size”: “10”
},
“type”: “terms”
},
{
“field”: “timestamp”,
“id”: “2”,
“settings”: {
“interval”: “auto”,
“min_doc_count”: 0,
“trimEdges”: 0
},
“type”: “date_histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“thresholds”: [],
“timeFrom”: null,
“timeShift”: null,
“title”: “Top 10 clients and their usage”,
“tooltip”: {
“shared”: true,
“sort”: 0,
“value_type”: “cumulative”
},
“type”: “graph”,
“xaxis”: {
“buckets”: null,
“mode”: “time”,
“name”: null,
“show”: true,
“values”: []
},
“yaxes”: [
{
“format”: “none”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
},
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
}
],
“yaxis”: {
“align”: false,
“alignLevel”: null
}
},
{
“aliasColors”: {},
“bars”: false,
“dashLength”: 10,
“dashes”: false,
“datasource”: “Graylog”,
“fill”: 1,
“gridPos”: {
“h”: 9,
“w”: 12,
“x”: 12,
“y”: 21
},
“id”: 4,
“legend”: {
“avg”: false,
“current”: false,
“max”: false,
“min”: false,
“show”: true,
“total”: false,
“values”: false
},
“lines”: true,
“linewidth”: 1,
“links”: [],
“nullPointMode”: “null”,
“percentage”: false,
“pointradius”: 5,
“points”: false,
“renderer”: “flot”,
“seriesOverrides”: [],
“spaceLength”: 10,
“stack”: false,
“steppedLine”: false,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“fake”: true,
“field”: “Client_Address”,
“id”: “3”,
“settings”: {
“min_doc_count”: 1,
“order”: “desc”,
“orderBy”: “_count”,
“size”: “1”
},
“type”: “terms”
},
{
“field”: “timestamp”,
“id”: “2”,
“settings”: {
“interval”: “auto”,
“min_doc_count”: 0,
“trimEdges”: 0
},
“type”: “date_histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“thresholds”: [],
“timeFrom”: null,
“timeShift”: null,
“title”: “Top User Usage over time”,
“tooltip”: {
“shared”: true,
“sort”: 0,
“value_type”: “individual”
},
“type”: “graph”,
“xaxis”: {
“buckets”: null,
“mode”: “time”,
“name”: null,
“show”: true,
“values”: []
},
“yaxes”: [
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
},
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
}
],
“yaxis”: {
“align”: false,
“alignLevel”: null
}
},
{
“aliasColors”: {},
“bars”: false,
“dashLength”: 10,
“dashes”: false,
“datasource”: “Graylog”,
“fill”: 1,
“gridPos”: {
“h”: 9,
“w”: 12,
“x”: 0,
“y”: 30
},
“id”: 6,
“legend”: {
“avg”: false,
“current”: false,
“max”: false,
“min”: false,
“show”: true,
“total”: false,
“values”: false
},
“lines”: true,
“linewidth”: 1,
“links”: [],
“nullPointMode”: “null”,
“percentage”: false,
“pointradius”: 5,
“points”: false,
“renderer”: “flot”,
“seriesOverrides”: [],
“spaceLength”: 10,
“stack”: false,
“steppedLine”: false,
“targets”: [
{
“application”: {
“filter”: “”
},
“bucketAggs”: [
{
“field”: “timestamp”,
“id”: “2”,
“settings”: {
“interval”: “auto”,
“min_doc_count”: 0,
“trimEdges”: 0
},
“type”: “date_histogram”
}
],
“functions”: [],
“group”: {
“filter”: “”
},
“host”: {
“filter”: “”
},
“item”: {
“filter”: “”
},
“metrics”: [
{
“field”: “select field”,
“id”: “1”,
“type”: “count”
}
],
“mode”: 0,
“options”: {
“showDisabledItems”: false,
“skipEmptyValues”: false
},
“query”: “*”,
“refId”: “A”,
“resultFormat”: “time_series”,
“table”: {
“skipEmptyValues”: false
},
“timeField”: “timestamp”,
“triggers”: {
“acknowledged”: 2,
“count”: true,
“minSeverity”: 3
}
}
],
“thresholds”: [],
“timeFrom”: null,
“timeShift”: null,
“title”: “Total Web Traffic”,
“tooltip”: {
“shared”: true,
“sort”: 0,
“value_type”: “individual”
},
“type”: “graph”,
“xaxis”: {
“buckets”: null,
“mode”: “time”,
“name”: null,
“show”: true,
“values”: []
},
“yaxes”: [
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
},
{
“format”: “short”,
“label”: null,
“logBase”: 1,
“max”: null,
“min”: null,
“show”: true
}
],
“yaxis”: {
“align”: false,
“alignLevel”: null
}
}
],
“schemaVersion”: 16,
“style”: “dark”,
“tags”: [],
“templating”: {
“list”: []
},
“time”: {
“from”: “now-6h”,
“to”: “now”
},
“timepicker”: {
“refresh_intervals”: [
“5s”,
“10s”,
“30s”,
“1m”,
“5m”,
“15m”,
“30m”,
“1h”,
“2h”,
“1d”
],
“time_options”: [
“5m”,
“15m”,
“1h”,
“6h”,
“12h”,
“24h”,
“2d”,
“7d”,
“30d”
]
},
“timezone”: “”,
“title”: “Squid Web Proxy Logs”,
“uid”: “TZUpX_vWk”,
“version”: 62
}