topic Excluding certain entities from data explorer query in Dashboarding

Excluding certain entities from data explorer query

paulito — Thu, 27 Jun 2024 21:29:16 GMT

First off we're using a custom extension so hopefully that doesn't put us in too much of a bind but here is our query:

nagios._Check_CPU_Load.load1:filter(and(or(in("dt.entity.custom_device",entitySelector("type(custom_device),fromRelationship.isInstanceOf(type(CUSTOM_DEVICE_GROUP),entityName.equals(~"Blahblahblah~"))"))))):splitBy("dt.entity.custom_device"):sort(value(auto,descending))

This gives us a list of devices. We'd like to exclude 3 devices from this query. These 3 devices have a common word in their name: "test".

Is there something we can add to our existing query so that those 3 devices are excluded?

Re: Excluding certain entities from data explorer query

stemos — Thu, 18 Jul 2024 11:00:27 GMT

The following embedded entity selector can be used:

"type(custom_device),not(entityName.contains(~"test~")),fromRelationship.isInstanceOf(type(CUSTOM_DEVICE_GROUP),entityName.equals(~"Blahblahblah~"))"

Re: Excluding certain entities from data explorer query

paulito — Wed, 31 Jul 2024 17:18:54 GMT

Thank you so much, this works. Would there be a way to exclude multiple entities that have unique names?

Re: Excluding certain entities from data explorer query

stemos — Tue, 20 Aug 2024 07:42:16 GMT

Yes, you can exclude unique names by:

"type(custom_device),not(entityName.in(~"full_device_name1~",~"full_device_name2~",~"full_device_name3~"))"

If you want to exclude multiple devices based on the contains filter, you can achieve this like shown in this example:

"type(custom_device),not(entityName.contains(~"abc~")),not(entityName.contains(~"cbd~")),not(entityName.contains(~"bde~"))"