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 |
| Calendar | Stores and manages calendar items such as appointments and meetings. It supports operations to create, retrieve, update, and delete calendar entries, including time, location, subject, and associated metadata. |
| Calendar_OptionalAttendees | Captures information about optional attendees for scheduled calendar events. It requires an associated item Id to retrieve attendees linked to a specific meeting or appointment. |
| Calendar_RequiredAttendees | Stores data on required attendees for calendar events. The queries must specify an item Id to identify the associated meeting and its required participants. |
| Contacts | Maintains contact information including names, email addresses, phone numbers, and job titles. It supports full Create, Read, Update, and Delete (CRUD) operations for managing a user's personal or shared address book. |
| DeletedItems | Represents items moved to the Deleted Items folder, including messages, calendar events, and tasks. It allows recovery, permanent deletion, or inspection of deleted content. |
| Drafts | Holds unsent email drafts. This enables operations to create new drafts, update draft content, delete drafts, or retrieve draft messages for review or sending. |
| Folders | Manages user-defined and system folders such as Inbox, Sent Items, and custom folders. It supports folder hierarchy operations like creation, deletion, and renaming. |
| Inbox | Contains received email messages directed to the user's inbox. It allows access to individual messages with full Create, Read, Update, and Delete (CRUD) capabilities for inbox content management. |
| JunkEmail | Tracks email items flagged as spam or junk. It facilitates review, removal, or retrieval of misclassified messages. |
| Outbox | Temporarily stores outgoing email messages pending delivery. The items in this table can be created, reviewed, or deleted before transmission is completed. |
| SentItems | Archives sent email messages for auditing and retrieval. It allows querying and management of previously sent emails. |
| Tasks | Maintains a list of tasks, including due dates, completion status, priorities, and reminders. It supports full task lifecycle management through CRUD operations. |