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
10-22-2018 11:13 AM - last edited on 07-29-2020 09:55 AM by Ryan.Paredez
Hello,
New to App Dynamics Analytics.
I want to write a query in ADQL for the following situation.
In a business transaction if a record appears more than 2 times in 30 seconds, i have to alert. Basically I have consider that they are duplicate records if they happen within 30 seconds duration. I don't find GROUP BY clause in ADQL
SELECT COUNT(segments.userData.employeeid) FROM transactions WHERE application = "MSDynamics-PROD" AND transactionName = "Plugs" and segments.userData.EventType = "Authentication" and segments.userData.EventSubType = "Passcode"
Thank You
10-22-2018 11:19 AM - last edited on 07-29-2020 09:55 AM by Ryan.Paredez
Hi @Basam.Nath
Thank you for posting your query on the AppDynamics Community.
We do support Group By Clause.
Please refer to our complete ADQL reference page.
Let us know how it goes. If you still face issues running the query, please update the thread.
07-24-2020 03:06 PM - last edited on 07-29-2020 09:56 AM by Ryan.Paredez
Did you ever get this problem solved?
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