Discussion Feed
02-21-2020
12:24 PM
1 Kudo
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*"
... View more
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.
... View more
02-07-2019
06:29 AM
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.
... View more
Latest Activity
- Got a Kudo for Re: Is it possible to have "NOT LIKE" in ADQLs?. 02-24-2020 12:58 PM
- Posted Re: Is it possible to have "NOT LIKE" in ADQLs? on Business iQ (Analytics). 02-21-2020 12:24 PM
- Posted Is it possible to have "NOT LIKE" in ADQLs? on Business iQ (Analytics). 02-15-2020 11:48 AM
- Tagged Is it possible to have "NOT LIKE" in ADQLs? on Business iQ (Analytics). 02-15-2020 11:48 AM
- Tagged Is it possible to have "NOT LIKE" in ADQLs? on Business iQ (Analytics). 02-15-2020 11:48 AM
- Tagged Is it possible to have "NOT LIKE" in ADQLs? on Business iQ (Analytics). 02-15-2020 11:48 AM
- Tagged Is it possible to have "NOT LIKE" in ADQLs? on Business iQ (Analytics). 02-15-2020 11:48 AM
- Posted Re: How do I increase the maximum SQL capture length? on Knowledge Base. 02-07-2019 06:29 AM
- Kudoed How do I increase the maximum SQL capture length? for Erin. 02-07-2019 06:28 AM
- Kudoed How do I set up an alert for when an AppDynamics Agent is down? for Saradhi.Potharaju. 02-28-2018 11:55 AM
Community Stats
Date Registered | 09-19-2014 12:01 PM |
Date Last Visited | 02-23-2021 09:45 AM |
Total Messages Posted | 5 |
Total Kudos Received | 1 |