cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Business iQ (Analytics)

Is GROUP BY available in ADQL?

Basam.Nath
Builder

Is GROUP BY available in ADQL?

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

Tags (1)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
Is GROUP BY available in ADQL?
2 REPLIES 2
Radhika.Puthiyetath
AppDynamics Team (Retired)

Re: Is GROUP BY available in ADQL?

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.


Thanks,
Radhika P




Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Manoj.Kumar
Creator

Re: Is GROUP BY available in ADQL?

Did you ever get this problem solved?

Regs
Manoj
AppDynamics beginner