FROM Clause

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 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

FROM Clause 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"

SELECT * FROM logs WHERE sourceType='yourLogFile'