ADQL can't search application transaction

[Tony_Yan]

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? 

[Morelz · Accepted solution]

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