Description

👋 howdy!

Hopefully this avoids the XPack-vs-commercial issues surfaced in #37499. (XY Problem:) I'd like to streamline investigating assigned shard allocation issues related to ILM. As part of flow after #99612 or Health Report telling you indices are flagged stagnant on migrations.

As part of this, I'd like if CAT Shards would report columns

• the shard's index's index.routing.allocation.include._tier_preference setting used by ILM
• the shard's node's roles in short form

In practice, I usually flag via an aggregated view and then review a table of what'd be the above similar output. For example when cold backs up warm backs up hot:

TIA!