MSGraph Data Model
The CData Excel Add-In for Microsoft Exchange models Microsoft Exchange data as an easy-to-use SQL database, using tables, views, and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data. Some Microsoft Exchange data is related to other data; foreign keys in the tables, which are like matching IDs, show these relationships.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Microsoft Exchange account.
Common tables include:
| Table | Description |
| Users | Contains directory information for Exchange users, including user IDs, display names, job titles, and email addresses. It serves as a foundational entity for joining with activity and usage datasets. |
| Messages | Contains metadata and content for email messages sent and received through Exchange. This includes sender, recipient, subject, and body fields for mailbox analytics and compliance checks. |
| MailFolders | Lists all mail folders within user mailboxes, such as Inbox, Sent Items, and custom folders. It enables folder-level message organization and navigation in Exchange. |
| Events | Stores primary data for calendar events, including subject, location, attendees, and scheduling details. This table supports the management of both one-time and recurring appointments. |
| Calendars | Contains individual calendar entries associated with users. Each record represents a calendar that can be used for scheduling events, setting reminders, and tracking availability. |
| 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. |
| Contacts | Stores contact information for users, including names, email addresses, phone numbers, and other metadata. This table provides access to personal or organizational contact directories. |
| Groups | Provides metadata for Microsoft Exchange Groups, including group names, descriptions, membership, and administrative settings. This is useful for auditing group configurations and collaboration patterns across Exchange Online. |
| 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. |
| EventInstances | Lists each individual occurrence of recurring or single-instance calendar events. It enables tracking of actual event instances, including exceptions or modified occurrences. |
| 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. |
| EventAttachments | Displays all file attachments associated with calendar events. This view allows you to analyze or extract files linked to scheduled meetings or appointments. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| SharePointActivityUserDetail | Captures individual user actions within SharePoint, such as file modifications, site visits, and sharing activity. It supports audit logging and productivity analysis.. |
| 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. |
Stored Procedures
Stored Procedures are SQL scripts that extend beyond standard CRUD operations. These stored procedures enable advanced operations such as sending and forwarding emails, managing attachments, and facilitating OAuth authentication and token management.