# Index pattern for Grafana

**URL:** https://discuss.elastic.co/t/index-pattern-for-grafana/162919
**Category:** Elasticsearch
**Created:** [January 4, 2019, 9:26am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919 "2019-01-04T09:26:47Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Roshan\_r](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roshan_r/32/9760_2.png) [@Roshan\_r](https://discuss.elastic.co/u/Roshan_r)
#### Post date: [January 4, 2019, 9:26am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/1 "2019-01-04T09:26:47Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![A\_B](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_b/32/17104_2.png) [@A\_B](https://discuss.elastic.co/u/A_B)
#### Post date: [January 4, 2019, 9:48am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/2 "2019-01-04T09:48:02Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Roshan\_r](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roshan_r/32/9760_2.png) [@Roshan\_r](https://discuss.elastic.co/u/Roshan_r)
#### Post date: [January 4, 2019, 9:55am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/3 "2019-01-04T09:55:27Z")

</div>

Yes. I use Kibana.

Please find attached the indices used in Kibana ![27](https://us1.discourse-cdn.com/elastic/original/3X/7/8/783ccfed95890b9d59bd8cc2c049b85e62e188a3.png)

---

<div class="post-metadata">

### Author: ![Roshan\_r](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roshan_r/32/9760_2.png) [@Roshan\_r](https://discuss.elastic.co/u/Roshan_r)
#### Post date: [January 4, 2019, 9:59am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/4 "2019-01-04T09:59:24Z")

</div>

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? ![07](https://us1.discourse-cdn.com/elastic/original/3X/0/f/0f3fa178383e2654062b04ee3c927d1335d99b95.png)

---

<div class="post-metadata">

### Author: ![A\_B](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_b/32/17104_2.png) [@A\_B](https://discuss.elastic.co/u/A_B)
#### Post date: [January 4, 2019, 10:03am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/5 "2019-01-04T10:03:09Z")

</div>

> [@Roshan\_r](#):
>
> Any idea where i can get the correct field name?

Which field does Kibana use for `cmdc2-log-*`? Use the same in Grafana.

---

<div class="post-metadata">

### Author: ![A\_B](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_b/32/17104_2.png) [@A\_B](https://discuss.elastic.co/u/A_B)
#### Post date: [January 4, 2019, 10:05am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/6 "2019-01-04T10:05:04Z")

</div>

This is what I have in Grafana

![image](https://us1.discourse-cdn.com/elastic/original/3X/6/d/6d830f24e54a275b9feee40660016a748940c0c5.png)

So, maybe set `Pattern` to _No pattern_ as well.

---

<div class="post-metadata">

### Author: ![Roshan\_r](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roshan_r/32/9760_2.png) [@Roshan\_r](https://discuss.elastic.co/u/Roshan_r)
#### Post date: [January 4, 2019, 10:07am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/7 "2019-01-04T10:07:53Z")

</div>

Please see the attached from Kibana. I have @timestamp .

Please find attached grafana page also.

 ![28](https://us1.discourse-cdn.com/elastic/original/3X/d/b/db7df38f63461779bf2d425393cbc7d5b969b2fb.png) ![34](https://us1.discourse-cdn.com/elastic/original/3X/d/5/d5a63503f48b1be9bfa546a71b130571345729ab.png)

---

<div class="post-metadata">

### Author: ![Roshan\_r](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/roshan_r/32/9760_2.png) [@Roshan\_r](https://discuss.elastic.co/u/Roshan_r)
#### Post date: [January 4, 2019, 10:16am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/8 "2019-01-04T10:16:18Z")

</div>

I have fixed it. I deleted the field and manually gave @timestamp and it worked.

Many many thanks for your help

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 1, 2019, 10:16am UTC](https://discuss.elastic.co/t/index-pattern-for-grafana/162919/9 "2019-02-01T10:16:23Z")

</div>

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