topic Re: Metric Events Conditions in Open Q&A

Metric Events Conditions

Babar_Qayyum — Tue, 16 May 2023 08:55:22 GMT

Dear All,

Is there a way to apply a condition on the metric events to exclude a particular host from the below built-in rule?

builtin:host.cpu.steal:filter(existsKey("dt.entity.host"),not(remainder("dt.entity.host"))):avg

Regards,

Babar

Re: Metric Events Conditions

fcourbon — Tue, 16 May 2023 09:32:57 GMT

Would the query below work?

builtin:host.cpu.steal:filter(ne("dt.entity.host","HOST-3AA8614244B22695"),existsKey("dt.entity.host"),not(remainder("dt.entity.host"))):avg

Re: Metric Events Conditions

Babar_Qayyum — Tue, 16 May 2023 10:03:25 GMT

Hello @fcourbon

Thank you.

The following query should work, but how to use it in the metric events?

builtin:host.cpu.steal:filter(existsKey("dt.entity.host"),ne("dt.entity.host","HOST-E90312219E625BC0"),not(remainder("dt.entity.host"))):avg

Regards,

Babar

Re: Metric Events Conditions

AntonPineiro — Tue, 16 May 2023 10:36:54 GMT

Hi,

I would say using a metric selector event.

Best regards

Re: Metric Events Conditions

Babar_Qayyum — Tue, 16 May 2023 11:06:03 GMT

Hello @AntonPineiro & @fcourbon

Thank you.

Please help me to merge the following two queries to include the osType with the ne (to exclude the host).

builtin:host.cpu.steal:filter(and(or(in("dt.entity.host",entitySelector("type(host),osType(~"LINUX~")"))))):splitBy("dt.entity.host"):avg

builtin:host.cpu.steal:filter(existsKey("dt.entity.host"),ne("dt.entity.host","HOST-E90312219E625BC0"),not(remainder("dt.entity.host"))):avg

Regards,

Babar

Re: Metric Events Conditions

Mohamed_Hamdy — Tue, 16 May 2023 11:34:17 GMT

Hi @Babar_Qayyum ,

I think it will be something like this:

builtin:host.cpu.steal:filter(and(or(in("dt.entity.host",entitySelector("type(host),osType(~"LINUX~")"))),existsKey("dt.entity.host"),ne("dt.entity.host","HOST-E90312219E625BC0"),not(remainder("dt.entity.host")))):splitBy("dt.entity.host"):avg

Re: Metric Events Conditions

Babar_Qayyum — Tue, 16 May 2023 11:48:57 GMT

Hello @Mohamed_Hamdy

Thank you.

Regards,

Babar