Data Source Picker timeout for Custom Table Orion Log Viewer Report

1/4/2022 10:48 AM

1/4/2022 10:48 AM

You have created a Custom SQL Table report in Orion web console to report on Log Manager For Orion Nodes which looks something like this:

and when you try to save the changes after modifying by clicking Update Data source Orion web page crashes.
The rest of the web console and pages and Solarwinds in general working fine.
 

Log Analyzer

DB connection timeout due to the nature of Query as it is not filtering on range(limit) of rows which is causing SQL to timeout on SWIS.

Use the following SWQL to instead of using pattern matching without time limit query in the report.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT TOP 10 TOLOCAL(DateTime) AS DATETIME, MS.Caption, MS.IPAddress, Message
FROM Orion.OLM.LogEntry LE
JOIN Orion.OLM.MessageSources MS ON MS.MessageSourceID= LE.MessageSourceID
WHERE MS.Caption = 'mynodename'
AND DateTime > ADDHOUR (-1, GETDATE())
AND Message LIKE '%msg source IP%'
ORDER BY DATETIME DESC

Refer to Use SolarWinds Query Language (SWQL) in the Orion Platform for more details