Database Reference
In-Depth Information
Note
Note that this is a one-to-many relationship, that is, the join can return multiple rows per
event, one for each parameter.
Event.vEventRule
The
Event.vEventRule
view contains the ID of the rule and the ID of the managed
entity the event came from. You can join this view to the
Event.vEvent
view on the
EventOriginId
column. You can also join the
vRule
view to
Event.vEventRule.RuleRowId = vRule.RuleRowId
and the
vMan-
agedEntity
view on
Event.vEventRule.ManagedEntityRowId = vMan-
agedEntity. ManagedEntityRowId
if you want to resolve the rule and the object
that the event came from:
SELECT
E.EventOriginId,
E.EventNumber,
E.DateTime,
R.RuleDefaultName,
M.FullName
FROM
Event.vEvent E
LEFT OUTER JOIN Event.vEventRule ER ON
E.EventOriginId = ER.EventOriginId
LEFT OUTER JOIN vRule R ON
ER.RuleRowId = R.RuleRowId
LEFT OUTER JOIN vManagedEntity M ON
ER.ManagedEntityRowId = M.ManagedEntityRowId
The following screenshot provides a visual view of the all the join relationships discussed
in this section: