Cisco AppDynamics Community

Sanjay.Girotra · 02-15-2020

Hi,I understand below query is possible:SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName REGEXP "Test-job.*" But is this possible:SELECT count(*) FROM synth_sessi...

Sanjay.Girotra · 02-21-2020

Thanks for the response Mika.Although it accepted "NOT LIKE", below query worked:SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName NOT LIKE "Equity*".Note the miss...

Sanjay.Girotra · 02-07-2019

Is there any limit on the # of characters for SQL query? We increased to 2000 and these are still truncated and I have been requested to change to 4000.

Cisco AppDynamics Community

User Statistics

User Activity

Is it possible to have "NOT LIKE" in ADQLs?

Re: Is it possible to have "NOT LIKE" in ADQLs?

Re: How do I increase the maximum SQL capture length?