Database Reference
In-Depth Information
View
Join
Description
Event.vEvent.EventLevelId =
vEventLevel.EventLevelId
This is the event level information,
such as warning and error
vEventLevel
This is the name of the computer that
logged the event
vEventLoggingComputer
Event.vEvent.LoggingComputerRowId = vEventLog-
gingComputer.EventLoggingComputerRowId
This is the source in the event log or
the name of a customer event collec-
tion rule
Event.vEvent.EventPublisherRowId = vEventPub-
lisher.EventPublisherRowId
vEventPublisher
Event.vEvent.UserNameRowId = vEventUser-
Name.EventUserNameRowId
This is the user that was logged with
the event
vEventUserName
The following query returns all the events in the
OperationsManagerDW
database
and resolves the detailed information from the views listed in the preceding table:
SELECT
E.EventOriginId,
E.EventNumber,
E.DateTime,
ECa.EventCategoryTitle,
ECh.EventChannelTitle,
ELe.EventLevelTitle,
ELc.ComputerName,
EPu.EventPublisherName,
EUn.UserName
FROM
Event.vEvent E
LEFT OUTER JOIN vEventCategory ECa ON
E.EventCategoryRowId = ECa.EventCategoryId
LEFT OUTER JOIN vEventChannel ECh ON
E.EventChannelRowId = ECh.EventChannelRowId
LEFT OUTER JOIN vEventLevel ELe ON
E.EventLevelId = ELe.EventLevelId
LEFT OUTER JOIN vEventLoggingComputer ELc ON
E.LoggingComputerRowId = ELc.EventLoggingComputerRowId
LEFT OUTER JOIN vEventPublisher EPu ON
