Node Related Syslog Messages widget doesn't show any syslogs

Create a SWQL query widget and add in the following to the Custom SWQL Query field. (Change orion_server_name to your actual server name) This will show the last 30 syslog messages for that node. At the bottom there the code if you want to use the search option as well. Just tick the Enable Search box and add in that bit of code.

SELECT TOP 30

let.Name AS [Message Type]

,Level AS [Severity]

,TOLOCAL(DateTime) AS [Log Time]

,SUBSTRING(Message,1,100) AS Message

,CONCAT('orion_server_name','/.../syslog') AS _linkfor_Message

FROM Orion.OLM.LogEntry le

JOIN Orion.OLM.LogEntryType let ON le.LogEntryTypeID = let.LogEntryTypeID

WHERE NodeID = '${NodeID}'

--AND le.Message LIKE '%${SEARCH_STRING}%' -- Remove The -- From beginning for the "Search SWQL Query" Box

ORDER BY DATETIME DESC

Thank you for sharing.

Noticed something odd when I put it in to a custom query:

Updated orion_server_name and,got an unexpected error. 

Changed the name to include https// solved part of that but not the whole thing.

Wondering why the concat line did not work above. Any advice gratefully received.

For now replaced that concat line with:

,'your_server_name/ui/orionlog/logviewer/now/1hours/0/syslog' AS _linkfor_Message

Is it possible to get the hotlink to go to the SysLog View filtered on the device/message already, not just the unfiltered view?

Thank you for sharing.

Noticed something odd when I put it in to a custom query:

Updated orion_server_name and,got an unexpected error. 

Changed the name to include https// solved part of that but not the whole thing.

Wondering why the concat line did not work above. Any advice gratefully received.

For now replaced that concat line with:

,'your_server_name/ui/orionlog/logviewer/now/1hours/0/syslog' AS _linkfor_Message

Is it possible to get the hotlink to go to the SysLog View filtered on the device/message already, not just the unfiltered view?

Changed the link to:

'your_server_name/.../LogEntryDetails.aspx +ToString(LogEntryID) AS [_linkfor_Message]

seems to work, not in the browser so you can scroll up and down but opens up this event in a new window