# I don't know why there are no hits

**URL:** <https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832>\
**Category:** Elasticsearch\
**Created:** [November 8, 2018, 7:42am UTC](https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832 "2018-11-08T07:42:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ksb304](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@ksb304](https://discuss.elastic.co/u/ksb304)\
**Post date:** [November 8, 2018, 7:42am UTC](https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832/1 "2018-11-08T07:42:50Z")

</div>

**no hits**

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/1/811871c7c5b935ddf7d5abf3c4579d702e8a444f.png)

**hits**

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/0/000fdf19c770094023aaee89f10fa36f5e1daf6c.png)

**management index pattern :**

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/1/c1626aa1b17c1c044935ef242b3a8207c3315a03.png)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 8, 2018, 8:20am UTC](https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832/2 "2018-11-08T08:20:46Z")

</div>

What is the mapping?

---

<div class="post-metadata">

**Author:** ![ksb304](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@ksb304](https://discuss.elastic.co/u/ksb304)\
**Post date:** [November 8, 2018, 8:22am UTC](https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832/3 "2018-11-08T08:22:59Z")

</div>

this is 'put template' query

PUT \_template/installstatus  
{  
"index\_patterns": "installstatus-\*",  
"settings": {  
"number\_of\_replicas": 1,  
"number\_of\_shards":3  
},  
"mappings": {  
"installstatus": {  
"properties": {  
"DomainID": {  
"type": "long"  
},  
"UserID": {  
"type": "keyword"  
},  
"DeviceID": {  
"type": "keyword"  
},  
"RegDate": {  
"type": "date",  
"format": "yyyyMMddHHmmss"  
},  
"UpdateDate": {  
"type": "date",  
"format": "yyyyMMddHHmmss"  
},  
"InputDate": {  
"type": "date",  
"format": "yyyyMMddHHmmss"  
},  
"Status": {  
"type": "keyword"  
},  
"ComputerName": {  
"type": "text"  
},  
"OSCode": {  
"type": "keyword"  
},  
"OSName": {  
"type": "keyword"  
},  
"ServicePackVersion": {  
"type": "keyword"  
},  
"IP": {  
"type":"keyword"  
},  
"ClientVersion": {  
"type":"keyword"  
},  
"FsdVersion": {  
"type":"keyword"  
},  
"FsfdVersion": {  
"type":"keyword"  
},  
"RemoteIP": {  
"type":"keyword"  
}  
}  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [November 8, 2018, 8:23am UTC](https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832/4 "2018-11-08T08:23:27Z")

</div>

As all timestamps in Elasticsearch are assumed (and must be) in UTC timezone, that date seems to be in the future, which is probably why it does not show up when searching the last 90 days.

---

<div class="post-metadata">

**Author:** ![ksb304](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@ksb304](https://discuss.elastic.co/u/ksb304)\
**Post date:** [November 8, 2018, 8:25am UTC](https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832/5 "2018-11-08T08:25:16Z")

</div>

Aha, thank you so much!!!

---

<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:** [December 6, 2018, 8:25am UTC](https://discuss.elastic.co/t/i-dont-know-why-there-are-no-hits/155832/6 "2018-12-06T08:25:33Z")

</div>

Closed on December 6, 2018, 8:25am UTC

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