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