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 Cmdlets PowerShell Module 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. |