Tables
The cmdlet models the data in Microsoft Exchange as a list of tables in a relational database that can be queried using standard SQL statements.
CData Cmdlets PowerShell Module for Microsoft Exchange Tables
| Name | Description |
| CalendarGroups | Represents collections of calendars grouped together by users for organizational purposes. Each entry in this table corresponds to a calendar group that can contain one or more individual calendars. |
| 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. |
| 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. |
| 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. |
| ExtendedProperties | Allows access to custom properties added to contact records. Developers use extended properties to store additional metadata beyond the standard contact schema. |
| 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. |
| 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. |
| 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. |
| 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. |