Node related information from Orion Log Viewer

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