Creating Reports for SCOM and SCVMM - Microsoft System Center Reporting - page 215

E.EventPublisherRowId = EPu.EventPublisherRowId
LEFT OUTER JOIN vEventUserName EUn ON
E.UserNameRowId = EUn.EventUserNameRowId
Event.vEventDetail
The Event.vEventDetail view contains the description and event data of each indi-
vidual event. You can join this view to the Event.vEvent view on the EventOri-
ginId column, as shown in the following query:
SELECT
E.EventOriginId,
E.EventNumber,
E.DateTime,
ED.RenderedDescription
FROM
Event.vEvent E
LEFT OUTER JOIN Event.vEventDetail ED ON
E.EventOriginId = ED.EventOriginId
Event.vEventParameter
The Event.vEventParameter view contains all the parameters of an event and their
corresponding values. This information is also available in the event description. You can
join this view to the Event.vEvent view on the EventOriginId column, as shown
in the following query:
SELECT
A.AlertGuid,
A.AlertName,
A.RaisedDateTime,
AP.ParameterIndex,
AP.ParameterValue
FROM
Alert.vAlert A
LEFT OUTER JOIN Alert.vAlertParameter AP ON
A.AlertGuid = AP.AlertGuid