grafana_ks

Created Diff never expires
7 removals
154 lines
7 additions
154 lines
{
{
"datasource": "${elasticsearch_datasource}",
"datasource": "${elasticsearch_datasource}",
"fieldConfig": {
"fieldConfig": {
"defaults": {
"defaults": {
"custom": {
"custom": {
"align": null,
"align": null,
"filterable": false
"filterable": false
},
},
"thresholds": {
"thresholds": {
"mode": "absolute",
"mode": "absolute",
"steps": [
"steps": [
{
{
"color": "green",
"color": "green",
"value": null
"value": null
},
},
{
{
"color": "red",
"color": "red",
"value": 80
"value": 80
}
}
]
]
},
},
"mappings": [],
"mappings": [],
"color": {
"color": {
"mode": "thresholds"
"mode": "thresholds"
}
}
},
},
"overrides": [
"overrides": [
{
{
"matcher": {
"matcher": {
"id": "byName",
"id": "byName",
"options": "Total"
"options": "Total"
},
},
"properties": [
"properties": [
{
{
"id": "custom.width",
"id": "custom.width",
"value": 88
"value": 88
}
}
]
]
},
},
{
{
"matcher": {
"matcher": {
"id": "byName",
"id": "byName",
"options": "Field"
"options": "Field"
},
},
"properties": [
"properties": [
{
{
"id": "custom.width",
"id": "custom.width",
"value": 148
"value": 148
}
}
]
]
}
}
]
]
},
},
"gridPos": {
"gridPos": {
"h": 6,
"h": 6,
"w": 4,
"w": 4,
"x": 10,
"x": 17,
"y": 13
"y": 13
},
},
"id": 187,
"id": 241,
"options": {
"options": {
"showHeader": true,
"showHeader": true,
"sortBy": []
"sortBy": []
},
},
"pluginVersion": "7.5.7",
"pluginVersion": "7.5.7",
"targets": [
"targets": [
{
{
"alias": "{{term payload.deviceRequestResponseEvent.commnsType.keyword}} Total",
"alias": "{{term payload.deviceRequestResponseEvent.commnsType.keyword}} Total",
"bucketAggs": [
"bucketAggs": [
{
{
"field": "payload.deviceRequestResponseEvent.commnsType.keyword",
"field": "payload.deviceRequestResponseEvent.commnsType.keyword",
"id": "2",
"id": "2",
"settings": {
"settings": {
"min_doc_count": "1",
"min_doc_count": "1",
"order": "desc",
"order": "desc",
"orderBy": "_term",
"orderBy": "_term",
"size": "10"
"size": "10"
},
},
"type": "terms"
"type": "terms"
},
},
{
{
"field": "eventDatetime",
"field": "eventDatetime",
"id": "3",
"id": "3",
"settings": {
"settings": {
"interval": "${MessageTimeInterval}",
"interval": "${MessageTimeInterval}",
"min_doc_count": "0",
"min_doc_count": "0",
"trimEdges": "0"
"trimEdges": "0"
},
},
"type": "date_histogram"
"type": "date_histogram"
}
}
],
],
"hide": false,
"hide": false,
"metrics": [
"metrics": [
{
{
"id": "1",
"id": "1",
"type": "count"
"type": "count"
}
}
],
],
"query": "eventType:DeviceRequestResponseEvent\nAND (_exists_:payload.cattle.name)\nAND (farmId:e9740d29-b56f-43f4-8102-1508708be6cf OR \nfarmId:9e89605f-f2b5-4375-8f8a-05b043bc35b5 OR \nfarmId:f0470248-3c89-4914-9e58-d3ba49929de8 OR \nfarmId:01a46754-2531-4cb4-bfac-bf79417e9e97 OR \nfarmId:e4c634d3-f56e-410e-a357-5ae5fe9305f8 OR \nfarmId: 2be6f728-c755-4d59-9069-a0f834ae63d0 OR \nfarmId:4ef316f1-4628-4457-9468-1a294d1e7769 OR \nfarmId:1bf35dbc-ce2b-4a2c-b126-7cd531aa84ad OR \nfarmId:067c2d29-40b9-41c9-810e-6ee7fc6c733f OR \nfarmId:2cf7b168-d1d7-4097-ba15-ffb722559b60 OR \nfarmId:aee7f216-ccad-4a6c-9586-b910a4d99a12 OR \nfarmId:27c89d41-e4cf-40a7-8276-5bce52534edd OR \nfarmId:caabcc99-4274-46ea-b563-533fa8b31dc1 OR \nfarmId:cc7e50e8-ae69-48f8-9e4c-61fbf2e46628)\nAND payload.deviceRequestResponseEvent.payloadType:COMMAND_REQUEST_TYPE",
"query": "eventType:DeviceRequestResponseEvent\nAND (_exists_:payload.cattle.name)\n${var_for_all_farms}\nAND payload.deviceRequestResponseEvent.payloadType:COMMAND_REQUEST_TYPE",
"refId": "A",
"refId": "A",
"timeField": "eventDatetime"
"timeField": "eventDatetime"
},
},
{
{
"alias": "{{term payload.deviceRequestResponseEvent.commnsType.keyword}} Failed",
"alias": "{{term payload.deviceRequestResponseEvent.commnsType.keyword}} Failed",
"bucketAggs": [
"bucketAggs": [
{
{
"field": "payload.deviceRequestResponseEvent.commnsType.keyword",
"field": "payload.deviceRequestResponseEvent.commnsType.keyword",
"id": "2",
"id": "2",
"settings": {
"settings": {
"min_doc_count": "1",
"min_doc_count": "1",
"order": "desc",
"order": "desc",
"orderBy": "_term",
"orderBy": "_term",
"size": "10"
"size": "10"
},
},
"type": "terms"
"type": "terms"
},
},
{
{
"field": "eventDatetime",
"field": "eventDatetime",
"id": "3",
"id": "3",
"settings": {
"settings": {
"interval": "${MessageTimeInterval}",
"interval": "${MessageTimeInterval}",
"min_doc_count": "0",
"min_doc_count": "0",
"trimEdges": "0"
"trimEdges": "0"
},
},
"type": "date_histogram"
"type": "date_histogram"
}
}
],
],
"hide": false,
"hide": false,
"metrics": [
"metrics": [
{
{
"id": "1",
"id": "1",
"type": "count"
"type": "count"
}
}
],
],
"query": "eventType:DeviceRequestResponseEvent\nAND (_exists_:payload.cattle.name)\nAND (farmId:e9740d29-b56f-43f4-8102-1508708be6cf OR \nfarmId:9e89605f-f2b5-4375-8f8a-05b043bc35b5 OR \nfarmId:f0470248-3c89-4914-9e58-d3ba49929de8 OR \nfarmId:01a46754-2531-4cb4-bfac-bf79417e9e97 OR \nfarmId:e4c634d3-f56e-410e-a357-5ae5fe9305f8 OR \nfarmId: 2be6f728-c755-4d59-9069-a0f834ae63d0 OR \nfarmId:4ef316f1-4628-4457-9468-1a294d1e7769 OR \nfarmId:1bf35dbc-ce2b-4a2c-b126-7cd531aa84ad OR \nfarmId:067c2d29-40b9-41c9-810e-6ee7fc6c733f OR \nfarmId:2cf7b168-d1d7-4097-ba15-ffb722559b60 OR \nfarmId:aee7f216-ccad-4a6c-9586-b910a4d99a12 OR \nfarmId:27c89d41-e4cf-40a7-8276-5bce52534edd OR \nfarmId:caabcc99-4274-46ea-b563-533fa8b31dc1 OR \nfarmId:cc7e50e8-ae69-48f8-9e4c-61fbf2e46628)\nAND payload.deviceRequestResponseEvent.payloadType:COMMAND_REQUEST_TYPE\nAND NOT payload.deviceRequestResponseEvent.responseCode:SUCCESS",
"query": "eventType:DeviceRequestResponseEvent\nAND (_exists_:payload.cattle.name)\n${var_for_all_farms}\nAND payload.deviceRequestResponseEvent.payloadType:COMMAND_REQUEST_TYPE\nAND NOT payload.deviceRequestResponseEvent.responseCode:SUCCESS",
"refId": "B",
"refId": "B",
"timeField": "eventDatetime"
"timeField": "eventDatetime"
}
}
],
],
"timeFrom": null,
"timeShift": null,
"title": "Panel Title l ",
"title": "Panel Title l ",
"transformations": [
"transformations": [
{
{
"id": "reduce",
"id": "reduce",
"options": {
"options": {
"reducers": [
"reducers": [
"sum"
"sum"
]
]
}
}
}
}
],
],
"type": "table"
"type": "table",
"timeFrom": null,
"timeShift": null
}
}