Novell SENTINEL 6.1 SP2 - REFERENCE GUIDE 02-2010 Reference Manual

Also see for SENTINEL 6.1 SP2: Installation guide User guide

Contents

Novell SENTINEL 6.1 SP2 - REFERENCE GUIDE 02-2010 Reference Manual Manual pdf 139 page image

Sentinel Database Views for Microsoft SQL Server 139novdocx (en) 7 January 20108.1.24 CONTACTS_RPT_VView references CONTACTS table that stores contact information.8.1.25 CORRELATED_EVENTS_RPT_V (legacy view)This view is provided for backward compatibility. New reports should useCORRELATED_EVENTS_RPT_V1 because this view does not include archived correlated eventsthat have been imported back into the database.8.1.26 CORRELATED_EVENTS_RPT_V1View contains current and historical correlated events (correlated events imported from archives).VALUE varchar/nvarchar(255) Text value if anyDATA ntext XML dataDATE_CREATED datetime Date the entry was createdDATE_MODIFIED datetime Date the entry was modifiedCREATED_BY int User who created objectMODIFIED_BY int User who last modified objectColumn Name Datatype CommentCNT_ID int Contact ID - Sequence numberFIRST_NAME varchar/nvarchar(20) Contact first name.LAST_NAME varchar/nvarchar(30) Contact last name.TITLE varchar/nvarchar(128) Contact titleDEPARTMENT varchar/nvarchar(128) DepartmentPHONE varchar/nvarchar(64) Contact phoneEMAIL varchar/nvarchar(255) Contact e-mailPAGER varchar/nvarchar(64) Contact pagerCELL varchar/nvarchar(64) Contact cell phoneDATE_CREATED datetime Date the entry was createdDATE_MODIFIED datetime Date the entry was modifiedCREATED_BY int User who created objectMODIFIED_BY int User who last modified objectColumn Name Datatype Comment