Cisco E-Mail Manager Option

Document ID: 44382

Questions

Introduction
Which database table contains the outgoing messages in E-Mail Manager?
NetPro Discussion Forums - Featured Conversations
Related Information

Introduction

For more information on document conventions, see the Cisco Technical Tips Conventions.

Q. Which database table contains the outgoing messages in E-Mail Manager?

A. At message receipt, E-Mail Manager stores all e-mail messages in raw form, and some internal headers, in the messages table. The messages include incoming and outgoing messages, as well as drafts. The messages table contains two fields. This table shows the messages table structure in detail:

Name	Type	Size	Key
Message	text	16
MessageKey	varchar	32	Primary Key

Note: The schema in this table refers to SQL Server. For additional information, refer to:

• Cisco eMail Manager (CeM) Professional Services Guide, Version 4.0.5

In order to identify the type of item that E-Mail Manager has stored, join the mess_type table with the messages table. The mess_table is one of the main tables for storage of dynamic information about incoming and outgoing messages. The mess_type table contains nine fields. This table shows the mess_type table structure in detail:

Name	Type	Size	Key
LastModified	datetime	8
MessageKey	varchar	32	Primary Key
Owner	varchar	32
PksOwner_id	int	4
ReadStatus	int	4
StatusFlags	int	4
TimeDone	int	4
TimeStored	datetime	8
Type	int	4

Main values for Type code are:

• 0: archived incoming message
• 1: active incoming message
• 2: pending outgoing message
• 9: sent outgoing message
• 11: active internal message
• 12: archive internal message

This SQL statement extracts all outgoing messages from the Cisco E-Mail Manager database after the send of the messages:

select a.Message from messages a, mess_type b where 
  a.MessageKey=b.MessageKey and b.type=9

Note: This value displays over two lines due to space limitations.

NetPro Discussion Forums - Featured Conversations

Related Information

• Technical Support - Cisco Systems