# Consulta no elastic

**URL:** <https://discuss.elastic.co/t/consulta-no-elastic/301792>\
**Category:** Elasticsearch\
**Created:** [April 6, 2022, 6:38pm UTC](https://discuss.elastic.co/t/consulta-no-elastic/301792 "2022-04-06T18:38:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabriel\_mec77](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabriel_mec77/32/104065_2.png) [@Gabriel\_mec77](https://discuss.elastic.co/u/Gabriel_mec77)\
**Post date:** [April 6, 2022, 6:38pm UTC](https://discuss.elastic.co/t/consulta-no-elastic/301792/1 "2022-04-06T18:38:20Z")

</div>

Como procurar apenas indices em vermelho no elastic

---

<div class="post-metadata">

**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\
**Post date:** [April 6, 2022, 6:53pm UTC](https://discuss.elastic.co/t/consulta-no-elastic/301792/2 "2022-04-06T18:53:25Z")

</div>

Se o cluster tá como RED você pode usar os requests abaixo pra identificar o motivo.

Pra listar todos os indices e o status dele

```auto
GET _cat/indices?v&s=i

```

Pra listar as shards de cada índice:

```auto
GET _cat/shards?v&s=i

```

Pra ter uma explicação sobre a alocação de shards e identificar porque o status do cluster está como RED.

```auto
GET _cluster/allocation/explain

```

---

<div class="post-metadata">

**Author:** ![Gabriel\_mec77](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabriel_mec77/32/104065_2.png) [@Gabriel\_mec77](https://discuss.elastic.co/u/Gabriel_mec77)\
**Post date:** [April 6, 2022, 7:34pm UTC](https://discuss.elastic.co/t/consulta-no-elastic/301792/3 "2022-04-06T19:34:25Z")

</div>

Não consigo filtrar apenas os arquivos que estão em vermelho.

---

<div class="post-metadata">

**Author:** ![Gabriel\_mec77](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gabriel_mec77/32/104065_2.png) [@Gabriel\_mec77](https://discuss.elastic.co/u/Gabriel_mec77)\
**Post date:** [April 6, 2022, 7:45pm UTC](https://discuss.elastic.co/t/consulta-no-elastic/301792/4 "2022-04-06T19:45:09Z")

</div>

Boa Tarde,  
mas como faço para poder filtrar apenas os indices em vermelho?assim como ta no print, ta puxando todos.

 ![Capturar.PNG](https://us1.discourse-cdn.com/elastic/original/3X/c/c/cc7b2746e910ea67e52ba7a3c99c9e9b60851bac.png)

---

<div class="post-metadata">

**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\
**Post date:** [April 6, 2022, 8:43pm UTC](https://discuss.elastic.co/t/consulta-no-elastic/301792/5 "2022-04-06T20:43:50Z")

</div>

O request tá errado.

É só usar: `GET _cat/indices?v&s=i&health=red`

---

<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:** [May 4, 2022, 8:44pm UTC](https://discuss.elastic.co/t/consulta-no-elastic/301792/6 "2022-05-04T20:44:36Z")

</div>

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