MailboxUsageDetails
Displays granular information on mailbox storage usage, including mailbox size, number of items, and last activity timestamp per user. This is useful for capacity planning and identifying inactive mailboxes.
Select
The server uses the Microsoft Exchange API to process WHERE clause conditions built with the following columns and operators:
- Period supports the '=' operator.
- Date supports the '=' operator.
The rest of the filter is executed client-side in the server.
At a minimum, a Date or Period column is required to get the report data. By default, the driver makes a request of the period as D7 if no filter is specified.
For example, the following query is processed server-side:
SELECT * FROM MailboxUsageDetails WHERE Period = 'D7' SELECT * FROM MailboxUsageDetails WHERE Date = '2023-04-19' SELECT * FROM MailboxUsageDetails
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date when the mailbox usage report data was last refreshed. This reflects the most recent point in time for which data is available. |
| UserPrincipalName | String | The unique user principal name (UPN) associated with the mailbox. This is typically in the format [email protected] and is used to identify the user across Microsoft 365 services. |
| DisplayName | String | The full display name of the mailbox owner as it appears in the address book or global directory. |
| IsDeleted | Boolean | Indicates whether the mailbox is currently marked as deleted. A value of true means the mailbox has been removed from active use. |
| DeletedDate | Date | The date on which the mailbox was marked as deleted, if applicable. This helps track mailbox lifecycle events. |
| CreatedDate | Date | The date on which the mailbox was originally created. Useful for identifying the age and provisioning timeline of the mailbox. |
| LastActivityDate | Date | The most recent date on which email activity was detected in the mailbox, such as sending or receiving messages. |
| ItemCount | String | The total number of items (emails, calendar entries, etc.) currently stored in the mailbox. |
| StorageUsedByte | String | The total storage consumed by the mailbox in bytes, including all mailbox folders and content. |
| IssueWarningQuotaByte | String | The storage threshold in bytes at which a warning is issued to the mailbox user, indicating that they are approaching their quota limit. |
| ProhibitSendQuotaByte | String | The storage limit in bytes beyond which the user is prohibited from sending new messages from the mailbox. |
| ProhibitReceiveQuotaByte | String | The storage limit in bytes beyond which the user is prevented from receiving new messages into the mailbox. |
| DeletedItemCount | String | The number of items that have been deleted by the user but not yet purged from the Deleted Items or Recoverable Items folder. |
| DeletedItemSizeByte | String | The total size in bytes of the items currently stored in the mailbox's Deleted Items or Recoverable Items folder. |
| DeletedItemQuotaByte | String | The quota limit in bytes allocated for deleted items. When this threshold is reached, older deleted items can be purged. |
| HasArchive | Boolean | Indicates whether the mailbox has an associated archive mailbox enabled. Archive mailboxes provide additional storage for long-term email retention. |
| ReportPeriod | Integer | The number of days represented in the report. This indicates the duration over which mailbox usage data has been aggregated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Period | String | Specifies the aggregation period for the report. Supported values are D7, D30, D90, and D180, where Dn represents the number of days, indicating reporting periods of 7, 30, 90, or 180 days.
The allowed values are D7, D30, D90, D180. The default value is D7. |