How to exclude a specific disk on a single host in a custom metric event?

[Vijayt]

Hi 

I have custom metric event with filtering host multiple conditions for disk event .

i want to exclude one disk for one server.  host abc mountpoint /disk1 

builtin:host.disk.usedPct:filter(and(
or(in("dt.entity.host",entitySelector("type(host),osType(~"LINUX~")"))),
or(not(in("dt.entity.host",entitySelector("type(host),tag(~"team:bx_unix~")"))))
)):splitBy("dt.entity.host","dt.entity.disk")

how can i achieve that . one way is to tag disk and exclude disk in filter . 

but how can i separate in metric key  .   i can filter via tag but i can filter only via  host tag not disk ?

[rastislav_danis]

you can try (show all except specific disk "diskname" on host "hostname":

builtin:host.disk.usedPct:filter(or(not(in("dt.entity.disk",entitySelector("type(disk),entityName.equals(~"/diskname~")"))),not(in("dt.entity.host",entitySelector("type(host),entityName.equals(~"hostname~")")))))::splitBy("dt.entity.host","dt.entity.disk")

btw, this is not DQL query, but classic metric query

[Vijayt]

yes i can exclude it by tagging disk and filter via disk tag . but is there any option available in "metric key" type events  with entity filter.  The reason why i am asking is by this classic query my "metric selector " events limits exceeded 

[rastislav_danis]

if you are forced to use metric selector metric event, you can use dimension filter to exclude disk from event definition

[Vijayt]

yeah good idea. but dimention filter does have tag one . it required  exact name/id equal / not equal ones 

[rastislav_danis]

there is a lot of limitations in metric key defined metric events..