Is it possible to get with SQL REST API the same hierarchy as shown in the investigator?

Products

• APP PERF MANAGEMENT
• CA Application Performance Management Agent (APM / Wily / Introscope)
• CUSTOMER EXPERIENCE MANAGER
• 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?
 

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