How to identify which nodes currently have Log Analyzer monitoring enabled in SolarWinds Platform

This article can help you in some uses cases where you are not seeing Logs from certain syslog or trap sources even though you have confirmed the traffic is hitting the SolarWinds pollers via packet capture tool.
 

Check the license usage via Web console > Settings > All Settings > License Details Look for Log manager :

- In the example above,
Nodes currently monitored = 31 (Node with Log monitoring enabled currently)
Total Nodes in License =25 (Your max LA license limit).
To address this, either purchase additional LA licenses (upgrade license) or execute a query to find which nodes are currently configured for LA monitoring:

1. Connect to the SolarWinds server.
2. Open Database Manager in the SolarWinds Platform folder of the Start menu.
3. Select Add Orion Server.
4. Expand the SQL Server and right click the SolarWinds Database in bold.
5. Select New Query, and paste the below in the window on the right.
6. Select Execute Query.

-- 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 nodeid,caption,ip_address from nodes 
WHERE nodeid in ( SELECT nodeid FROM [dbo].[NodeSettings] where settingName like 'OLM.MonitorNode' and SettingValue='1')

7. In the Web Console, navigate to the Node(s) you wish to disable monitoring > Edit node > Set Log and Event Monitoring Status to Disabled and save.