Combining two entity types in a single Data Explorer query

paulito — Thu, 15 Jun 2023 08:59:44 GMT

I have a single metric but there are two different entity types I'd like to include: hosts and custom devices.

Custom devices:

Hosts:

nagios._Check_CPU_Stats.iowait.percent:filter(and(or(in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blah3~")")),in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blah4~")")),in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blha5~")")),in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blah6~")"))))):splitBy("dt.entity.host"):sort(value(auto,descending)):limit(20)

Both queries are for io waittime and it works well on a graph:

But when I change from graph to single value I have to pick one query or the other.

Is there a way to combine the two in a single query?

Re: Splitting by different entity types in a single data explorer query

Mohamed_Hamdy — Wed, 14 Jun 2023 23:06:31 GMT

Hi @paulito,

to be honest, I'm not sure if the following sample query will work or not, but you can give it a try for the single value and let me know,

nagios._Check_CPU_Stats.iowait.percent:filter(and(or(in("dt.entity.custom_device",entitySelector("type(custom_device),entityName.equals(~"blah1~")")),in("dt.entity.custom_device",entitySelector("type(custom_device),entityName.equals(~"blah2~")")),in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blah3~")")),in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blah4~")")),in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blha5~")")),in("dt.entity.host",entitySelector("type(host),entityName.equals(~"blah6~")"))))):limit(20)

topic Re: Splitting by different entity types in a single data explorer query in Dashboarding

Combining two entity types in a single Data Explorer query

Re: Splitting by different entity types in a single data explorer query