Hello everyone! Could you help me; I need check for high consumption of queries in Instrocope 10 , I tried using the expression senguinte ( // this is a top 10 query select * from metric_data where agent='.*' and metric='.*Average Response.*' and timestamp between '2016/01/12 00:00:00' and '2016/01/12 23:59:00' sort by value d maxmatches=10 ) did not have more success.
Do you know any expression that can help me?
It looks like you have a valid query syntax for Introscope JDBC API:
JDBC API - CA Application Performance Management - 10.1 - CA Technologies Documentation
However there may be a problem with your date format not matching your JVM locale. This KB has advice on that:
For more on thios topic:
There is also Web Service Fieldpack from Guenter_Grossberger which has a war file you can deploy to the EM_HOME/webapps folder to be hosted by the EM Web Server. Then use the jsp directly or Excel for your queries. You can find it on this Documents link: Easy Integration Web Service Fieldpack
Also the Easy Integration Kit from Hiko_Davis here Re: RE: Introscope JDBC API - Performance
Hope it helps
Hi! Thanks for the tips! I'll be checkingAttRicardo Vieira
Please respond if the previous answer was helpful or if further assistance is needed.
Hi! I still can not solve can help me ?I have a problem that is this , I must look with the Instroscope for queries that consume CPU , I 've been using the following command( . *) SELECT ( . * ) Average Response Time ( . *)You know some search commands in Introscope ?
Including Lynn_Williams to see if he has some additional suggestions
For the metric expression part of the query.
(.*)Average Response Time(.*)
Hi! OK! I will check the tips ... Thanks for now ! I used the expressions most did not succeed . I can only collect the queries with the command
(.*)SELECT(.*)Average Response Time(.*)
More 'll evaluate better
Ricardo L P Vieira