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
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form