Skip to content

Instantly share code, notes, and snippets.

@bre7
Last active August 29, 2015 14:09
Show Gist options
  • Save bre7/add017d84d9cde2796e3 to your computer and use it in GitHub Desktop.
Save bre7/add017d84d9cde2796e3 to your computer and use it in GitHub Desktop.
YA Kibana Apache Panel
{
"title": "ApacheLogs2",
"services": {
"query": {
"list": {
"0": {
"query": "response:(NOT [400 TO 599]) AND useragent_device:(NOT \"Spider\")",
"alias": "exitoso_no_spider",
"color": "#7EB26D",
"id": 0,
"pin": true,
"type": "lucene",
"enable": true
},
"1": {
"id": 1,
"color": "#EAB839",
"alias": "no_exitoso",
"pin": false,
"type": "lucene",
"enable": true,
"query": "response:[400 TO 599]"
},
"2": {
"id": 2,
"color": "#6ED0E0",
"alias": "spider",
"pin": false,
"type": "lucene",
"enable": true,
"query": "useragent_device:\"Spider\""
},
"3": {
"id": 3,
"color": "#EF843C",
"alias": "exitoso",
"pin": false,
"type": "lucene",
"enable": true,
"query": "response:(NOT [400 TO 599])"
},
"4": {
"id": 4,
"color": "#E24D42",
"alias": "no_spider",
"pin": false,
"type": "lucene",
"enable": true,
"query": "useragent_device:(NOT \"Spider\")"
},
"5": {
"id": 5,
"color": "#1F78C1",
"alias": "",
"pin": false,
"type": "lucene",
"enable": true,
"query": "*"
}
},
"ids": [
0,
1,
2,
3,
4,
5
]
},
"filter": {
"list": {
"0": {
"type": "field",
"field": "referrer",
"query": "*revistabodas.com.uy*",
"mandate": "mustNot",
"active": false,
"alias": "",
"id": 0
},
"1": {
"type": "field",
"field": "referrer",
"query": "-*",
"mandate": "must",
"active": false,
"alias": "",
"id": 1
},
"2": {
"type": "field",
"field": "useragent_device",
"query": "\"Spider\"",
"mandate": "must",
"active": false,
"alias": "",
"id": 2
},
"3": {
"type": "field",
"field": "referrer",
"query": "*google.*",
"mandate": "mustNot",
"active": false,
"alias": "",
"id": 3
},
"4": {
"type": "querystring",
"query": "referrer:*yahoo.*",
"mandate": "mustNot",
"active": false,
"alias": "",
"id": 4
},
"5": {
"type": "field",
"field": "response",
"query": "4*",
"mandate": "must",
"active": false,
"alias": "",
"id": 5
},
"6": {
"type": "terms",
"field": "request",
"value": "layout",
"mandate": "must",
"active": false,
"alias": "",
"id": 6
},
"7": {
"type": "terms",
"field": "response.raw",
"value": "404",
"mandate": "must",
"active": false,
"alias": "",
"id": 7
},
"8": {
"type": "field",
"field": "request",
"query": "*.gif",
"mandate": "mustNot",
"active": false,
"alias": "",
"id": 8
},
"9": {
"type": "field",
"field": "request",
"query": "\"/favicon.ico\"",
"mandate": "mustNot",
"active": false,
"alias": "",
"id": 9
},
"10": {
"type": "field",
"field": "request",
"query": "*.css",
"mandate": "mustNot",
"active": false,
"alias": "",
"id": 10
},
"11": {
"type": "field",
"field": "request",
"query": "*.jpg",
"mandate": "mustNot",
"active": false,
"alias": "",
"id": 11
}
},
"ids": [
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11
]
}
},
"rows": [
{
"title": "Hits",
"height": "150px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"span": 12,
"editable": true,
"type": "histogram",
"loadingEditor": false,
"mode": "count",
"time_field": "@timestamp",
"value_field": null,
"x-axis": true,
"y-axis": true,
"scale": 1,
"y_format": "none",
"grid": {
"max": null,
"min": 0
},
"queries": {
"mode": "all",
"ids": [
0,
1,
2,
3,
4,
5
]
},
"annotate": {
"enable": false,
"query": "*",
"size": 20,
"field": "_type",
"sort": [
"_score",
"desc"
]
},
"auto_int": false,
"resolution": 100,
"interval": "24h",
"intervals": [
"auto",
"1s",
"1m",
"5m",
"10m",
"30m",
"1h",
"3h",
"12h",
"1d",
"1w",
"1y"
],
"lines": true,
"fill": 0,
"linewidth": 3,
"points": false,
"pointradius": 5,
"bars": false,
"stack": true,
"spyable": true,
"zoomlinks": true,
"options": true,
"legend": true,
"show_query": true,
"interactive": true,
"legend_counts": true,
"timezone": "browser",
"percentage": false,
"zerofill": true,
"derivative": false,
"tooltip": {
"value_type": "cumulative",
"query_as_alias": true
}
}
],
"notice": false
},
{
"title": "Requests",
"height": "150px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"error": false,
"span": 3,
"editable": true,
"type": "terms",
"loadingEditor": false,
"field": "verb",
"exclude": [],
"missing": true,
"other": true,
"size": 10,
"order": "count",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"arrangement": "horizontal",
"chart": "pie",
"counter_pos": "above",
"spyable": true,
"queries": {
"mode": "pinned",
"ids": [
0
]
},
"tmode": "terms",
"tstat": "total",
"valuefield": "",
"title": "HTTP Method"
},
{
"error": false,
"span": 6,
"editable": true,
"type": "terms",
"loadingEditor": false,
"field": "request",
"exclude": [],
"missing": true,
"other": true,
"size": 10,
"order": "count",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"arrangement": "horizontal",
"chart": "bar",
"counter_pos": "above",
"spyable": true,
"queries": {
"mode": "pinned",
"ids": [
0
]
},
"tmode": "terms",
"tstat": "total",
"valuefield": "",
"title": "Request"
},
{
"error": false,
"span": 3,
"editable": true,
"type": "terms",
"loadingEditor": false,
"field": "response",
"exclude": [],
"missing": false,
"other": false,
"size": 10,
"order": "count",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"arrangement": "horizontal",
"chart": "pie",
"counter_pos": "above",
"spyable": true,
"queries": {
"mode": "pinned",
"ids": [
0
]
},
"tmode": "terms",
"tstat": "total",
"valuefield": "",
"title": "Response code"
}
],
"notice": false
},
{
"title": "UA/Referrer",
"height": "300px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"error": false,
"span": 4,
"editable": true,
"type": "terms",
"loadingEditor": false,
"field": "useragent_os_name.raw",
"exclude": [],
"missing": true,
"other": true,
"size": 10,
"order": "count",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"arrangement": "horizontal",
"chart": "bar",
"counter_pos": "above",
"spyable": true,
"queries": {
"mode": "pinned",
"ids": [
0
]
},
"tmode": "terms",
"tstat": "count",
"valuefield": "",
"title": "UA_OS"
},
{
"error": false,
"span": 4,
"editable": true,
"type": "bettermap",
"loadingEditor": false,
"field": "geoip.coordinates",
"size": 1000,
"spyable": true,
"tooltip": "_id",
"queries": {
"mode": "pinned",
"ids": [
0
]
},
"title": "Map"
},
{
"error": false,
"span": 4,
"editable": true,
"type": "terms",
"loadingEditor": false,
"field": "referrer",
"exclude": [],
"missing": true,
"other": true,
"size": 10,
"order": "count",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"arrangement": "horizontal",
"chart": "bar",
"counter_pos": "above",
"spyable": true,
"queries": {
"mode": "pinned",
"ids": [
0
]
},
"tmode": "terms",
"tstat": "total",
"valuefield": "",
"title": "Referrer"
}
],
"notice": false
},
{
"title": "Table",
"height": "150px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"error": false,
"span": 12,
"editable": true,
"type": "table",
"loadingEditor": false,
"size": 100,
"pages": 5,
"offset": 0,
"sort": [
"response",
"asc"
],
"overflow": "min-height",
"fields": [
"@timestamp",
"agent",
"clientip",
"request",
"verb",
"response",
"referrer",
"useragent_device"
],
"highlight": [],
"sortable": true,
"header": true,
"paging": true,
"field_list": true,
"all_fields": false,
"trimFactor": 300,
"localTime": false,
"timeField": "@timestamp",
"spyable": true,
"queries": {
"mode": "pinned",
"ids": [
0
]
},
"style": {
"font-size": "9pt"
},
"normTimes": true
}
],
"notice": false
}
],
"editable": true,
"failover": false,
"index": {
"interval": "none",
"pattern": "[logstash-]YYYY.MM.DD",
"default": "",
"warm_fields": false
},
"style": "dark",
"panel_hints": true,
"pulldowns": [
{
"type": "query",
"collapse": false,
"notice": false,
"enable": true,
"query": "*",
"pinned": true,
"history": [
"*",
"useragent_device:(NOT \"Spider\")",
"response:(NOT [400 TO 599])",
"useragent_device:\"Spider\"",
"response:[400 TO 599]",
"response:(NOT [400 TO 599]) AND useragent_device:(NOT \"Spider\")",
"response:[400 TO 499]",
"response:(NOT [400 TO 499])",
"*response:(NOT [400 TO 499])",
"useragent_device:[NOT \"Spider\"]"
],
"remember": 10
},
{
"type": "filtering",
"collapse": true,
"notice": false,
"enable": true
}
],
"nav": [
{
"type": "timepicker",
"collapse": false,
"notice": false,
"enable": true,
"status": "Stable",
"time_options": [
"5m",
"15m",
"1h",
"6h",
"12h",
"24h",
"2d",
"7d",
"30d"
],
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
],
"timefield": "@timestamp",
"now": true,
"filter_id": 0
}
],
"loader": {
"save_gist": false,
"save_elasticsearch": true,
"save_local": true,
"save_default": true,
"save_temp": true,
"save_temp_ttl_enable": true,
"save_temp_ttl": "30d",
"load_gist": false,
"load_elasticsearch": true,
"load_elasticsearch_size": 20,
"load_local": false,
"hide": false
},
"refresh": false
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment