MSGraph データモデル
CData Python Connector for Microsoft Exchange は、テーブル、ビュー、ストアドプロシージャを使用してMicrosoft Exchange データを使いやすいSQL データベースとしてモデル化します。 これらは、スキーマファイルで定義されます。スキーマファイルは、データの構造と構成を定義する、シンプルで読みやすいテキストファイルです。 一部のMicrosoft Exchange データは他のデータと関連しています。テーブル内の外部キーは、ID のマッチングのようなもので、これらの関連性を示します。
テーブル
テーブル セクションには標準SQL テーブルの詳細が、ビュー セクションには読み取り専用SQL テーブルの一覧が記載されています。これらには、Microsoft Exchange アカウントでのアクセスを想定したサンプルが含まれています。
一般的なテーブルには以下のものが含まれます。
| テーブル | 説明 |
| 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. |
ストアドプロシージャ
ストアドプロシージャ は、標準的なCRUD 操作を超える機能を持つSQL スクリプトです。 これらのストアドプロシージャは、E メールの送信と転送、添付ファイルの管理、OAuth 認証とトークン管理の簡素化などの高度な操作を可能にします。