DX Application Performance Management

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.

-Jalal

Jalal,

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.

-Jalal

Jalal,

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.

Thanks,

Jalal.

Jalal,

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.

Dear Jalal,

Please look at below posts that should help you

https://communities.ca.com/message/19446055#19446055

https://communities.ca.com/message/99593531#99593531

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.

Regards,

Kulbir Nijjer

CA Support.

Thank you Kulbir!

The articles are very helpful. I found my mistake in the syntax (RegEx).