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.

Dashboards

ADQL can't search application transaction

Tony.Yan
Creator

ADQL can't search application transaction

Hi there,

We are using ADQL to get transaction in series.  e.g. 

SELECT series(eventTimestamp, '6m'), avg(responseTime) AS "Response Time (second)" FROM transactions WHERE application="xxx" AND transactionName IN ("transaction-name")

 

but we can't find anything. Actually,  we can't find them even remove all where clause. 

Did anybody know how we can get the data  as "Applicaton->Business-Transaction->Transaction snaphosts? 

 

Tags (3)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
ADQL can't search application transaction
1 REPLY 1
Mario.Morelli
Architect

Hi Tony

 

Just some checks

 

1. Analytics has been enabled from the Analytics Menu for this application and it's business Transactions?

2. If you do a simple Select * from transactions where application = "AppName", do you get anything at all?

3. Is the connectivity to the Analytics URL open from the nodes where the Agents are running? As Analytics uses a different URL to the Controller

 

Ciao



Learn more about me in the Community Member Spotlight Q & A