Table Overview

Table Overview

Boomerang tables are integral part of Boomerang Services system. All Boomerang tables are located in Boomerang catalog and feature dbo schema. Boomerang background services use Windows authentication for SQL server connection.

Any changes to Boomerang tables, including, but not limited to, adding new or altering existing columns and index objects, adding table and/or column constraints, altering table and column collations, etc. are not advisable

The ownership to Boomerang tables should not be removed from designated Boomerang Windows account. It is acceptable to grant other registered SQL logins ownership to Boomerang tables or read/write access, however one should exercise caution to prevent risk of exposing sensitive data to un-trusted applications and/or parties.

If a master table lacks spare column to store required data you may opt to create additional tables to facilitate such storage. The only exception to the rule is EVENT_MASTER table, to which it is acceptable to add columns and indexes.

List of Tables

Table Name Description
CODE_FILE This table is intended to be used to gather all types of codes that might help you simplify and standardize frequent used information i.e. instead of typing information you can simply select appropriate code from this table.
CONTENT_PARAMETER This table stores the report parameter and value in the event that the content are supplied by a SQL Reporting Service report and that the report requires parameter(s).
EVENT_CONTENT This table is used to specify what type of content to be used. Depending on the service you are using different fields apply.
EVENT_LOG This table is updated by the Boomerang and contains a log of all events generated by any of the services.
EVENT_MASTER As the name indicates this is the master table which most tables are depended on. The primary purpose of event_master is to control the status of a job. The secondary role of the table is to provide user defined classification, grouping, labeling etc. This is made possible with a number of generic fields in different types.
EVENT_STATUS This table is updated by Boomerang and contains current status of all events.
IN_EMAIL This table contains all e-mails sent to Boomerang. If the original e-mail was sent by Boomerang and tracking is turned on (follow link for more information) the jKey will populated so that you can easily retrieve the message thread.
IN_EMAIL_CONTENT This table contains all e-mail attachments sent to Boomerang.
IN_EMAIL_HEADER Table contains e-mail header information from received e-mails.
IN_EMAIL_RECIPIENT Table contains all recipients for each e-mail received by Boomerang.
IN_TWIT Table contains all Twitter status updates sent to Boomerang.
IN_TWIT_HEADER Table contains Twitter header information from Twitter status updates sent to Boomerang.
IN_SMS Table contains all text messages (SMS) sent to Boomerang.
OUT_EMAIL This table is the main table for the e-mail out service. Records inserted into this table will be sent out. The table contains information regarding to the sender of the e-mail and message subject and body.
OUT_EMAIL_RECIPIENT This table contains destination e-mail address/name pairs to compliment entries in OUT_EMAIL.
OUT_FAX This table is the main table for the fax out service. Records inserted into this table will be faxed out. The table contains information regarding to the sender and receiver of the fax and fax number to use.
OUT_FILE This table is the main table for the file out service. Records inserted into this table will be saved to a network share.
Note: In order for the file out service to be able to save successfully to a network share the service account needs to have sufficient privileges on the share in question.
OUT_PRINT This table is the main table for the file out service. Records inserted into this table will be printed to a network printer.
Note: In order for a particular printer to be used by the printing service it needs to be properly configured.
OUT_TWIT This table is the main table for the Twitter out service. Records inserted into this table will be posted to the Twitter account associated with Boomerang.
OUT_SMS This is the main table for the SMS (Text Messaging) out service. Records inserted into this table will be sent to specified mobile phone number. The table contains the specifics of the outgoing text messages like from, to and text message.
SYSTEM_VARS This table contains Boomerang Services runtime parameters. For more information on system parameters click here.