dan_jagnow · Senior Architect

Just to confirm, the issue was fixed in the 2019.4 release.

As of the 2020.2 release there are PollNow, EnablePollingForNodes, and DisablePollingForNodes verbs on Orion.AssetInventory.Polling: http://solarwinds.github.io/OrionSDK/2020.2/schema/Orion.AssetInventory.Polling.html

@"andre3000", it looks like you are doing everything right. I believe you are encountering a bug tracked internally as CORE-13827. Currently, the Create and Update CRUD operations via the API only allow the following options for SNMPV3PrivMethod: "None", "DES56", "AES128". The input validation is overly aggressive. I will…

I think the next step is debugging the connection with tools like NetPath, Traceroute NG, or Wireshark. I'd also see if there is a difference depending on which client machine you use to connect to SWIS, including attempting a connection directly from the Orion server itself.

The certificate warning is expected. Orion uses its own certificate by default. There are some details about that here, including instructions on replacing it with a legitimate certificate if you would like to use a valid certificate of your own. That involves some effort, though. The connection reset is the unexpected…

You can SUM across multiple interfaces with a GROUP BY: SELECT n.NodeName, n.DetailsUrl AS NodeDetailsUrl, SUM(i.InPercentUtil) AS InPercentUtil_AllInterfaces, SUM(i.OutPercentUtil) AS OutPercentUtil_AllInterfaces FROM Orion.NPM.Interfaces AS i LEFT JOIN Orion.Nodes AS n ON n.NodeID = i.NodeID GROUP BY n.NodeName,…

Hmm... I tried creating a report with the query you supplied, and the ToLocal function didn't cause any problems there: This was tested with Orion Platform 2019.2 HF1. What version are you using?

Depending on the version of SQL Server, you may be able to use AT TIME ZONE to do this conversion: AT TIME ZONE (Transact-SQL) - SQL Server | Microsoft Docs There are several techniques that work for older versions, too: sql - Convert Datetime column from UTC to local time in select statement - Stack Overflow

Have you checked the license keys on engine 1?

I think you're on the right track, Chris. If you mark all the nodes you want to edit with a custom property, you'll have the filter you need to be able to update them en masse through the UI. It is a bit roundabout, but it sounds much better than making the updates manually or taking your chances on a direct database…

As long as all the nodes you want to see are part of at least one of the dynamic groups that you're matching in Orion.ContainerMemberSnapshots, you should be able to use your INNER JOIN. You'll just need more conditions in the ON check to handle additional groups.

This is probably not working for you because of the version of IPAM that you have installed. GetFirstAvailableIp is a pretty new verb: IPAM vNext API · solarwinds/OrionSDK Wiki · GitHub When I tried your code with the current release candidate version of IPAM, it ran without error.

I ran your query against my Orion instance (after commenting out the filters on the Agency and Network custom properties, which don't exist in my environment). It executed in sub-second time (0.41 seconds). I don't believe the problem is with the query itself, though it is true that there are a lot of conditions in your…

Do we have any rest web API which could update the values of custom properties defined in Solar winds and we could try to push the values from ServiceNow? Yes. The REST API documentation below includes a section on updating custom properties. REST · solarwinds/OrionSDK Wiki · GitHub

Thanks. I added a link to that feature request to the internal issue.

I replaced the final line in my PowerShell script with the line you proposed, ran it with an account with only IPAM access, and got this: new-swisobject : Access to IPAM.Subnet denied. At C:\Users\dan.jagnow\LongPathHere\IPAMCreateSubnetCrud.ps1:12 char:1 + new-swisobject -swis $swis -entitytype 'IPAM.Subnet' -properties…

Sorry about the slow reply on this; I was traveling last week. If NCM is functioning normally, you may not be successful in getting help via a support ticket. I'll send you a private message so you can send me your diagnostics directly, assuming you still have an ongoing problem with the API calls.

I believe that Step 8 of Task 2 in Migrate SolarWinds Orion products to a new server with a new IP or hostname provides the steps for updating the system identifier.

@"NightEdition", I've spoken to one of the developers who has worked on Orion's authentication code. He believes there is a problem with retrieving the SID for the user account. His advice was to open a ticket with SolarWinds so we can fix the issue. We will likely need debug logs (see Adjust logging levels with the…

What version of Orion do you have installed? The AddDay function has been around since at least 2017. Also, do you have the current version of the Orion SDK installed? The LexerService in SWQL Studio does include a reference to AddDay, though I'm not sure offhand whether that is only used for auto-completion or also for…

That makes sense. So are you trying to originate a push of data from CnMaestro, then? Or are you thinking about some independent scheduled job that would pull data from CnMaestro and send it to SolarWinds?

I don't have data to test this with, but I think a query like this should get you what you need. If you group by the NodeID to find the max (latest) value in a subquery, you can then join that back to the table to grab values associated with the records you select, like the Config column: SELECT ca.NodeID, ca.DownloadTime,…

You might also want to search for "MngSetPortAdminStatus" in the Business Layer logs for UDT. You should find those under C:\ProgramData\SolarWinds\Logs\Orion\. Look for entries with timestamps right around the time that you run your script. There may be some useful clues about what is happening in there.

It is possible to get additional information about the error in PowerShell. See the explanation here: How to prevent Write-Error CategoryReason truncation in powershell? - Stack Overflow Also, having the full script (or a pared-down minimal example that reproduces the problem, with sensitive info removed) would help.

This issue is being tracked in internal issue NPM-10755. The fix is planned for the 2019.4 release of NPM.

You'll want to check the contents of your $strOrionServer variable to make sure it has a valid format. There are details about how to connect to SWIS via PowerShell here: https://github.com/solarwinds/OrionSDK/wiki/PowerShell The -Hostname parameter could be localhost or a server name or IP address. If you need to dig into…

I ran this by one of our architects who is very familiar with the internals of SWIS, and here's the response I got: The log in the thread starts with the “Update exited”, which means that the Update itself has already completed, and now SWIS only generates PubSub notifications for subscribers. I’d ask for messages before,…

ImportTemplate and ExportTemplate SWIS verbs were added to Orion.APM.ApplicationTemplate with the SAM 6.8 release.

I'm not aware of any way to change the format of the response so it will be a bare node ID instead of the JSON-formatted response. If you're putting this into some kind of a script/program, you will probably need to do some lightweight JSON parsing to extract the node ID. What scripting/programming language do you intend…

There are details about copy/paste in PyCharm at https://www.jetbrains.com/help/pycharm/cutting-copying-and-pasting.html​. Note that the documentation states: Because PyCharm uses the system Clipboard, you can copy and paste between applications. So doing, when pasting Clipboard entries, PyCharm removes any formatting from…