Skip to content

Instantly share code, notes, and snippets.

@Chaffelson

Chaffelson/piwinifisolrdashboard

Created June 30, 2016 17:53
Show Gist options
  • Save Chaffelson/3d7e1b3bf77ae66accc8e173de848aa3 to your computer and use it in GitHub Desktop.
Save Chaffelson/3d7e1b3bf77ae66accc8e173de848aa3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
piwinifisolrdashboard
{
"title": "Sensor Dashboard",
"services": {
"query": {
"idQueue": [
1,
2,
3,
4
],
"list": {
"0": {
"query": "*",
"alias": "",
"color": "#7EB26D",
"id": 0,
"pin": false,
"type": "lucene"
}
},
"ids": [
0
]
},
"filter": {
"idQueue": [
1,
2
],
"list": {
"0": {
"from": "NOW/MINUTE-15MINUTE",
"to": "NOW/MINUTE%2B1MINUTE",
"field": "ts_lastlog",
"type": "time",
"fromDateObj": "2016-06-30T17:36:32.838Z",
"toDateObj": "2016-06-30T17:51:32.839Z",
"mandate": "must",
"active": true,
"alias": "",
"id": 0
}
},
"ids": [
0
]
}
},
"rows": [
{
"title": "Query and Time Window",
"height": "50px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"error": false,
"span": 4,
"editable": true,
"type": "filtering",
"loadingEditor": false,
"spyable": true,
"title": "Filters"
},
{
"error": false,
"span": 4,
"editable": true,
"type": "column",
"loadingEditor": false,
"panels": [
{
"loading": false,
"error": "",
"sizeable": false,
"span": 12,
"height": "50px",
"editable": true,
"type": "timepicker",
"draggable": false,
"mode": "relative",
"timefield": "ts_lastlog",
"time_options": [
"5m",
"15m",
"1h",
"6h",
"24h",
"2d"
],
"timespan": "15m",
"refresh": {
"enable": true,
"interval": 10,
"min": 3
},
"status": "Stable",
"timeformat": "",
"spyable": true,
"filter_id": 0
},
{
"loading": false,
"error": false,
"sizeable": false,
"span": 12,
"height": "50px",
"editable": true,
"type": "query",
"draggable": false,
"query": "*:*",
"pinned": true,
"history": [
"*"
],
"spyable": true,
"remember": 10
}
],
"title": "Query"
},
{
"span": 4,
"editable": true,
"type": "hits",
"loadingEditor": false,
"queries": {
"mode": "all",
"ids": [
0
],
"query": "q=*&fq=ts_lastlog:[NOW/MINUTE-15MINUTE%20TO%20NOW/MINUTE%2B1MINUTE]&wt=json&rows=0\n",
"basic_query": "",
"custom": ""
},
"style": {
"font-size": "42pt"
},
"arrangement": "horizontal",
"chart": "total",
"counter_pos": "above",
"donut": false,
"tilt": false,
"labels": true,
"spyable": true,
"show_queries": true,
"title": "Records"
}
]
},
{
"title": "Counts",
"height": "250px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"span": 6,
"editable": true,
"type": "histogram",
"loadingEditor": false,
"mode": "count",
"queries": {
"mode": "all",
"ids": [
0
],
"query": "q=*&wt=json&rows=0&fq=ts_lastlog:[NOW/MINUTE-15MINUTE%20TO%20NOW/MINUTE%2B1MINUTE]&facet=true&facet.range=ts_lastlog&facet.range.start=NOW/MINUTE-15MINUTE&facet.range.end=NOW/MINUTE%2B1MINUTE&facet.range.gap=%2B10SECOND\n",
"custom": ""
},
"max_rows": 100000,
"value_field": null,
"group_field": null,
"auto_int": true,
"resolution": 100,
"interval": "10s",
"intervals": [
"auto",
"1s",
"1m",
"5m",
"10m",
"30m",
"1h",
"3h",
"12h",
"1d",
"1w",
"1M",
"1y"
],
"fill": 0,
"linewidth": 3,
"timezone": "browser",
"spyable": true,
"zoomlinks": true,
"bars": true,
"stack": true,
"points": false,
"lines": false,
"lines_smooth": false,
"legend": true,
"x-axis": true,
"y-axis": true,
"percentage": false,
"interactive": true,
"options": true,
"show_queries": true,
"tooltip": {
"value_type": "cumulative",
"query_as_alias": false
},
"title": "Event Count",
"error": "no servers hosting shard: "
},
{
"span": 4,
"editable": true,
"type": "terms",
"loadingEditor": false,
"queries": {
"mode": "all",
"ids": [
0
],
"query": "q=*&wt=json&rows=0&fq=ts_lastlog:[NOW/MINUTE-15MINUTE%20TO%20NOW/MINUTE%2B1MINUTE]&facet=true&facet.field=sensor&facet.limit=15&facet.missing=true",
"custom": ""
},
"mode": "count",
"field": "sensor",
"stats_field": "",
"decimal_points": 0,
"exclude": [],
"missing": false,
"other": false,
"size": 15,
"order": "descending",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"logAxis": false,
"arrangement": "horizontal",
"chart": "bar",
"counter_pos": "above",
"lastColor": "",
"spyable": true,
"show_queries": true,
"chartColors": [
"#7EB26D",
"#EAB839",
"#6ED0E0",
"#EF843C",
"#E24D42",
"#1F78C1",
"#BA43A9",
"#705DA0",
"#508642",
"#CCA300",
"#447EBC",
"#C15C17",
"#890F02",
"#0A437C",
"#6D1F62",
"#584477",
"#B7DBAB",
"#F4D598",
"#70DBED",
"#F9BA8F",
"#F29191",
"#82B5D8",
"#E5A8E2",
"#AEA2E0",
"#629E51",
"#E5AC0E",
"#64B0C8",
"#E0752D",
"#BF1B00",
"#0A50A1",
"#962D82",
"#614D93",
"#9AC48A",
"#F2C96D",
"#65C5DB",
"#F9934E",
"#EA6460",
"#5195CE",
"#D683CE",
"#806EB7",
"#3F6833",
"#967302",
"#2F575E",
"#99440A",
"#58140C",
"#052B51",
"#511749",
"#3F2B5B",
"#E0F9D7",
"#FCEACA",
"#CFFAFF",
"#F9E2D2",
"#FCE2DE",
"#BADFF4",
"#F9D9F9",
"#DEDAF7"
],
"title": "By Pi",
"error": "no servers hosting shard: "
},
{
"span": 2,
"editable": true,
"type": "terms",
"loadingEditor": false,
"queries": {
"mode": "all",
"ids": [
0
],
"query": "q=*&wt=json&rows=0&fq=ts_lastlog:[NOW/MINUTE-15MINUTE%20TO%20NOW/MINUTE%2B1MINUTE]&facet=true&facet.field=service&facet.limit=10&facet.missing=true",
"custom": ""
},
"mode": "count",
"field": "service",
"stats_field": "",
"decimal_points": 0,
"exclude": [],
"missing": false,
"other": false,
"size": 10,
"order": "descending",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"logAxis": false,
"arrangement": "horizontal",
"chart": "bar",
"counter_pos": "above",
"lastColor": "",
"spyable": true,
"show_queries": true,
"chartColors": [
"#7EB26D",
"#EAB839",
"#6ED0E0",
"#EF843C",
"#E24D42",
"#1F78C1",
"#BA43A9",
"#705DA0",
"#508642",
"#CCA300",
"#447EBC",
"#C15C17",
"#890F02",
"#0A437C",
"#6D1F62",
"#584477",
"#B7DBAB",
"#F4D598",
"#70DBED",
"#F9BA8F",
"#F29191",
"#82B5D8",
"#E5A8E2",
"#AEA2E0",
"#629E51",
"#E5AC0E",
"#64B0C8",
"#E0752D",
"#BF1B00",
"#0A50A1",
"#962D82",
"#614D93",
"#9AC48A",
"#F2C96D",
"#65C5DB",
"#F9934E",
"#EA6460",
"#5195CE",
"#D683CE",
"#806EB7",
"#3F6833",
"#967302",
"#2F575E",
"#99440A",
"#58140C",
"#052B51",
"#511749",
"#3F2B5B",
"#E0F9D7",
"#FCEACA",
"#CFFAFF",
"#F9E2D2",
"#FCE2DE",
"#BADFF4",
"#F9D9F9",
"#DEDAF7"
],
"error": "no servers hosting shard: "
}
]
},
{
"title": "Details",
"height": "250px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"span": 12,
"editable": true,
"type": "terms",
"loadingEditor": false,
"queries": {
"mode": "all",
"ids": [
0
],
"query": "q=*&wt=json&rows=0&fq=ts_lastlog:[NOW/MINUTE-15MINUTE%20TO%20NOW/MINUTE%2B1MINUTE]&fq=-manufacturer:NotRecognised&facet=true&facet.field=manufacturer&facet.limit=30&facet.missing=true",
"custom": "&fq=service:CLIENT"
},
"mode": "count",
"field": "manufacturer",
"stats_field": "",
"decimal_points": 0,
"exclude": [
"NotRecognised"
],
"missing": false,
"other": false,
"size": 30,
"order": "descending",
"style": {
"font-size": "10pt"
},
"donut": false,
"tilt": false,
"labels": true,
"logAxis": false,
"arrangement": "horizontal",
"chart": "bar",
"counter_pos": "above",
"lastColor": "",
"spyable": true,
"show_queries": true,
"chartColors": [
"#7EB26D",
"#EAB839",
"#6ED0E0",
"#EF843C",
"#E24D42",
"#1F78C1",
"#BA43A9",
"#705DA0",
"#508642",
"#CCA300",
"#447EBC",
"#C15C17",
"#890F02",
"#0A437C",
"#6D1F62",
"#584477",
"#B7DBAB",
"#F4D598",
"#70DBED",
"#F9BA8F",
"#F29191",
"#82B5D8",
"#E5A8E2",
"#AEA2E0",
"#629E51",
"#E5AC0E",
"#64B0C8",
"#E0752D",
"#BF1B00",
"#0A50A1",
"#962D82",
"#614D93",
"#9AC48A",
"#F2C96D",
"#65C5DB",
"#F9934E",
"#EA6460",
"#5195CE",
"#D683CE",
"#806EB7",
"#3F6833",
"#967302",
"#2F575E",
"#99440A",
"#58140C",
"#052B51",
"#511749",
"#3F2B5B",
"#E0F9D7",
"#FCEACA",
"#CFFAFF",
"#F9E2D2",
"#FCE2DE",
"#BADFF4",
"#F9D9F9",
"#DEDAF7"
],
"title": "Top Client Manufacturers",
"error": "no servers hosting shard: "
}
]
},
{
"title": "Events",
"height": "500px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"span": 12,
"editable": true,
"type": "table",
"loadingEditor": false,
"status": "Stable",
"queries": {
"mode": "all",
"ids": [
0
],
"query": "q=*&fq=ts_lastlog:[NOW/MINUTE-15MINUTE%20TO%20NOW/MINUTE%2B1MINUTE]&sort=ts_lastseen desc&wt=json&rows=75",
"basic_query": "q=*&fq=ts_lastlog:[NOW/MINUTE-15MINUTE%20TO%20NOW/MINUTE%2B1MINUTE]&sort=ts_lastseen desc",
"custom": ""
},
"size": 15,
"pages": 5,
"offset": 45,
"sort": [
"ts_lastseen",
"desc"
],
"group": "default",
"style": {
"font-size": "9pt"
},
"overflow": "min-height",
"fields": [
"mac",
"manufacturer",
"sensor",
"signalDbm",
"type",
"ts_firstseen",
"ts_lastlog",
"ts_lastseen",
"session",
"ssid",
"service"
],
"important_fields": [
"Session",
"_text_",
"_version_",
"add.boost",
"channel",
"humidity",
"id",
"mac",
"manufacturer",
"message",
"pressure",
"sensor",
"session",
"signalDbm",
"ssid",
"temp",
"title",
"ts_firstseen",
"ts_lastlog",
"ts_lastseen",
"type"
],
"highlight": [],
"sortable": true,
"header": true,
"paging": true,
"field_list": true,
"trimFactor": 300,
"normTimes": true,
"spyable": true,
"saveOption": "json",
"exportSize": 75,
"exportAll": true,
"displayLinkIcon": true,
"imageFields": [],
"imgFieldWidth": "auto",
"imgFieldHeight": "85px",
"show_queries": true,
"title": "Details",
"error": "no servers hosting shard: "
}
]
}
],
"editable": true,
"index": {
"interval": "none",
"pattern": "[logstash-]YYYY.MM.DD",
"default": "_all"
},
"style": "dark",
"failover": false,
"panel_hints": true,
"loader": {
"save_gist": true,
"save_elasticsearch": true,
"save_local": true,
"save_default": true,
"save_temp": true,
"save_temp_ttl_enable": true,
"save_temp_ttl": "30d",
"load_gist": true,
"load_elasticsearch": true,
"load_elasticsearch_size": 20,
"load_local": true,
"hide": false,
"dropdown_collections": false
},
"solr": {
"server": "/solr/",
"core_name": "devices_shard1_replica1",
"core_list": [
"devices_shard1_replica1",
"statuses_shard1_replica2",
"statuses_shard2_replica2",
"users_shard1_replica3",
"users_shard2_replica3"
],
"global_params": ""
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment