We have updated to version 2019.4
Data disappeared from Syslog tables on views
Yup I noticed the same thing. This should get you going.
wesleykparker provided the following SQL code (in another thread) to replace the syslog widget.
SELECT TOP 100 -- Edit this number for how many messages you want to load to widget (you can modify the widget for how many messages to page)
let.Name AS [Message Type]
,Level AS [Severity]
,TOLOCAL(DateTime) AS [Log Time]
,SUBSTRING(Message,1,100) AS Message -- Edit the last number for how many characters of the message you want to see
,CONCAT('YOURORIONURLHERE','/ui/orionlog/logviewer/now/1hours/',${NodeID},'/syslog') AS _linkfor_Message --Replace YOURORIONURLHERE with the address ex: 'https://orion.abc.com'
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.