topic Re: Wild Card or REGEX in data explorer / custom event alerting profile in Alerting

Wild Card or REGEX in data explorer / custom event alerting profile

pvr — Tue, 04 Oct 2022 11:21:57 GMT

Hello,

Does the DT GUI allow us to filter on regular expressions or wild cards for the data explorer and custom alerting profiles?

I have a use case of collecting ready message count in a number of queues all with names ending in "*_error" , when I try to put in a similar wildcard it fails to filter on it.

Help/Advice appreciated.

thanks

Ven

Re: Wild Card or REGEX in data explorer / custom event alerting profile

ChadTurner — Tue, 10 Jan 2023 21:08:59 GMT

regex is really only applicable in certain subsets of Dynatrace for example Auto Tags, Request Attributes, Management Zones etc....

Re: Wild Card or REGEX in data explorer / custom event alerting profile

paolo_fumanelli — Tue, 24 Jan 2023 11:07:31 GMT

Not sure I got the precise use case, but did you try entityName("_error") that works as "contains" clause? Unfortunately there is startsWith but not endsWith.

Re: Wild Card or REGEX in data explorer / custom event alerting profile

AgataWlodarczyk — Thu, 11 May 2023 13:36:03 GMT

@pvr do you still need help with your case?
Or have you already found a solution? If yes, feel free to share. Other Community members would be happy to know the answer. 🙂

Re: Wild Card or REGEX in data explorer / custom event alerting profile

Adil_Saleem — Tue, 23 May 2023 17:29:58 GMT

Hi All,
I was stuck in the same issue. I wanted to filter out all the results that were ending with some xyz string. In code tab of data explorer, there was a option called 'prefix' in filter. As I want to detect xyz suffix, I just used suffix in filter and it worked for me.

Long story short, you can use suffix key word like this:
filter(suffix("Dimension","<your sub string that you want to search>"))
and it will filter out all the data that has your desired sub string at the end.

🙂

Let me know if this works for you as well.

Re: Wild Card or REGEX in data explorer / custom event alerting profile

pvr — Fri, 16 Jun 2023 14:55:09 GMT

@Adil_Saleem : I have tried the below it does not work, could you confirm this is similar to the code you had success with ?

com.dynatrace.extension.prometheus-rabbitmq.queues.queue_messages_ready:filter(suffix("Dimension","_error")):splitBy(queue):max:sort(value(max,descending)):limit(20)

Re: Wild Card or REGEX in data explorer / custom event alerting profile

Adil_Saleem — Mon, 19 Jun 2023 09:52:30 GMT

@pvr ,
Can you show me some sample data on which you want to apply filter. As per my understanding, you should try applying filter after splitBy() function.
If there are dimensions that end with _error then this should work.

com.dynatrace.extension.prometheus-rabbitmq.queues.queue_messages_ready:splitBy(queue):filter(suffix("Dimension","_error")):max:sort(value(max,descending)):limit(20)

Let me know in case if it still does not work for you.