topic Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query in Dynatrace API

Filter one disk from builtin:host.disk.usedPct with /metrics/query

Yosi_Neuman — Wed, 21 Aug 2024 07:46:47 GMT

Hi guys,

Is there a way to set entitySelector to get information for specific disk from builtin:host.disk.usedPct metric with /metrics/query rest call?

When filtering by host

We get answer with value

When trying to filter by disk

We get empty answer

Is that a bug or a feature or something that I have done wrong ?

Thanks in advance for your input on this question

Yos

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

JamesKitson — Tue, 17 May 2022 18:09:53 GMT

It seems like the issue may be that for some of the older metrics the primary entity must be included in the selector which for this metric is the host and that approach doesn't include that when filtering to the disk in the entity selector.

I did try a few alternatives though where you can include the disk id filter in the query itself to get the same desired result.

Using entity selector still, just in the metric selector as a filter: builtin:host.disk.usedPct:filter(in("dt.entity.disk",entitySelector("entityId("DISK-XXXXXXXX")"))):splitBy("dt.entity.disk") Just filtering on the disk id itself without a selector: builtin:host.disk.usedPct:filter(eq("dt.entity.disk", "DISK-XXXXXXXX")):splitBy("dt.entity.disk")

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

Yosi_Neuman — Tue, 17 May 2022 19:54:39 GMT

Hi @JamesKitson

Thanks for your reply.

This filter works perfectly when using it within Data explorer code.

Our issue is when trying to convert this filter to rest api entitySelector

Any suggestion how to convent this filter to entitySelector?

Yos

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

JamesKitson — Tue, 17 May 2022 19:17:52 GMT

You can add the filters (either the entity selector approach or the somewhat simpler disk dimension filter) in the metricSelector field of the API call. When you add the disk entity selector in that entitySelector field it filters out the host which needs to be present for this metric as that is it's 'primary' dimenions.

So don't use the entitySelector field and just put the whole thing (including the filter) in the metricSelector field:

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

Yosi_Neuman — Tue, 17 May 2022 20:05:54 GMT

Thanks again @JamesKitson

Will use this

All the best

Yos

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

SrikanthSamraj — Thu, 11 Apr 2024 14:13:57 GMT

@Yosi_Neuman - Is it possible to negate a single mount point or list of mount points in metric selector?

Thanks in advance!

Srikanth

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

Yosi_Neuman — Sat, 13 Apr 2024 17:27:43 GMT

Hi @SrikanthSamraj

You can use the Negate criterion with in the entity selector

HTH

Yos

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

sundarv1 — Mon, 05 Aug 2024 04:30:45 GMT

Thanks James

How do add multiple disks or hosts in the above query?

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

SrikanthSamraj — Mon, 05 Aug 2024 13:13:49 GMT

I've used something like below to exclude multiple disks..

builtin:host.disk.usedPct:filter(and(or(in("dt.entity.host",entitySelector("type(host),tag(~"XXX:XXX~"),tag(~"XXX:XXX~"),tag(~"[Environment]XXX:XXX~"),tag(~"[Environment]XXX:XXX~")"))),not(in("dt.entity.disk",entitySelector("type(disk),entityName.in(~"/~",~"/dev~",~"/boot~",~"/boot/efi~",~"/admin~",~"/audit~",~"/home~",~"/home2~",~"/mksysbfs~",~"/opt~",~"/backup/Config~",~"/opt/core~",~"/opt/DoOnceAIX~",~"/opt/samgr/systemlogs~",~"/proc~",~"/sys~",~"/tmp~",~"/users~",~"/usr~",~"/usr/local/lrs~",~"/var~",~"/var/adm/perfmgr~",~"/var/adm/ras/livedump~",~"/var/cache/yum~",~"/var/crash~",~"/var/log~",~"/var/log/audit~",~"/var/perf~",~"/var/perf/pm~",~"/var/spool/lpd/qdir~",~"/var/spool/qdaemon~",~"/rpool~",~"/var/cache/dnf~")")))))

Re: How to filter a one disk from builtin:host.disk.usedPct with /metrics/query

sundarv1 — Mon, 05 Aug 2024 14:05:55 GMT

Thanks

builtin:host.disk.free:filter(and(or(in("dt.entity.disk",entitySelector("type(disk),entityName.equals(~"/obidata~")"))),
or(in("dt.entity.disk",entitySelector("type(disk),entityName.equals(~"/opt~")")))))
:splitBy("dt.entity.host","dt.entity.disk"):avg:sort(value(avg,descending))

What is the issue with above query. when i execute separately it is working and when i combine it is not giving any result.