Dashboard Wildcard Filtering

[Larry_S]

Hello-

In the Dynatrace dashboard Data explorer is there a way to add wildcard exception filtering?  Example, filter to show me all of something except for the somethings with "TEST" in their names.

Thank you, in advance.

-Larry

[Malaik]

HI @Larry_S 

Not possible,

But by creating a calculated metric on that exception, you can build it.

You can add this condition in the conditions of the calculated metric.

[Kenny_Gillette]

Another option is do create a tag that does not have "test" in it and use that tag in data explorer.

[techean]

similar issue solved Solved: Re: How to create alert based on paticular exception ? - Dynatrace Community

Create calculated metrics | Dynatrace Docs

[Larry_S]

I'm not sure that solution applies, but thanks.  We use Active Gate monitoring and I do not even see Settings -> Server side monitoring -> Calculated service metrics.  I'm thinking this is an Admin function, of which I am not.

[zietho]

Hey, 

have you tried code mode and the combination of the following transformations: 

* prefix (= starts with - e.g. prefix("My server") for My server 1, My server 2, My server 3.... 

* not (only available using the entity selector in the metric expression) or ne (not equals for exact matches)

more info on it here: https://www.dynatrace.com/support/help/shortlink/api-metrics-v2-selector#conditions 

example: 

builtin:apps.web.actionCount.category:filter(and(in("dt.entity.application",entitySelector("type(application),not(entityName(~"HipsterShopLogs~"))"))))

regards

[Larry_S]

I read the documentation and I cannot figure out how to code the filter for the code:

ext:tech.IBMMQ_Java.Queue.Depth:filter(and(in("dt.entity.custom_device",entitySelector("type(custom_device),entityName.equals(~"IBM MQ - Non-Prod-QMGR - PADB2QA~")")),eq(Queue,"PSL.ASN.FROMMMP.Q"))):splitBy(Queue):max:auto:sort(value(max,descending)):limit(100)

I selected (in "Build") to select a specific "Queue" of "PSL.ASN.FROMMMP.Q".  That would be okay if my device only had that one "Queue", but, in this case, there are many and all of them start with "PSL". My goal is to select all "Queues" that begin with "PSL"

[Larry_S · Accepted solution]

I figured it out!

ext:tech.IBMMQ_Java.Queue.Depth:filter(and(prefix(Queue,"PSL."),in("dt.entity.custom_device",entitySelector("type(custom_device),entityName.equals(~"IBM MQ - Non-Prod-QMGR - BTRNAQA~")")))):splitBy(Queue):max:auto:sort(value(max,descending)):limit(100)