EmailUrlInfo Schema #
Table description #
| TableSection | TableType | TableSectionName | Description |
|---|---|---|---|
| Emails | Regular | Information about URLs on Office 365 emails |
Table retention #
| HotDays | ColdDays | TotalInteractiveDays |
|---|---|---|
| 30 | 0 | 30 |
Schema #
| Name | Description | Type |
|---|---|---|
| NetworkMessageId | Unique identifier for the email, generated by Microsoft 365 | String |
| ReportId | Unique identifier for the event | String |
| Timestamp | Date and time when the record was generated | DateTime |
| Url | Full Url from email | String |
| UrlChainId | Unique identifier for the root url | String |
| UrlChainPosition | Position of a url in a nested url list | Int32 |
| UrlDomain | Domain name or host name of the URL | String |
| UrlLocation | Indicates which part of the email the URL is located | String |
Schema changes #
| Date | Action |
|---|---|
| 2026-02-27 | Column TenantId removed |
| 2026-02-27 | Column Type removed |
| 2026-02-27 | Column SourceSystem removed |
| 2026-02-27 | Column TimeGenerated removed |
| 2026-01-02 | Column _IsBillable removed |
| 2026-01-02 | Column _BilledSize removed |
| 2026-01-02 | Column UrlChainId added |
| 2026-01-02 | Column UrlChainPosition added |
| 2024-10-18 | Table added to tracking |