Use the FROM clause to specify the event type. For example:
FROMevent_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.
The following table lists the event types with their UI names and Events Service internal names.
Event Type UI Label
Events Service Internal Name
Transactions
transactions
Logs
logs
Browser Requests
browser_records
Browser Sessions
session_records
Mobile Requests
mobile_snapshots
Mobile Sessions
mobile_session_records
Mobile Crash Reports
mobile_crash_reports
Synthetic Sessions
synth_session_records
Examples
For this result
Query
Return all fields for browser requests
SELECT * FROM browser_records WHERE appkey='E2E-AAB-AUM'
Return all fields for the business transactions in your application
SELECT * FROM transactions WHERE application='yourAppName'
Return all fields for the logs specified by "yourLogFile"