Use Expression in Introscope to search for Selects

[ricardosp_br]

How to do a search in the base of introscope for queries above 3,000 (ms) (I want to do this with an expression) Is there any expression of type (. *) SELECT (. *) Average Response Time (. *) Calling these milliseconds?

[Sri_Guntupalli]

Hi Rick,

 

 You posted the same here as well I guess, If so can we just mark the below one as answered and continue with this thread?

 

Seeking Expression in Ca-Introscope Queries with 3,000 (ms) and Counts of 1,000 

 

Regards
Sri

[ricardosp_br]

Yes!
Thank you!

[ricardosp_br]

Analisando este artigo https://communities.ca.com/docs/DOC-231156760
Mas eu ainda não chegaram na expressão esperado ..

 

para

Rick

[ricardosp_br]

Analyzing this article https://communities.ca.com/docs/DOC-231156760
But I have not yet arrived in the expected expression.

[ricardosp_br]

Using the expression below but I have not yet succeeded

Backends \ | (\ Oracle \ DB \) \ SQL \ | Dynamic \ | Query \ |. * \ W +: Average Response Time? {3.5} \ (ms *)

Backends \ | (\ *. \ *. \ * Query \ |. * \ W +: Average Response Time? {3.5} \ (ms *)

[Hallett German]

Hi Ricardo:

   What happens when you use the above expression, What are you getting back?

   Thanks

Hal German

[Haruhiko Davis]

Your expression seems to have too many escaped spaces in the path. Can you share a screenshot of your Investigator window that show the metric tree?

[ricardosp_br]

sorry for the delay! Follow print:

 

 

Att

 

Ricardo