How to filter all data but the index names with jq in kibana: GET _all/_ilm/explain | jq

Elastic Stack Kibana
1

Hello,
How to filter all data, but the index names with jq in kibana: GET _all/_ilm/explain | jq .
Only the indexes with phase : cold.

2

Thanks for reaching out, @mpniel. Would something like this work:

curl -X GET "your.server.url/_all/_ilm/explain" -H 'Content-Type: application/json' | jq '.indices | to_entries[] | select(.value.phase == "cold") | .key'
3

And what is the Kibana syntax?

4

Thanks for following up, @mpniel. According to the feature request on this subject it seems you might be able to use ES|QL.

I did find this related community blog post as well.

5

Do you mean that it is not possible to get my request using jq?

6

Thanks for following up, @mpniel. I'm not aware of a direct way to do this in Kibana's Dev Tools.