This page describes advanced search options using the AppDynamics Query Language (ADQL) to search analytics data. You can also use basic search options for your searches.

  1. From the Analytics tab, click Searches.
  2. Click Add.
  3. Select Query Language Search.

Advanced Analytics Searches

Construct ADQL Queries

Each ADQL event query begins with a SELECT statement that uses a FROM clause. Use the FROM clause to specify the data source you want to query. You can query one data source in each query. 

Use the SELECT statement to further qualify the query using field_expressions and math_expressions. The WHERE clause adds conditions. For more details on specific ADQL syntax, keywords, functions, and operators, see the ADQL Reference.

When you search Analytics data, the values shown for segment fields are from the originating tier segment. Data from downstream (non-originating) tier segments are not shown. Double-click on the transaction row to view downstream segment data. Then select the Transaction Data tab.

When you click Search for queries other than select all fields (SELECT *), the results display on the visualization tab where the table widget accurately renders your query.

Use ADQL Auto-Complete 

As you construct your query, auto-complete offers suggestions for the next keyword or operator in the query. The auto-complete offers suggestions according to the stage of your query and the event type you select. It suggests data values, such as event types and fields when you type an equals sign "="  or other comparison operators after the event type name.

Note: The query box in the data tab is used only for adding WHERE clause differentiation. Aggregation functions are only available in the visualization tab under the table widget.

When you type SELECTthe fields from the last specified event type display in the auto-complete list. Fields specific to a new event type display after you complete the FROM clause.

You must include a space in front of the next keyword or you may see a validation error when executing the search or the search will be inexecutable.

Field Name Mapping

The field names in the auto-complete dropdown list correspond to UI labels with minor differences in capitalization. When the field names have prepended database-related information, such as segments.errorList.errorType for Error Type or segments.httpData for HTTP data fields, they refer to data for individual segments of the transaction as it progresses from tier to tier. The segments fields do not represent data that refers to the overall business transaction instance. See ADQL Data for a list of fields, UI labels,  and internal database names for each data source.