Device
Reports details on user devices involved in Eloqua interactions, such as browser, OS, and form factor.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM ActivityDetails.Device;
Columns
| Name | Type | References | SupportedOperators | Description |
| deviceID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the device record within Eloqua. | |
| brandName | String | Brand name of the device manufacturer, such as Apple, Samsung, or Dell. | ||
| browser | String | =,<>,>,<,>=,<=,IN,NOT IN | Name of the browser used on the device, such as Chrome, Safari, or Firefox. | |
| browserMajorVersion | Int | Major version number of the browser, useful for compatibility tracking. | ||
| browserMinorVersion | Int | Minor version number of the browser, providing more detailed versioning. | ||
| deviceCategory | String | =,<>,>,<,>=,<=,IN,NOT IN | Category of the device, such as Desktop, Tablet, or Mobile. | |
| formFactor | String | =,<>,>,<,>=,<=,IN,NOT IN | Form factor of the device, such as Smartphone, Laptop, or Workstation. | |
| marketingName | String | Marketing or consumer-facing name of the device model. | ||
| modelName | String | =,<>,>,<,>=,<=,IN,NOT IN | Model name or number of the device, often used for technical identification. | |
| os | String | =,<>,>,<,>=,<=,IN,NOT IN | Operating system installed on the device, such as Windows, iOS, or Android. | |
| osMajorVersion | Int | Major version number of the operating system. | ||
| osMinorVersion | Int | Minor version number of the operating system, providing detailed versioning. |