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 "_".
Here are some examples of underscores in a SQL Query state of a CA APM Alert.
<Please see attached file for image>
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 "_".