ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Is it possible to get with SQL REST API the same hierarchy as shown in the investigator?
Article ID: 130092
Updated On:
Products
CA Application Performance Management Agent (APM / Wily / Introscope)
INTROSCOPE
Issue/Introduction
We are working with SQL REST API and would like to get the same hierarchy as shown in the investigator as the output of the query.
Is it possible to get the same hierarchy as shown in the investigator by using the SQL REST API?
Is it possible to get the same hierarchy as shown in the investigator by using the SQL REST API?
Environment
10.7
Resolution
Yes, it is possible. Basically the Investigator tree is showing all metrics in a hierarchy of "Agent Domain" -> "Host" -> "Process" -> "Name" -> "Metric Path" and the SQL REST API metrics table have all these columns.
Additional Information
Using APMSQL REST API
https://comm.support.ca.com/kb/_using-apmsql-rest-api/KB000091849
https://comm.support.ca.com/kb/_using-apmsql-rest-api/KB000091849
Feedback
Yes
No
Powered by
