How to create a search to find out unused indexes?

[kteng2024]

I am looking for indexes which are utilizing only 10%-20% of storage allocated to them. Can i please know is there any query to find out that.I know that we can look into DMC but i specifically need only the indexes that uses only 10%-20% of storage for last 30 days.

[somesoni2]

How are you planning to decide on what the total storage allocated for an index? An index can go to maximum size as defined in maxTotalDataSizeMB = * The maximum size of an index (in MB) OR based on retention period as defined in frozenTimePeriodInSecs= * Number of seconds after which indexed data rolls to frozen.

[Dey1]

Can you help with a query to find out which indexs are not used 

[adonio]

try this

    | rest /services/data/indexes-extended
    | table title currentDBSizeMB maxTotalDataSizeMB
    | eval percent_full = round(currentDBSizeMB/maxTotalDataSizeMB*100, 2)
     rename COMMENT as "now you can add your where or search clause"
    | where percent_full =<20

hope it helps