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. |