HI Imran,
Although I see Jose has provided the right answer, I suggest you start familiarizing with APMSQLServer and moving from our legacy extract tools:
-Persistent Collection
-Flat files
-IntroscopeJDBC
-CLWorkstation
- Webservices.
We introduced APMSQLServer back in 10.5.0 and it is the optimized mechanism to extract data from SmartStor database,
The mail goal of APMSQLServer is to resolve 2 main problems:
- Extract data from EM was limited
- Some of the above tools read all records in memory and then deliver it to you which could be catastrophic for the EM.
We keep improving APMSQLServer, in addition to integrate with Squirrel, Excel, CA products, it now support Grafana, for more information see: https://docops.ca.com/ca-apm/10-7/en/integrating/apmsql-cookbook
Finally, in 10.7SP1, we introduced APMSQLServer REST API a better way extract raw metric data and integrate it with your custom tools
Attached an example how to extract agents using this latest REST API,
SQL REST API - An example.docx
For more information see
SQL REST API - CA Application Performance Management - 10.7 - CA Technologies Documentation
I hope this helps,
Sergio