search cancel

CA APM Grafana APMSQL queries

book

Article ID: 117748

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE

Issue/Introduction

Grafana integration with CA APM is a new feature in CA APM 10.7 SP2
http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/ca-apm-release-notes/release-comparison.html
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/application-performance-management/10-7/integrating/apmsql-cookbook/using-grafana-with-ca-apmsql.html
This article discusses some of the requirements when submitting queries from Grafana

Environment

APM 10.7 SP2 
Grafana reporting tool: https://grafana.com/grafana

Resolution

1. <agent_specifier regex>

 

The traditional agent specifier regex is a combination of agent_host, agentnt_process and agent_name i.e. 'agent_host|agent_process|agent_name'

However for the query via Grafana the agent specifier regex is built only around the agent_name.

Therefore simply using the exact 'agent_name" will ensure a match e.g for agent name "SCCD-Server01" e.g.

apmsql 'SCCD-Server01' 'Frontends|Apps|%:Responses Per Interval' agg_value exact

Also using a partial agent_name with regex wildcards at either or both ends should also work e.g.

apmsql 'SCCD.*' 'Frontends|Apps|%:Responses Per Interval' agg_value exact



2. Handling special characters in agent names

When querying for example agent names like "Custom Metric Agent (Virtual)*" the parentheses need to be escaped

However a simple escape with single '\' is not enough when using Grafana because it strips it out. Therefore a double escape '\\' is needed e.g.

a. MOM with agent name: Custom Metric Agent (Virtual)

apmsql 'Custom Metric Agent \\(Virtual\\)' 'Enterprise Manager|Health:Heap Capacity (%)' agg_value exact

b. Collector with agent name: Custom Metric Agent (Virtual) ([email protected])

apmsql 'Custom Metric Agent \\(Virtual\\) \\([email protected]\\)' 'Enterprise Manager|Health:Heap Capacity (%)' agg_value exact


Additional Information

This was discussed in detail in CA APM Community post : No data points (grafana+apmsql)

 

Attachments