We have an issue with an application using unique tables (VWQueue_###) in statements and there are thousands. These statements appear to be called on the table a few times a day but the statement where clause is the same for each table. So, wanted to normalize the statements to be
Select from VWQueue
Delete from VWQueue
Insert into VWQueue
And then basically drop all of the Select statements that refer to VWQueue into the Select bucket.
#SELECT FROM F_SW.VWQUEUE1
introscope.agent.sqlagent.normalizer.regex.VWQEUEUE_SELECT.pattern=(SELECT)(.*)(FROM F_SW.VWQUEUE1)(.*)
introscope.agent.sqlagent.normalizer.regex.VWQEUEUE_SELECT.replaceAll=false
introscope.agent.sqlagent.normalizer.regex.VWQEUEUE_SELECT.replaceFormat=SELECT FROM F_SW.VWQUEUE1
introscope.agent.sqlagent.normalizer.regex.VWQEUEUE_SELECT.caseSensitive=false
So this is the fourth or fifth...maybe more attempt. The documentation, while the examples are nice really don't go into what the different parts are and how the formats work.
One thing that I found is if you take the pattern and paste it into the Introscope workstation - Metric Browser - search tab (with use regular expression checked), it does not work. But if you add a (.*) at the beginning the metric browser will return the statements.
Sort of hoping that the replace format will accept a basic string instead of the $1 $2 ...) $3 style since I only care that the selects go into one bucket, inserts in a different, etc.
I'll update this when I actually get it working for the next lost soul....
Billy