Dashboard panel query builder

Use the query builder to construct AQL queries.

Procedure

  1. Select the Query Builder Query Type.
  2. Select an Ariel database from the Database drop-down list to be used in the query FROM clause.
  3. Select Ariel database fields from the Fields drop-down list to be used in the query SELECT clause.
  4. Construct an Ariel database field filter using Add Filter -> Choose Field -> Choose Operator -> Add Filter Value to be used in the query WHERE clause.
  5. Add AQL aggregate clauses using Group By, Having, Order By, and Limit.
  6. Create a Timeframe for your query using the LAST or START/STOP keywords.
  7. View your constructed query.
  8. Click Run Query.
    Important:
    • Ariel metadata fields must be in double quotes for the query to run: “Event Summary”
    • Order By requires an Order value, ASC or DESC.
    • START/STOP requires a datetime value one of these formats:
      • ‘yyyy-MM-dd hh:mm:ss’
      • ‘yyyy-MM-dd hh:mm:ss:ms’
      • ‘yyyy-MM-dd hh:mm’
    • Having requires single quotes around string values: ‘0.0.0.0’
    • globalview database queries require a saved search, time range, and manually entered fields. For more information, see AQL data retrieval functions.

What to do next

Add your dashboard variable to a dashboard panel query. For more information about editing your dashboards, see Adding a dashboard.