cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

regex to capture sql stored procedure name

samuel_rudolph
Newcomer

I am new at reqex and need some help. I can get expressions to work in regex testing sites but the same ones do not work in Appmon.

I want to capture the SQL stored procedure name as show below and use for a business transaction to monitor response times and counts.


Execute dbo.DDD04286 '99999999','999999999','9999999',9999


I want to capture the part in bold text. There could be many different names but all start with DDD.

I think this should be simple but its not working for me! Thanks!


3 REPLIES 3

samuel_rudolph
Newcomer

also there may or may not be a space between the sp name and the quote symbol.

Joe_Hoffman
Dynatrace Leader
Dynatrace Leader

Regular expressions in all Dynatrace products are a bit restrictive to avoid unnecessary processing costs. Here are two doc pages that should help explain this behavior. With a small change in syntax you should be able to accomplish your goals.

https://www.dynatrace.com/support/doc/appmon/application-monitoring/tips-and-tricks/regex-using-regu...

https://www.dynatrace.com/support/help/how-to-use-dynatrace/tags-and-metadata/reference/regular-expr...

samuel_rudolph
Newcomer

Thanks for the links. I was able to use one of the examples there

ddd\.(.{8})