Problem query Graylog’s Elasticsearch with Grafana


(LeDistordu) #1

I have graylog (2.2.3) and i want query its elasticsearch (2.4.4).

I add datasource elasticsearch 2x, i can query but when i query i dont have the same amount of data :

With same query on 5 minutes
From Graylog : 8796 data returned
From Grafana : 57 data returned

Grafana datasource configuration :
Index name : graylog*
Timestamp field name : timestamp
Pattern : no pattern
Version : 2.x

Why do not I get the same results?


(Jochen) #2

What query are you running exactly?
Which indices does Grafana use and which indices does Graylog use for the same query?


(LeDistordu) #3

Graylog :

{
  "from": 0,
  "size": 150,
  "query": {
    "bool": {
      "must": {
        "query_string": {
          "query": "\"myrouter\" AND (\"990-D\" OR \"991-D\" OR \"default-D\")",
          "allow_leading_wildcard": true
        }
      },
      "filter": {
        "bool": {
          "must": {
            "range": {
              "timestamp": {
                "from": "2017-07-20 13:37:51.507",
                "to": "2017-07-20 13:42:51.507",
                "include_lower": true,
                "include_upper": true
              }
            }
          }
        }
      }
    }
  },
  "sort": [
    {
      "timestamp": {
        "order": "desc"
      }
    }
  ],
  "highlight": {
    "require_field_match": false,
    "fields": {
      "*": {
        "fragment_size": 0,
        "number_of_fragments": 0
      }
    }
  }
} 

Grafana :

     {“search_type”:“count”,“ignore_unavailable”:true,“index”:“graylog*”}
    {“size”:0,“query”:{“bool”:{“filter”:[{“range”:{“timestamp”:{“gte”:“1500557461375”,“lte”:“1500557761375”,“format”:“epoch_millis”}}},{“query_string”:{“analyze_wildcard”:true,“query”:"“myrouter” AND (“990-D” OR “991-D” OR “default-D”)"}}]}},“aggs”:{“2”:{“date_histogram”:{“interval”:“2s”,“field”:“timestamp”,“min_doc_count”:0,“extended_bounds”:{“min”:“1500557461375”,“max”:“1500557761375”},“format”:“epoch_millis”},“aggs”:{}}}}

(LeDistordu) #4

Indice on graylog :
graylog2_25
graylog2_24
graylog_docker_1
graylog_vyos_rt01_0
graylog_docker_2
graylog_vyos_rt01_1
graylog2_23
graylog2_22
graylog2_21

Indice for grafana data source : graylog*


(Jochen) #5

Try using the exact same query in Grafana that has been generated by Graylog.

Other than that, I suggest asking the Grafana community since this isn’t exactly an issue with Graylog.


(system) #6

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.