Filter all disks with greater than 90 Disk used %

[dineshraj]

Hello All,

Is there a way to filter all Disks with Disk Used % > 90 from Data Explorer?

I tried the below, but it throws an error that referenced key doesn't exist.

builtin:host.disk.usedPct:filter(eq("builtin:host.disk.usedPct",90)):splitBy():sort(value(auto,descending)):limit(20)

Thanks

[Mizső · Accepted solution]

Hi @dineshraj 

Try this one:

builtin:host.disk.usedPct

:filter(series(avg,gt,90))

:splitBy("dt.entity.host","dt.entity.disk")

:avg

:sort(value(avg,descending))

I hope it helps.

Best regards,

Mizső

[sundarv1]

Hi Mizso

How do we modify query for add multiple hosts?.

[dineshraj]

Works like a charm!! Thanks @Mizső