EventCache Table

The EventCache table stores the list of site events for which users have requested alerts. Microsoft Windows SharePoint Services inserts records into the EventCache table as they occur.

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
EventTime datetime Time when the event record was inserted into the database.
SiteId uniqueidentifier ID of the site, available from the Sites table.
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 ItemAdded (1), Item Modified (2), Item Deleted (4), DiscussionAdded (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.