23 May 2023 06:13 AM
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
Solved! Go to Solution.
23 May 2023 07:49 AM
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ő
05 Aug 2024 05:33 AM
Hi Mizso
How do we modify query for add multiple hosts?.
23 May 2023 04:19 PM
Works like a charm!! Thanks @Mizső