EventLog Table

The EventLog table contains events for which only non-immediate (daily or weekly) alerts exist. Microsoft Windows SharePoint Services copies these event records from the EventCache table.

Warning  Modifying the database schema or database structures is unsupported. Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

Columns

Column name Data type Description
SiteId uniqueidentifier ID of the site available, from the Sites table.
NotifyFreq int Value that indicates the frequency with which alerts are sent. Immediate (0), Daily (1), or Weekly (2).
EventTime datetime Time when the event record was inserted into the database.
ListId uniqueidentifier ID of the list in which the monitored item appears.
ItemId int ID of the item that raised the event.
ItemName nvarchar Full name of the item.
ItemFullUrl nvarchar Full path to the item.
EventType int Item Added (1), Item Modified (2), Item Deleted (4), Discussion Added (16), Discussion Modified (32), Discussion Deleted (64), Discussion Closed (128), Discussion Activated (256).
ModifiedBy nvarchar User name of the person whose modification raised the event.
TimeLastModified datetime Time when the event occurred.