# SessionById: Inspectlet Inspectlet Sessions ## Documentation One session recording, looked up by its session ID. - Catalog: `Inspectlet` - Schema: `Inspectlet` - Primary Keys: `sid` - Label: Inspectlet Sessions The data in this table is partitioned per value of the `` column. This is a read-only table function. The Inspectlet API may not support changing the data or the Invantive UniversalSQL driver for Inspectlet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Inspectlet API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `SessionById`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `sid` | `number` | ☐ | | The session ID. | ## Columns of Table Function The columns of the table function `SessionById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `browser` | `varchar2` | | ☐ | The visitor's browser's major family name. | | `country` | `varchar2` | | ☐ | The visitor's country, as its full English name rather than as an ISO code. | | `date_end_session_utc` | `datetime` | | ☑ | The session's last recorded activity (UTC). | | `date_start_session_utc` | `datetime` | | ☑ | The session's start time (UTC), to fractions of a second. | | `device_type` | `varchar2` | | ☐ | The type of device used during this visit (desktop/phone). | | `display_name` | `varchar2` | | ☐ | The visitor's display name, as sent in when identifying the visitor from client-side JavaScript. | | `exit_page` | `varchar2` | | ☐ | The URL of the last page in the session. | | `ip` | `varchar2` | | ☐ | The visitor's IP address. | | `landing_page` | `varchar2` | | ☐ | The URL of the first page in the session. | | `mltimebucket` | `varchar2` | | ☐ | Reported by Inspectlet without a documented meaning, and carried through as text. | | `new_visitor` | `char` | | ☐ | Whether this is the first session from this visitor on this website. | | `num_pages` | `int32` | | ☑ | The total number of pages in this session. | | `page_height` | `int32` | | ☐ | The browser page height. | | `page_width` | `int32` | | ☐ | The browser page width. | | `referrer_source` | `varchar2` | | ☐ | The referring traffic source of this session, as free text. | | `session_duration` | `int64` | | ☑ | The total session duration in seconds. | | `sessionlink` | `varchar2` | | ☐ | A guest-accessible, sharable URL to watch this session recording. | | `sid` | `int64` | | ☑ | The session ID. | | `starred` | `char` | | ☐ | Whether this session recording is starred. | | `uid` | `varchar2` | | ☑ | The identifier Inspectlet uses for the visitor, reported as text. | | `useragent` | `varchar2` | | ☐ | The visitor's browser's complete user agent string. | | `wid` | `int64` | | ☑ | The website ID. |