Use the FROM clause to specify the event type. For example:

FROM event_type

Event Types

Event types describe the source of the analytics data, such as business transactions (transactions) or browser requests. Each event type has a UI field name and an Events Service internal name. The Events Service internal name is used in ADQL queries.

This table lists the event types with their UI names and Events Service internal names.

Event Type UI LabelEvents Service Internal Name
Transactionstransactions
Logslogs
Browser Requestsbrowser_records
Browser Sessionssession_records
Mobile Requestsmobile_snapshots
Mobile Sessions

mobile_session_records

Mobile Crash Reports

mobile_crash_reports

Synthetic Sessions

synth_session_records

FROM Clause Examples

For this resultQuery
Return all fields for browser requestsSELECT * FROM browser_records  WHERE appkey='E2E-AAB-AUM'
Return all fields for the business transactions in your applicationSELECT * FROM transactions WHERE application='yourAppName'
Return all fields for the logs specified by "yourLogFile"

SELECT * FROM logs WHERE sourceType='yourLogFile'