Using Underscores in SQL Query state of CA APM Alert.

Document ID : KB000014954
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

  What to do about the the underscores in the SQL Query state of a CA APM Alert. These includes special characters in the metric name and need to be replaced with "_".

 

Question:

Here are some examples of underscores in a SQL Query state of a CA APM Alert.

unknow_underscore.png

Environment:
APM 10.x
Answer:

APM Agent does not allow certain characters in the metric name. Also if agent uses some special characters like "|", ":" (pipe and colon) as separators , these are also not allowed in metric name.


SQLAgent tracers also do not allow these special characters in metric name and  must be replaced with "_".