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…
If I run this query in SWQL Studio: SELECT SysName, Uri, Caption FROM Orion.Nodes I get 2076 rows. But if I go into the Orion "Settings:Manage Nodes" set to "[No Grouping]" I get 5310 objects. I am trying to change my nodes' "Caption" field and not seeing a bunch of nodes that I can see in the Manage Nodes list under…
Why does this query create near-duplicate lines in the output? The only difference is the AccountID column. One of the account ID's is correct the other seems random. SELECT DISTINCT [EntityUri], [SuppressFrom] AS [UtcSuppressFrom], [SuppressUntil] AS [UtcSuppressUntil], ToLocal([SuppressFrom]) AS [LocalSuppressFrom],…
It looks like you're new here. Sign in or register to get started.