dan_jagnow · Senior Architect

Looks like a problem with the quotes. You're using single quotes around the entire query. Any single quotes inside the query need to be repeated to escape them. So you would have two single quotes before and after the string literal of "gig". This should work for you: Get-SwisData $swisdev 'select top 5 interfaces.caption…

Troubleshooting this at https://thwack.solarwinds.com/t5/Discussions/slow-response-from-SWIS-API/m-p/590329.

Troubleshooting this at https://thwack.solarwinds.com/t5/Discussions/slow-response-from-SWIS-API/m-p/590329.

There doesn't appear to be anything wrong with the way you are structuring the URL. I tried it and got a sub-second response. This is running in Chrome on my Windows 10 laptop against a VM running in the corporate intranet. You might want to look at the Network tab in the Chrome DevTools (or the browser tools of your…

If you're interested in the data that is produced by a report, you can run a SWQL or SQL query to retrieve the data. See https://thwack.solarwinds.com/t5/Discussions/Running-reports-via-API/m-p/210899 for a little more information about that. If you just want to generate reports on a schedule, you may just want to follow…

You can use a query like this: SELECT TOP 100 n.NodeID, n.IPAddress, n.Caption, l.ObservationTimestamp, l.AvgLoad FROM Orion.Nodes n INNER JOIN ( -- Get the latest observation timestamp for each node. SELECT NodeID, MAX(ObservationTimestamp) AS MaxObservationTimestamp FROM Orion.CPULoad GROUP BY NodeID ) lm ON lm.NodeID =…

The error message you included indicates that your code is a little bit different from the sample you referenced. Change "nodeID" to "NodeID" in that print statement, and you should be OK. It's doing a case-sensitive lookup, so it has to match the column name in your SWQL query.

There is documentation about calling SWIS from PowerShell here: PowerShell · solarwinds/OrionSDK Wiki · GitHub You may be interested in these discussions about determining the current active sessions with Orion: Current Users Concurrent Users - NPM

Kevin, here is a full sample adapted from orionsdk-python/add_node.py at master · solarwinds/orionsdk-python · GitHub from __future__ import print_function import re import requests from orionsdk import SwisClient def main(): npm_server = 'localhost' username = 'admin' password = '' swis = SwisClient(npm_server, username,…

There is a good summary of how to kick off a discovery via the API in the wiki here: https://github.com/solarwinds/OrionSDK/wiki/Discovery That provides some examples in PowerShell of what you'll need to do. It is a fairly involved process, since discovery can be configured in a number of ways. There are also some full…

You can take a look at the Export and Import verbs described here: https://github.com/solarwinds/OrionSDK/wiki/Alerts The alert definitions are formatted as XML, and the structure of that XML is not documented, but it may work depending on what you are trying to do. See these threads for additional detail: How to create…

You can add a WHERE clause to your SWQL statement that filters the alert configurations to show only those that are enabled. An example follows: SELECT AlertID, AlertMessage, AlertRefID, Name, Description, ObjectType, Enabled, Frequency, Trigger, Reset, Severity, NotifyEnabled, NotificationSettings, LastEdit, CreatedBy,…

Jeff, performing Discovery via SWIS is complicated. Here are a few things that might be worth trying: * Prepare your Discovery profile from the UI. Invoke the Orion.Discovery.StartDiscoveryProfile verb. This verb takes only a discoveryProfleId parameter, so it should be much simpler to manage. * See what happens if you…

The Orion API does support simultaneous connections, so there should not be a problem (in principle) with using multiprocessing from a Python client to interact with it. Depending on the degree of parallelism, you could overwhelm the system, though. Are you able to share the Python script you're using (scrubbing any…

What about something like this? SELECT 'BGP Nodes' AS [Error], COUNT(NodeID) AS [Count] FROM ( SELECT DISTINCT ORN.NodeID FROM Orion.Routing.Neighbors AS ORN WHERE ORN.ProtocolID = 14 AND ORN.IsDeleted = 0 AND ORN.ProtocolOrionStatus <> 1 ) UNION ( SELECT 'BGP Neighbors' AS [Error], COUNT(NeighborID) AS [Count] FROM (…

This appears to be a bug in the validation code that SWIS enforces for this operation. I have created internal issue CORE-13827 to describe this problem. The solution should be relatively simple, but I don't see a workaround without bypassing SWIS at this point in time.

There are a couple of issues with the code as written. You won't be able to directly assign values to the AlertID or Uri properties, and the commented AlertRefID should be AlertDefID. I was able to get a similar chunk of code to execute (though I replaced the GUID with a randomly generated one): swis =…

See this thread: Quick way to look through all alert trigger definitions for a specific custom property? . As far as I know, it's not possible to gather this information with a SWQL query, but you should be able to use a SQL query on AlertDefinitionsView.

Here are some questions that may help with diagnosing the problem: * Does the client machine where you are running SWQL Studio and PowerShell belong to the same domain as the Orion server that you are connecting to? * If not, is there a trust relationship between the domains? * Are you able to log into the Orion website…

You can generate reports from Orion on a schedule. See Generate reports in the Orion Platform on a schedule for additional details. You can also use the Orion SDK (https://github.com/solarwinds/OrionSDK​) to retrieve tons of information from Orion in a variety of ways (REST API, PowerShell, Python). You could use that…

You may want to follow the troubleshooting steps described in the following thread to gather some additional information. That may help in diagnosing the root cause of this authentication problem. http request was forbidden with client authentication scheme 'Basic' Additional details about exactly how you are invoking this…

I spoke with the IPAM team about this. IPAM currently requires a higher level of permissions to perform CRUD operations via the API than is required when performing corresponding operations via the website. There is work planned to make this behavior consistent (internal issue IPAM-2651), but the workaround for the moment…

Albert, assuming you are using the Orion SDK for Python to create the custom property, you could use a syntax like this to specify the Usages: import requests from orionsdk import SwisClient def main(): server = 'localhost' username = 'admin' password = '' swis = SwisClient(server, username, password) usages = {…

If you can read WiX installer files, the answers are here: https://github.com/solarwinds/OrionSDK/blob/master/Src/Install/Product.wxs To summarize, it's going to install these things (third-party library dependencies in bold): .NET Framework 4.0 (if not already installed) SWQL Studio * SwqlStudio.exe *…

CI = Configuration Items? You'll probably want to use the Orion SDK to retrieve information from your Orion installation. You can do that via PowerShell, Python, or by accessing the REST API. There is information about those here: https://github.com/solarwinds/OrionSDK https://github.com/solarwinds/orionsdk-python There is…

Chris, it looks like you need something very similar to the code sample that Tomas Vrabel posted on this thread. It should allow you to update the warning and/or critical thresholds for a given metric type for many nodes. You would just need to know the ID of the metric for which you would like to update the thresholds,…

Yes, there has been some discussion of PowerShell Core in the past here: Bash, curl, SWQL, IPAM.IPnode and limits/offset The problem is that the library currently communicates with SWIS on the Orion server via Windows Communication Foundation (WCF). That is a Microsoft-specific communication protocol. There has been some…

Here is an example that uses a simplified version of the SwisClient from this sample​ (eliminated create, read, update, etc. that were unused). I compiled and tested this for .NET Framework 4.8. using System; using System.Collections.Generic; using System.IO; using System.Net; using System.Net.Http; using…

SolarWinds Orion does support a REST API. You may be interested in the SWIS REST/JSON Endpoint here: REST · solarwinds/OrionSDK Wiki · GitHub

Can you provide some additional details about exactly what you are trying to accomplish in this integration between Orion and PubNub? What data do you want to stream? Which direction do you want to stream it? For example, are you trying to relay Orion alerts to PubNub to send push notifications?