Index pattern for Grafana

Roshan_r · January 4, 2019, 9:26am

Hello
I am not sure whether i can ask this here. Just trying my luck here.
I am integrating Grafana with ElasticSearch. In the Grafana screen, i need to give the ElasticSearch details.
What is the value for Index?

This is what is in my logstash config

 if "_grokparsefailure" in [tags] {
 elasticsearch {
   hosts => "84.210.206.233:9200"
   #protocol => "http"
   #port => 9200
   #cluster => "elk_cluster"
   index => "cmdc2-error-%{cmdcLogId}"
   document_type => "error_logs"
   codec => "json"
 }
} else {
 elasticsearch {
   hosts => "84.210.206.233:9200"
   #protocol => "http"
   #port => 9200
   #cluster => "elk_cluster"
   index => "cmdc2-log-%{+YYYY.MM.dd}"
   document_type => "%{target}_logs"
   codec => "json"
 }
}
}

Should i give the value cmdc2-log-%{+YYYY.MM.dd} as index in Grafana page?

A_B · January 4, 2019, 9:48am

Hi @Roshan_r,

do you use Kibana at all? You can use the same index pattern in Grafana.

For you cmdc2-* should work if you want to be able to query all ES indices from the same Grafana query.

Roshan_r · January 4, 2019, 9:55am

Yes. I use Kibana.

Please find attached the indices used in Kibana

Roshan_r · January 4, 2019, 9:59am

Ok. I can see the error gone after using cmdc2-* . When i enter @timestamp in Time Field name.. i got an error saying "No date field named @timestamp found) . Any idea where i can get the correct field name?