Format of the Notes mail journal file

A Notes® mail journal file records each message that users send or receive.

How the journal records sent and received messages

Typically there is only one SENT event per message. However, in some cases, the journal shows multiple SENT events per message. First, mail is captured on a mail server. If the mail must be transferred to an NRPC server, then it is also counted there. It is also counted on the recipient's server (even if the sender and recipient are on the same server). If there are multiple recipients for a message the journal includes all TARGETIDs and OUTCOMEs.

RECEIVED mail is captured for any external or internal mail that is received. Internal mail will have a corresponding SENT mail entry, whereas external mail will not. On SMTP hubs there is not a SENT_MAIL for incoming mail.

File name

The name of the compressed file that you download is <date>.NOTESMAIL.txt.gz, where <date> is the file creation date , in YYYY-MM-DD format. For example: 2012-12-23.NOTESMAIL.txt.gz.

Syntax

Each record in a Notes mail journal file conforms to the following syntax:

date user name (id=customerId, customerId=customerId) performed ACTION 
[on object (type=TYPE, id=OBJECTID, name=name, customerId=customerId)] 
[targeted at (type=TYPE, id=TARGETID, name=name, customerId=customerId)] 
with outcome OUTCOME [REASON][(EXTRA)]

Each record in a journal file is contained in a single line.

Parameters

date
A date and time, for example, 2012-12-18T13:23:47+0000. One of the following values is logged:
  • The date and time that a user sends a message to another user at the company
  • The date and time that a message failed to be delivered to a user at the company
  • The date and time that a user sends a message to an external user at another company
name

The user’s Notes name, if an internal user sends the message, for example, CN=Samantha Daryn/O=Renovations. An Internet email address, if an external user sends the message.

customerId

The unique number that identifies the company subscription in the service.

ACTION

SENT_MAIL

RECEIVE_MAIL

TYPE

The type of object or target. The object type is always MAIL_MESSAGE. The target type is always RECIPIENT.

OBJECTID

The unique identifier of the mail message that is sent.

name

The name of the OBJECTID or the TARGETID. The name for the OBJECTID is always MAIL. The name for the TARGETID is the email address of the recipient.

TARGETID

The unique identifier for the recipient. This value is always null because the email address specified in the name parameter uniquely identifies the recipient.

OUTCOME

The result of the action, either SUCCESS or FAILURE. If the outcome of an event is FAILURE, the reason is given. The reason is in uppercase and can be multiple words separated by underscores. For example: FAILURE "USER_NOT_FOUND". There will be a separate SENT_MAIL and RECIEVE_MAIL for each recipient.

EXTRA

Contains the size of the message in kilobytes.

Examples

Note: The following example records are shown on multiple lines. In the journal file, each record is a single line.

  1. Samantha Daryn sends a message to another internal user at the company, Allie Singh. Allie receives the message.

    2012-12-30T19:03:01+0000 user CN=Samantha Daryn/O=Renovations
(id=20076547, customerId=20076547) performed SENT_MAIL
on object (type=MAIL_MESSAGE, id=<OFF0EBF61D.5CAAD94F-ON85257A
78.005C2BF7-85257A78.005C3063@LocalDomain>, name="MAIL", 
customerId=20076547) targeted at (type=RECIPIENT, id=, 
name="CN=allie singh/O=renovations@renovations.com", customerId=20076547) 
with outcome SUCCESS (size="1")

  2. Samantha Daryn sends a message to another internal user at the company, Allie Singh. Allie’s name is not found in the directory and the message is not delivered.

    2012-12-28T15:02:01+0000 user CN=Samantha Daryn/O=Renovations
(id=20076547, customerId=20076547) performed SENT_MAIL
on object (type=MAIL_MESSAGE,
id=<OF0645EB2C.8B339FE8-ON00257A9B.0054F723-00257A9B.0054F726@LocalDomain>, 
name="MAIL", customerId=20076547) targeted at (type=RECIPIENT, id=, 
name="CN=allie singh/O=renovations@renovations.com", customerId=20076547)
with outcome "FAILURE RECIPIENT NOT FOUND IN COMPANY DIRECTORY" (size="2")

  3. Samantha Daryn sends a message over the Internet to an external user, branney@zetabank.com.

    2012-12-28T15:02:01+0000 user CN=Samantha Daryn/O=Renovations
(id=20076547, customerId=20076547) performed SENT_MAIL
on object (type=MAIL_MESSAGE, id=<OF8E758E11.39C4D326-ON00257A9B.
00550042-00257A9B.00550046@LocalDomain>, name="MAIL", 
customerId=20076547) targeted at (type=RECIPIENT, id=, 
name="branney@zetabank.com", customerId=20076547) 
with outcome SUCCESS (size="1")