Need help SQL syntax for JAVA programming for Introscope. I can run the following statement successfully:
select * from metric_data
but if I add a where clause, I can't run it successful, even with the following:
select * from metric_data where agent='.*'
Any guidance to syntax is appreciated.
Are you looking to tie Introscope to the API Gateway product or are you looking for Introscope support?
Thank you Stephen for your quick view.
I am looking for pulling Introscope data through JAVA. Or if there’s another simpler method to pull Introscope data in CSV format or any other readable format programmatically.
We will need to move this to the Introscope team community part as this community area is for API Management.
Pardon my ignorance. Yes, please move it but please let me know the URL for it to follow up.
The communities.ca.com site is for all CA product so we are just aligning it within the community site to the right product group.
Please look at below posts that should help you
Also pls refer to APM Configuration Guide for information on JDBC API and it's usage as well as APM API Reference for other ways for e.g using Webservice API to query for APM data.
Thank you Kulbir!
The articles are very helpful. I found my mistake in the syntax (RegEx).