RESTMON - Solarwinds standard schema/profile causes request time-outs.

Products

• DX Operational Observability

Issue/Introduction

In restmon following event has been logged:

###-##-## 11:38:31,933 [AllDataCollector|solarwindsProd~~solarwinds|1|###] ERROR DataCollector:1468 - Error executing url: https://###.###:###/
SolarWinds/InformationService/v3/Json/Query?query=SELECT n.NodeID,n.ObjectSubType, n.IPAddress,M.MAC ,n.NodeName,n.DNS,n.Caption, nc.Description,n.Status, si.StatusName FROM
 Orion.Nodes n join Orion.NodeCategories nc on n.Category=nc.CategoryID and (n.NodeID=16568 or n.ObjectSubType='Agent') join Orion.StatusInfo si on n.Status = si.StatusId le
ft OUTER join (SELECT distinct nodeid, substring(MAC, 0, 5) + '.' + SUBSTRING(MAC, 5, 4) + '.' + SUBSTRING(MAC, 9, 4) as MAC FROM Orion.NPM.Interfaces where mac != '') M ON
n.NodeID=M.NodeID ORDER BY n.NodeID

Environment

DXO2 on-prem 25.1

Restmon 2.2.5

 

Resolution

Troubleshooting curl commands for Solarwind solution have been created and shared below:

curl -k -u <username>:<password> -X POST -H "Content-Type: application/json" \
  -d '{"query":"SELECT NodeID, Caption FROM Orion.Nodes"}' \
  https://<SOLARWINDS-HOST>:<PORT>/SolarWinds/InformationService/v3/Json/Query


  curl -k -u <username>:<password> -X POST -H "Content-Type: application/json" \
  -d '{"query":"SELECT n.NodeID, n.ObjectSubType, n.IPAddress, n.NodeName, n.DNS, n.Caption, nc.Description, n.Status, si.StatusName FROM Orion.Nodes n JOIN Orion.NodeCategories nc ON n.Category = nc.CategoryID JOIN Orion.StatusInfo si ON n.Status = si.StatusId LEFT OUTER JOIN (SELECT DISTINCT NodeID, MAC FROM Orion.NPM.Interfaces WHERE MAC IS NOT NULL) M ON n.NodeID = M.NodeID WHERE n.NodeID = 2868 ORDER BY n.NodeID"}' \
   https:/<SOLARWINDS-HOST>:<PORT>/SolarWinds/InformationService/v3/Json/Query

 

Development will evaluate the API calls and inspect if global config needs to be adjusted.