# Kibana search for events with missing fields

**URL:** <https://discuss.elastic.co/t/kibana-search-for-events-with-missing-fields/14303>\
**Category:** Elasticsearch\
**Created:** [November 7, 2013, 1:06pm UTC](https://discuss.elastic.co/t/kibana-search-for-events-with-missing-fields/14303 "2013-11-07T13:06:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bruno\_Galindro\_da\_Co](https://avatars.discourse-cdn.com/v4/letter/b/59ef9b/32.png) [@Bruno\_Galindro\_da\_Co](https://discuss.elastic.co/u/Bruno_Galindro_da_Co)\
**Post date:** [November 7, 2013, 1:06pm UTC](https://discuss.elastic.co/t/kibana-search-for-events-with-missing-fields/14303/1 "2013-11-07T13:06:03Z")

</div>

How can I search for events that doesn't have a particular field indexed on  
it?

I need this because I don't setup the null\_value attribute for the fields  
in my logstash template. So, if the event not comming with that field, the  
field it will not added to that document, as explained here:  
[http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-core-types.html](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-core-types.html)

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![byron\_pezan](https://avatars.discourse-cdn.com/v4/letter/b/9fc29f/32.png) [@byron\_pezan](https://discuss.elastic.co/u/byron_pezan)\
**Post date:** [November 8, 2013, 3:19pm UTC](https://discuss.elastic.co/t/kibana-search-for-events-with-missing-fields/14303/2 "2013-11-08T15:19:18Z")

</div>

if i understand your question correctly, i think you can use this syntax.

_missing_:"@fields.fieldname"

HTH,

byron

On Thursday, November 7, 2013 8:06:03 AM UTC-5, Bruno Galindro da Costa  
wrote:

> How can I search for events that doesn't have a particular field indexed  
> on it?
> 
> I need this because I don't setup the null\_value attribute for the fields  
> in my logstash template. So, if the event not comming with that field, the  
> field it will not added to that document, as explained here:  
> [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-core-types.html)

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<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:** [July 6, 2017, 2:08am UTC](https://discuss.elastic.co/t/kibana-search-for-events-with-missing-fields/14303/3 "2017-07-06T02:08:09Z")

</div>


