The Database Mail module collects data on all aspects of DBmail, including accounts, items, attachments, configuration, profiles, and more.
Tables
Database Mail module tables are:- Collector.SysMailAccount
- Collector.SysmailAllItems
- Collector.SysMailAttachments
- Collector.SysMailAttachmentsTransfer
- Collector.SysMailConfiguration
- Collector.SysMailLog
- Collector.SysMailPrincipalProfile
- Collector.SysMailProfile
- Collector.SysMailProfileAccount
- Collector.SysMailQueryTransfer
- Collector.SysMailSendRetries
- Collector.SysMailServer
- Collector.SysMailServerType
Views
Each table above has an associated Current view, and a Previous view; e.g., Collector.SysMailAccountCurrent and Collector.SysMailAccountPrevious.
Each “Current” and "Previous" view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
- ServerName
- ServiceLevel
- Version
- Edition
- Descr