Node Related Syslog Messages widget doesn't show any syslogs

I have recently upgraded to NPM 2020.2.  When I look at the syslog viewer I see the messages, for a node, but when I look at the "Node Related Syslog messages" widget for the same node I don't see any messages for that node. 

Has anyone run into this issue?  Does anyone know how to fix it?

Parents
  • 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

  • Great query, thanks for sharing.

Reply Children
No Data