We are looking to integrate our 3rd party application with Solarwinds with REST API. Trying to test with the following query via POSTMAN but unable to retrieve any details from Solarwinds. https://<MainpollerIP>:17778/SolarWinds/InformationService/v3/json/Query?query=SELECT NodeID, ,DateTime ,AvgResponseTime…
Just this week, I'm encountering this error when opening SWQL studio: "don't know how to handle element properties" The tree-view wont expand or show any schema. I type something into the search and it hangs up. then it throws up a load of .Net errors This is the first time this week I've encountered this issue. Strangely…
Dears , Below is the query to fetch alert info triggered date , details etc , attached the screenshot . Need to fetch NODE ID along with this query , can anyone help me to customize to include Node ID please . Query ===== SELECT DISTINCT AlertActive.AlertActiveID , AlertObjects.AlertObjectID , AlertConfigurations.Name ,…
Hello solarwinds community, we use orion for our company, and we noticed a big problem of space consumption of the orion database lately. on the log table, we have this line : [dbo].[OrionLog_LogEntryFieldValue] of the size of more than 140.000.000KB so is more than 140 GB, which is huge. we do not know what this table…
I would like to delete nodes based on the following SWQL select statement: SELECT DISTINCT NodeID FROM Orion.Nodes WHERE Status = 9 AND UnManageFrom < ADDYEAR(-1,GETDATE()) (3948 nodes) I could do this with SQL Management Studio but am afraid this would break table relationships. Whereas, SWQL Studio enforces them. The…
Facing error while fetching data via SWIS API. "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." Anybody aware of this error? Is there a fix for this problem?
Hello, I was wondering if it's possible to setup a query in SWQL Studio to look for flows that have a certain number of packets per second. I've looked through Orion.Netflow.Flows (and Orion.Netflow for that matter) but wasn't able to find anything obvious. Essentially what I'm trying to accomplish is if, let's say, IP…
How do you setup authorization to the API to pull information from a Dashboard?
Hello All, I'm building a script for Orion and I tried to use API and I have a weird issue with it. I used SWQL studio (where queries are working fine) and from there Edit -> Copy Query As -> Curl (cmd) I copy pasted in windows CMD and it worked like a charm, then I tried to do the same in Linux and suddenly I have an…
I'm trying to make a single report that uses a custom SWQL query. I can use get-swisdata with the query and get it output in a csv but I'd like it to have the look of a SolarWinds report. I do not see a way within the web GUI to prompt the user to input something but I can do that using the PS commands. So is there a way…
It looks like you're new here. Sign in or register to get started.