topic Re: Filter all disks with greater than 90 Disk used % in Dashboarding

Filter all disks with greater than 90 Disk used %

dineshraj — Tue, 23 May 2023 05:13:38 GMT

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ő — Tue, 23 May 2023 06:49:46 GMT

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ő

dineshraj — Tue, 23 May 2023 15:19:05 GMT

Works like a charm!! Thanks @Mizső

sundarv1 — Mon, 05 Aug 2024 04:33:05 GMT

Hi Mizso

How do we modify query for add multiple hosts?.