JunkEmail
Tracks email items flagged as spam or junk. It facilitates review, removal, or retrieval of misclassified messages.
Columns
| Name | Type | ReadOnly | Description |
| ItemId [KEY] | String | True |
Uniquely identifies the item within the Exchange store. This value can be used to retrieve, update, or delete the item from the store. |
| MimeContent | String | True |
Contains the raw email content in Multipurpose Internet Mail Extensions (MIME) format, encoded in Base64. This stream includes headers, body, and attachments as they were originally received. |
| ItemChangeKey | String | True |
Provides a unique token that changes whenever the item is modified. Used for concurrency control and to ensure consistency in item synchronization. |
| ParentFolderId | String | False |
Holds the unique identifier of the folder that contains the current item. This allows hierarchical organization of mailbox items. |
| ParentFolderChangeKey | String | True |
Contains a unique value that changes whenever the parent folder is modified. It helps in detecting changes at the folder level during synchronization. |
| ItemClass | String | False |
Specifies the message class of the item, such as IPM.Note for standard email messages or IPM.Appointment for calendar items. Helps determine item behavior in the client. |
| Subject | String | False |
Contains the subject line of the item, limited to 255 characters. Used as the main title or summary for the item in user interfaces. |
| Sensitivity | String | True |
Indicates the sensitivity setting of the item, such as Normal, Personal, Private, or Confidential. This guides how the item should be handled and displayed by clients. |
| Body | String | False |
Holds the main text content of the message body. May include HTML or plain text formatting depending on the message composition format. |
| DateTimeReceived | Datetime | True |
Captures the exact date and time when the item was delivered to the mailbox. Used for sorting, filtering, and display in message lists. |
| Size | Integer | True |
Reports the total size of the item in bytes, including its body, attachments, and metadata. This property is read-only and useful for storage management. |
| Categories | String | False |
Lists the categories associated with the item, represented as a collection of strings. Categories help organize and visually tag items in client applications. |
| Importance | String | False |
Indicates the priority level of the item, typically Low, Normal, or High. This influences how the item is presented and handled by clients. |
| InReplyTo | String | False |
Contains the identifier of the original message that this item is replying to, facilitating message threading and conversation tracking. |
| IsSubmitted | Boolean | True |
Indicates whether the message has already been submitted to the Outbox folder for delivery. This flag is typically set when an item transitions from draft or compose mode to a state ready for sending. |
| IsDraft | Boolean | True |
Specifies whether the item is still in draft status, meaning it has been composed but not yet sent or submitted. Useful for distinguishing incomplete messages from finalized ones. |
| IsFromMe | Boolean | True |
Determines whether the sender and recipient of the item are the same user. This is commonly used to identify messages a user sends to themselves, either for reminders or testing. |
| IsResend | Boolean | True |
Indicates whether the message is a resend of a previously sent item. This can be used to track repeated attempts to deliver or forward the same content. |
| IsUnmodified | Boolean | True |
Represents whether the item remains unchanged from its original state since creation or receipt. Useful for filtering out items that have been edited or altered. |
| InternetMessageHeaders | String | True |
Contains the full set of Internet-standard headers for the message, such as From, To, Subject, Date, and custom headers. These headers provide transport and metadata information used in message routing and processing. |
| DateTimeSent | Datetime | True |
Captures the exact date and time when the message was sent from the client or mail server. This timestamp reflects when the message left the sender's outbox. |
| DateTimeCreated | Datetime | True |
Indicates when the item was originally created in the mailbox. This is typically set when the message is first composed or received. |
| ReminderDueBy | Datetime | False |
Specifies the date and time when a reminder is scheduled to be triggered for the item. This is used in conjunction with the ReminderMinutesBeforeStart value to alert users before an event or deadline. |
| ReminderIsSet | Boolean | False |
Identifies whether a reminder has been configured for this item. A true value means a user has requested a visual or audible alert prior to a specified time. |
| ReminderMinutesBeforeStart | Integer | False |
Specifies the number of minutes before the start time of a calendar event when a reminder notification should be triggered for the user. |
| DisplayCc | String | True |
Stores the concatenated display names of all recipients listed in the Cc (carbon copy) field, formatted as a single string suitable for display purposes in user interfaces. |
| DisplayTo | String | True |
Stores the concatenated display names of all recipients listed in the To field. This value is typically displayed in the message header and is used to identify primary recipients. |
| HasAttachments | Boolean | True |
Indicates whether the message or calendar item contains any file attachments. A value of true means one or more attachments are present. |
| Culture | String | False |
Specifies the culture or locale information (such as language and regional settings) associated with the item, which can affect formatting and localization of content. |
| SenderName | String | False |
Contains the display name of the sender who initiated the message or calendar event. This is typically a human-readable name presented in email headers. |
| SenderEmailAddress | String | False |
Specifies the full email address of the sender, formatted using the Simple Mail Transfer Protocol (SMTP), which is the standard format for email routing. |
| SenderRoutingType | String | False |
Identifies the protocol or routing method used to deliver the message from the sender. The default and most common value is SMTP, but other routing types can also be supported. |
| ToRecipients_Name | String | False |
Contains the individual display names of users listed as primary recipients (To) of the item. This is typically the name shown in the email client for each recipient. |
| ToRecipients_EmailAddress | String | False |
Stores the SMTP email addresses corresponding to the To recipients of the item, ensuring that each recipient can be routed correctly via email systems. |
| ToRecipients_ItemId | String | False |
Provides a unique identifier associated with each To recipient in the Exchange store. This is used for internal tracking and relationship mapping. |
| CcRecipients_Name | String | False |
Contains the display names of users who are copied on the message via the Cc (carbon copy) field, as typically displayed in the message header. |
| CcRecipients_EmailAddress | String | False |
Holds the SMTP email addresses of the recipients listed in the Cc field. These addresses are used for routing copies of the item to additional stakeholders. |
| CcRecipients_ItemId | String | False |
Stores the unique identifier for each recipient listed in the Cc (carbon copy) field, enabling linkage to recipient metadata or further recipient details. |
| BccRecipients_Name | String | False |
Specifies the display name of each recipient listed in the Bcc (blind carbon copy) field, typically shown in mail clients for administrative or logging purposes. |
| BccRecipients_EmailAddress | String | False |
Holds the email address (in SMTP format) of each Bcc recipient, which remains hidden from other message recipients to ensure privacy. |
| BccRecipients_ItemId | String | False |
Contains a unique identifier corresponding to each Bcc recipient, used internally to track recipient details and link to message metadata. |
| IsReadReceiptRequested | Boolean | False |
Indicates whether the sender has requested a read receipt for the item, which prompts the recipient's client to notify the sender when the message is opened. |
| IsDeliveryReceiptRequested | Boolean | False |
Specifies whether the sender has requested a delivery receipt, which confirms that the message was successfully delivered to the recipient's mailbox. |
| ConversationIndex | String | False |
Stores a binary string that maintains the threading hierarchy of the conversation, allowing clients to reconstruct the sequence and nesting of related messages. |
| ConversationTopic | String | False |
Represents the subject or topic line used to group related messages into a conversation thread within the mailbox interface. |
| FromName | String | False |
Displays the name associated with the sender's mailbox, typically derived from the display name field in the sender's contact or directory profile. |
| FromEmailAddress | String | False |
Contains the sender's email address in SMTP format, used to route replies and identify the sender in both headers and user interfaces. |
| FromRoutingType | String | False |
Indicates the protocol or routing method used to send the message. Common values include SMTP for standard email routing and EX for Exchange-based routing. |
| InternetMessageId | String | False |
Stores the globally unique identifier for the message, used for tracking across servers and clients and included in the message's Internet headers. |
| IsRead | Boolean | False |
Marks whether the message has been opened or viewed by the recipient. Useful for user interface indicators and automated workflows that rely on message status. |
| IsResponseRequested | Boolean | False |
Specifies whether the sender of the item has requested a response from the recipient. This is often used for meeting requests, tasks, or emails where a reply or confirmation is expected. |
| References | String | False |
Contains the Usenet 'References' header field, which is used to maintain the thread hierarchy by identifying message IDs of previous related messages. This helps email clients organize message threads in conversation view. |
| EffectiveRights_CreateAssociated | Boolean | True |
Indicates whether the client application has permission to create associated items, which are non-visible metadata objects stored within a folder, such as rules, views, or forms. |
| EffectiveRights_CreateContents | Boolean | True |
Indicates whether the client has the right to create content items such as emails or calendar events within the folder. This is typically controlled by folder-level access rights. |
| EffectiveRights_CreateHierarchy | Boolean | True |
Specifies whether the client has permission to create subfolders within the current folder. This is applicable to folders like the mailbox root or custom folders. |
| EffectiveRights_Delete | Boolean | True |
Determines if the client has the necessary permissions to delete the folder or its contained items. This includes both soft delete (move to Deleted Items) and hard delete actions. |
| EffectiveRights_Modify | Boolean | True |
Indicates whether the client is authorized to make changes to the folder or item, such as updating its properties or modifying content like message body or attachments. |
| EffectiveRights_Read | Boolean | True |
Specifies whether the client is permitted to read the folder or item contents. This includes access to message headers, body text, and item metadata. |
| EffectiveRights_ViewPrivateItems | Boolean | True |
Indicates whether the client has permission to view items marked as private, such as calendar entries or tasks that are hidden from general view by default. |
| ReceivedByName | String | False |
Captures the display name of the user or mailbox that received the item. This value is derived from the mailbox or directory profile associated with the recipient. |
| ReceivedByEmailAddress | String | False |
Stores the full SMTP address of the mailbox that received the item. This address is used for routing the message through the email infrastructure. |
| ReceivedByRoutingType | String | False |
Indicates the routing type used for delivering the message to the ReceivedBy recipient. Common values include SMTP (Simple Mail Transfer Protocol), EX (Exchange), or X400. |
| ReceivedRepresentingName | String | False |
Defines the display name of the user or mailbox that the message was received on behalf of. This is often used when messages are sent to shared or delegated mailboxes. |
| ReceivedRepresentingEmailAddress | String | False |
Specifies the SMTP (Simple Mail Transfer Protocol) email address of the mailbox user on whose behalf the message was received. This is typically used in delegated mailbox scenarios. |
| ReceivedRepresentingRoutingType | String | False |
Indicates the type of routing used for the ReceivedRepresenting mailbox user, such as SMTP or EX. The default is SMTP, which refers to standard email routing over the internet. |
| LastModifiedName | String | True |
Contains the display name of the user who most recently modified the item. This helps track authorship or recent activity related to the item content or metadata. |
| LastModifiedTime | Datetime | True |
Stores the timestamp of the most recent modification made to the item, including updates to properties or content. This field is read-only and system-generated. |
| IsAssociated | Boolean | False |
Indicates whether the item is an associated item within a folder. Associated items are not visible in standard folder views and are used for storing folder-level data such as rules or forms. |
| WebClientReadFormQueryString | String | True |
Provides a relative URL query string that should be appended to the base Outlook Web App (OWA) endpoint to open the item in read-only mode via the web interface. |
| WebClientEditFormQueryString | String | True |
Provides a relative URL query string to append to the Outlook Web App endpoint to open the item in edit mode, allowing web-based updates to item contents. |
| ConversationId | String | True |
Represents the unique identifier for a conversation thread in the Exchange store. This allows grouping of messages and items that belong to the same discussion. |
| ConversationChangeKey | String | True |
Contains the current change key for the conversation, which is used to identify the version of the conversation object and detect modifications. |
| UniqueBody | String | True |
Holds a segment of the message body that is unique to this message, excluding quoted replies or forwarded content. It can be formatted in either HTML or plain text. |
| UniqueBodyType | String | True |
Specifies the format used to store the unique body content of the item. Valid values typically include HTML and TEXT, depending on the message format. |
| ReminderMessageData_Text | String | False |
Provides the custom text message shown in a reminder for the associated calendar event or appointment. This message typically appears in reminder notifications. |
| ReminderMessageData_Location | String | False |
Indicates the physical or virtual location where the associated meeting or appointment is scheduled to occur, as stored in the reminder message data. |
| ReminderMessageData_StartTime | Datetime | False |
Captures the scheduled start time of the event or appointment that triggered the reminder, enabling accurate display and tracking of upcoming calendar items. |
| ReminderMessageData_EndTime | Datetime | False |
Captures the scheduled end time of the event or appointment that the reminder references. This helps define the full duration of the calendar item. |
| ReminderMessageData_AssociatedCalendarId | String | True |
Stores the unique identifier of the calendar item (meeting, appointment, etc.) that the reminder is associated with, linking the reminder data back to the main calendar entry. |
| Attachments | String | True |
Contains a comma-separated list of the identifiers (Ids) for all files attached to the email item (for example, 'att123, att456, att789'). |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ImpersonationUser | String |
Specifies the identifier of the user account being impersonated in the current session. This enables delegated access to retrieve mailbox or item data on behalf of another user. |
| ImpersonationType | String |
Indicates the identifier type used to define the impersonation target. Valid values include PrincipalName, SID, PrimarySmtpAddress, and SmtpAddress. |
| SharedMailboxEmail | String |
Specifies the email address of a shared mailbox. When set, this allows retrieval of Junk Email items from the specified shared mailbox rather than the default user mailbox. |