# How to query multiple hosts using in elasticsearch using wildcard

**URL:** https://discuss.elastic.co/t/how-to-query-multiple-hosts-using-in-elasticsearch-using-wildcard/303913
**Category:** Elasticsearch
**Created:** [May 4, 2022, 8:23am UTC](https://discuss.elastic.co/t/how-to-query-multiple-hosts-using-in-elasticsearch-using-wildcard/303913 "2022-05-04T08:23:25Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Gojo](https://avatars.discourse-cdn.com/v4/letter/g/2acd7d/32.png) [@Gojo](https://discuss.elastic.co/u/Gojo)
#### Post date: [May 4, 2022, 8:23am UTC](https://discuss.elastic.co/t/how-to-query-multiple-hosts-using-in-elasticsearch-using-wildcard/303913/1 "2022-05-04T08:23:25Z")

</div>

hey all iam new to elk , iam trying to get all the hosts in the Elasticsearch db , i tried using a wildcard and

"wild\_card": "hosts",  
"query": {  
"host.keyword": "test\*",  
"severity.keyword": "err"  
},

consider there are multiple hosts like test1,test2,test3 i want to all them to be listed in a query , can someone help me with this

---

<div class="post-metadata">

### Author: ![ibra\_013](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ibra_013/32/104827_2.png) [@ibra\_013](https://discuss.elastic.co/u/ibra_013)
#### Post date: [May 5, 2022, 12:43pm UTC](https://discuss.elastic.co/t/how-to-query-multiple-hosts-using-in-elasticsearch-using-wildcard/303913/2 "2022-05-05T12:43:42Z")

</div>

Hi,

Kindly to check this [doc](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-wildcard-query.html),

i tried with my data,

```auto
GET index-name/_search
{
  "query": {
    "wildcard": {
      "host.hostname": {
        "value": "hostname-*",
        "boost": 1.0,
        "rewrite": "constant_score"
      }
    }
  }
}

```

---

<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: [June 2, 2022, 12:44pm UTC](https://discuss.elastic.co/t/how-to-query-multiple-hosts-using-in-elasticsearch-using-wildcard/303913/3 "2022-06-02T12:44:33Z")

</div>

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