Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
02-15-2020 11:48 AM
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_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName REGEXP NOT-LIKE "Test-job.*"
Refer below docs:
https://docs.appdynamics.com/display/PRO45/Analytics+Synthetic+Sessions+Data
https://docs.appdynamics.com/display/PRO45/REGEXP+Operator
Thanks.
02-19-2020 09:36 PM
Thanks for posting the question on the Community.
NOT LIKE and REGEXP cannot be used at the same time.
dot(.)+asterisk(*) in REGEXP is equal to asterisk(*) in LIKE phrase, so you can use NOT LIKE “Test-job.*“.
“The asterisk(*) character matches zero or more characters. ” as in the document
https://docs.appdynamics.com/display/PRO45/Comparison+Operators
Please refer to the following SQL :
SELECT count() FROM synth_session_records WHERE failureType = “Test location is currently unavailable” AND measurementSpec.scheduleName NOT LIKE “Test-job.*“
Let me know if this helped you.
Many thanks,
Mika
02-21-2020 12:24 PM
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 missing Dot in NOT LIKE clause after Equity.
So far so good, the follow up question is how to ignore many patterns, say,
SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName NOT LIKE "Test*|Equity*|Find*"
02-25-2020 10:22 PM
Hi Sanjay,
Unfortunately, regular expression cannot be used with "NOT LIKE".
Please refer to the following SQL :
SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND (measurementSpec.scheduleName NOT LIKE "Test*" OR measurementSpec.scheduleName NOT LIKE "Equity*" OR measurementSpec.scheduleName NOT LIKE "Find*")
Let me know if this helped you.
Many thanks,
Mika
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form