dan_jagnow · Senior Architect

I'm glad to hear it's working now, Sandeep, though it would be more satisfying to understand what was causing the problem earlier. Good luck with your project!

It is definitely possible to set up account limitations that would affect what data your account has access to: https://support.solarwinds.com/SuccessCenter/s/article/Account-Permissions-and-Limitations-Video Are you using the same account to connect to SWIS that you are using to log into the GUI? You should see the same…

Sandeep, the query that you've written should give an accurate count of all the nodes that are managed by Orion. When you say that you have 400 nodes, are you sure that all 400 nodes are currently managed (monitored) by Orion? You can run a SWQL query like this to get details about the nodes that Orion knows about. Do you…

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.

There is a very useful discussion of how node status is calculated for Orion Nodes here: Orion Platform 2019.2 - Enhanced Node Status There is also useful information here: Troubleshoot nodes and interfaces that are Unknown Unmanaged vs External I'll try to summarize for the particular statuses you listed: * Unknown - The…

Internally, the last two parameters for this SWIS verb (configuration and parameters) are of type Dictionary<string, string> in C#. That means it's a dictionary data structure with a string key and a string value. When serialized as XML, Microsoft uses ArrayOfKeyValueOfstringstring…

Here is an example adapted from some internal design documents. I haven't tested this, so take it with a big grain of salt. If this doesn't work, I'll ask the team that worked on this feature to comment here. CreateApiPollerFromTemplate allows you to create an API Poller based on a template exported either from an existing…

LAG and OVER are supported in Transact-SQL (see https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16). SWQL is designed to mimic SQL, but it doesn't support all SQL operations. See https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions for the list of supported SWQL functions.

SwisPowerShell targets netstandard2.0 (see https://github.com/solarwinds/OrionSDK/blob/610cd2fd486e75932ef5b0ed4650a54c130c4267/Src/SwisPowerShell/SwisPowerShell.csproj#L3). See the Microsoft documentation (https://learn.microsoft.com/en-us/dotnet/standard/net-standard?tabs=net-standard-2-0) for the versions of the .NET…

What version of the product are you using? And what version of the Orion SDK? It is entirely possible that the port change described in https://thwack.solarwinds.com/product-forums/the-orion-platform/f/orion-sdk/98142/swis-rest-api-port-deprecation-did-you-know is the cause of the problem.

From the Windows Start menu, type "Apps & features" (or "Add or remove programs", which is still how I think of it). Once you're in Apps & features in the System Settings, type "Orion SDK" in the search bar. You should see an entry for the SolarWinds Orion SDK with a version number and the date it was installed.

CORE-15843 is still unresolved at this point. I've added some notes on the issue.

Thanks! I approved and merged the pull request.

That error message comes from this part of func_ModernDashboards.ps1. See Everything you wanted to know about exceptions for details about how PowerShell handles exceptions, and pay attention to the $PSItem automatic variable that gives you details about the exception. If you tweak the script to print that out in the catch…

Sorry for the long delay in getting the new release published, but it is out there now: https://github.com/solarwinds/OrionSDK/releases/tag/v3.0.336 Give that a try. It includes the fix from https://github.com/solarwinds/OrionSDK/pull/278, and it should fix this problem. It worked in my testing.

I don't have NCM installed right now, so I can't verify this directly, but try this: SELECT Caption FROM Orion.Nodes orionnode LEFT JOIN NCM.Nodes ncmnode ON orionnode.NodeID=ncmnode.CoreNodeID LEFT JOIN Orion.ContainerMemberSnapshots AS cms ON orionnode.NodeID=cms.EntityID LEFT JOIN Orion.Container AS c ON…

Hmm... I tested this out on a local Orion VM, and after kicking off ImportListResources on node via SWQL Studio, I was able to invoke GetScheduledListResources with a ReadyForImport response: ... and I was able to ImportListResourcesResults with a true response instead of an error. Does this behavior occur regardless of…

See https://github.com/solarwinds/OrionSDK/wiki/Alerts for details about working with alerts via the API. It's generally preferable to avoid working directly with the database tables if you can avoid it.

CORE-18048 has been reviewed by the Engineering teams and added to the backlog for resolution, but it hasn't made it into a release yet.

See the Get-Credential documentation and this advice for options that allow you to securely manage credentials with PowerShell.

It may be easiest to use the SWIS REST API. See this post from StackOverflow for a quick example of how to interact with a REST API from JavaScript. Be aware that Postman is a very useful tool for troubleshooting REST APIs.

This is a confirmed bug in product. It is being tracked internally as issue CORE-15843. I'm sorry to say that a fix did not make it into the 2020.2.6 release, but it has been associated with multiple customer issues and is getting some attention.

The best way to install SwisPowerShell is by following the instructions here: https://github.com/solarwinds/OrionSDK/wiki/PowerShell You'll want to run the following command from PowerShell: Install-Module -Name SwisPowerShell

Are you able to use SWQL Studio on the same computer to connect to SWIS? Are you connecting to SWIS from the Orion server itself, or a different machine? If the latter, does the same PowerShell command work when run on the Orion server? Is it possible that a firewall is blocking the connection?

This appears to be a bug, and it's tracked in internal issue CORE-18048.

We have been able to reproduce this problem. It is tracked internally as CORE-18048.

This looks like a bug in SWIS. I was able to reproduce this on a lab server. I have created internal issue CORE-18048 to track this.

You can see from the response headers that it's redirecting you to the Login.aspx page with a ReturnUrl. It looks like the authentication approach you're using isn't working. See https://github.com/solarwinds/OrionSDK/wiki/Connecting-to-SWIS and https://github.com/solarwinds/OrionSDK/wiki/REST for more details.

[quote userid="217954" url="~/product-forums/the-orion-platform/f/orion-sdk/30838/swis-uri-connection-is-wrong/289703#289703"]This link is giving error page not found.[/quote]You can find the page here: thwack.solarwinds.com/.../swis-query-issue-after-server-move

See https://thwack.solarwinds.com/product-forums/the-orion-platform/f/orion-sdk/25327/using-orion-credential-set-for-snmpv3-when-adding-node-through-sdk for details about the options for managing the SNMP credentials for a node.