Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData ADO.NET Provider for Microsoft Exchange Views


Name	Description
CalendarView	Returns a collection of calendar events—such as occurrences, exceptions, and single instances—within a specified time window. This is useful for generating user-defined calendar views across various calendar types.
EmailActivityUserDetail	Provides detailed logs on email activity per user, such as number of emails read, sent, received, and interactions with the mailbox, which is often used for monitoring usage trends or security audits.
EmailAppUsageUserDetail	Captures insights into how users access their email accounts, including which email clients (desktop, mobile, web) they use and what activities they perform on those platforms.
EventAttachments	Displays all file attachments associated with calendar events. This view allows you to analyze or extract files linked to scheduled meetings or appointments.
EventInstances	Lists each individual occurrence of recurring or single-instance calendar events. It enables tracking of actual event instances, including exceptions or modified occurrences.
GroupMembers	Provides a list of members within Microsoft Exchange groups. This includes user identifiers and membership roles, supporting scenarios like group management and access control.
M365AppUserDetail	Returns detailed usage metrics showing which Microsoft Exchange apps (for example, Word, Excel, Outlook) and platforms (for example, Windows, Mac, web, mobile) users have accessed. Helps assess app adoption and usage trends.
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.
MessageAttachments	Provides a view of all attachments associated with email messages, including file names, types, and sizes, which is essential for identifying large or sensitive file transmissions.
Office365ActivationsUserDetail	Shows which users have successfully activated Office 365 across devices, including installation date and license status. This is useful for license compliance tracking and deployment validation.
Office365ActiveUserDetail	Reports on user-level activity across Office 365 services (Exchange, Teams, SharePoint, etc.). It includes the last activity date per service to help identify inactive or underutilized accounts.
Office365GroupsActivityDetail	Details the usage and engagement of Microsoft Exchange Groups, including counts of emails, posts, and file activities. This is useful for understanding collaborative group behavior over time.
OneDriveActivityUserDetail	Tracks OneDrive user activity including file views, edits, and sync actions. This is useful for monitoring user engagement with cloud storage and detecting abnormal file behavior.
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.
SharePointActivityUserDetail	Captures individual user actions within SharePoint, such as file modifications, site visits, and sharing activity. It supports audit logging and productivity analysis.
SharePointSiteUsageDetail	Provides aggregated metrics on SharePoint site usage, including file storage, number of active users, and site visits. This is useful for managing site performance and relevance.
SkypeForBusinessActivityUserDetail	Displays detailed usage statistics of Skype for Business per user, such as message volume, call durations, and meeting participation. It aids in tracking user engagement and service effectiveness.
SkypeForBusinessDeviceUsageUserDetail	Shows the types of devices used to access Skype for Business, helping IT teams understand client distribution and identify legacy platforms.
TeamsDeviceUsageUserDetail	Reveals which device types (desktop, mobile, web) are used by each user to access Microsoft Teams. This is useful for analyzing platform preference and guiding hardware planning.
TeamsUserActivityUserDetail	Provides detailed insights into user interactions in Microsoft Teams, including chat messages sent, meetings attended, and file collaboration. It supports productivity assessments and adoption tracking.
YammerActivityUserDetail	Provides a detailed breakdown of user-level activity within Yammer, including metrics such as messages posted, read activities, and engagement trends over time.
YammerDeviceUsageUserDetail	Offers insights into how users are accessing Yammer by device type (for example, mobile, desktop, web), enabling device usage analysis at an individual user level.
YammerGroupsActivityDetail	Returns detailed analytics on activity across Yammer groups, including post volume, member participation, and engagement rates, grouped by Yammer group.