This query will display events from OLV related to the node. This widget can be added to the nodes details.
SELECT top 50
tolocal(loge.DateTime) as [Date]
,loge.level as [Level]
,case when loge.level='debug' then '\Orion\Images\Check.Green.gif'
when loge.level='informational' then '\Orion\Images\icon.info.gif'
when loge.level='notice' then '\Orion\Images\alerting_16x16.gif'
when loge.level='warning' then '\Orion\Images\warning_16x16.gif'
when loge.level='error' then '\Orion\Images\Small-Down.gif'
when loge.level='critical' then '\Orion\Images\Orange.Round.png'
when loge.level='alert' then '\Orion\Images\ActiveAlerts\Critical.png'
end as [_iconfor_Level]
,TOUPPER(SUBSTRING(loge.LogMessageSource.caption,1,case when charindex('.',loge.LogMessageSource.caption,1) <=4 then length(loge.LogMessageSource.caption) else (charindex('.',loge.LogMessageSource.caption,1)-1) end)) AS [Node]
,loge.LogMessageSource.OrionNode.DetailsUrl AS [_LinkFor_Node]
,concat('/Orion/images/StatusIcons/Small-',loge.LogMessageSource.OrionNode.StatusIcon) AS [_IconFor_Node]
,loge.LogMessageSource.IPAddress as [IPAddress]
,concat('/NetPerfMon/Images/Vendors/',loge.LogMessageSource.OrionNode.VendorIcon) as [_IconFor_IPAddress]
,Message
FROM Orion.OLM.LogEntry loge
--join Orion.OLM.LogEntryLevel lel on lel.LogEntryLevelID=Loge.LogEntryLevelID
where --Loge.LogType.Name='syslog' --and message like '%asa%'
daydiff(tolocal(loge.DateTime),getdate()) = 0
and loge.LogMessageSource.nodeid = '${nodeid}'
order by loge.DateTime desc
Thank you,
Amit
Loop1 Systems