OneDriveUsageAccountDetail
Summarizes OneDrive storage usage by account, including total storage consumed, number of files, and last interaction date. This information helps in managing storage policies and identify inactive accounts.
Select
The connector 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 connector.
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 OneDriveUsageAccountDetail WHERE Period = 'D7' SELECT * FROM OneDriveUsageAccountDetail WHERE Date = '2023-04-19'
Columns
| Name | Type | Description |
| ReportRefreshDate | Date | The date on which the OneDrive usage report data was last refreshed. This reflects the most recent day for which activity or storage metrics are available. |
| SiteURL | String | The full URL of the user's personal OneDrive site, used for identifying and accessing the specific document library associated with the user. |
| OwnerDisplayName | String | The display name of the user who owns the OneDrive site. This typically includes the user's full name as recorded in the directory. |
| IsDeleted | Boolean | Indicates whether the user's OneDrive site has been marked as deleted. A value of true means the site is no longer active or accessible. |
| LastActivityDate | Date | The most recent date on which any file-related activity—such as viewing, editing, or sharing—was recorded on the user's OneDrive site. |
| FileCount | Integer | The total number of files stored within the user's OneDrive site at the time of reporting, regardless of activity status. |
| ActiveFileCount | Integer | The number of files within the OneDrive site that were actively engaged with (viewed, edited, or shared) during the reporting period. |
| StorageUsedByte | Integer | The total amount of OneDrive storage space currently in use by the user, measured in bytes. This includes all files stored within the user's site. |
| StorageAllocatedByte | Long | The maximum amount of storage space allocated to the user's OneDrive site, measured in bytes. This is typically defined by organizational policy or license type. |
| OwnerPrincipalName | String | The unique user principal name (UPN) of the OneDrive site owner, typically in email format. Used to correlate identity across services. |
| ReportPeriod | Integer | The duration, in days, that the report covers. Common values include 7, 30, 90, and 180, representing how far back usage data is 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 | The standardized time interval over which the report aggregates activity. Supported values are D7, D30, D90, and D180, each representing the number of days in the reporting window.
The allowed values are D7, D30, D90, D180. The default value is D7. |
| Date | Date | The specific calendar date (formatted as YYYY-MM-DD) for which activity data is requested. This must fall within the past 30 days, as historical data beyond this window is not retained. |