Find all indices belonging to box type hot

Is there an easy way to find all indices belonging to box type hot?

I know that I can run GET /_nodes/box_type:hot to get all the nodes, and then maybe run a second step to find which node an index belong to, but I’m trying to see if there’s an endpoint that I can run directly insider Kibana.


From 7.13 we introduced a queryable metadata field which is the _tier field and represents the allocation routing preference(s) assigned to an index. Of course a preference is just that and in reality an index may not be held on its preferred choice of hot/warm etc but in practice you would hope most of the time this choice would be fulfilled.

To get a list of indices which have a stated preference to be on hot nodes you'd need something like this:

GET /*/_search
"query": {
    "terms": {
      "_tier": ["data_hot"] 
      "terms": {
        "field": "_index",
        "size": 100