dan_jagnow · Senior Architect

I haven't worked with PubNub before, but their documentation describe how you can create a channel and publish to it: Javascript V4 Publish/Subscribe Tutorial | PubNub PubNub has SDKs for multiple languages/platforms: Developer Tutorials & SDKs for building realtime apps | PubNub You might be particularly interested in the…

Chris, I'm afraid that SWQL Studio shows that Orion.Thresholds does not support Create/Update/Delete operations at present. I believe your only options for updating CPU and memory thresholds are to update them through the UI one by one or, as you've discovered, to directly update the database table. Updating the database…

Perhaps a query like this? SELECT n.NodeName, n.DetailsUrl AS NodeDetailsUrl, i.InterfaceName, i.DetailsUrl AS InterfaceDetailsUrl, i.InPercentUtil, i.OutPercentUtilFROM Orion.NPM.Interfaces AS iLEFT JOIN Orion.Nodes AS n ON n.NodeID = i.NodeIDORDER BY i.PercentUtil DESC If not, perhaps you could provide some additional…

Are there any additional details you can provide about the script?

If you'd like to convert the timestamp in the results in SWQL, you can use the ToLocal function: results1=swis.query("select ac.Name,ac.AlertMessage,ao.RelatedNodeCaption,case when ac.Severity=2 then 'Critical' else 'major' end as Severity,ToLocal(aa.TriggeredDateTime) as Alertime from Orion.AlertActive aa left outer join…

Dave, the SwisPowerShell module communicates with the SolarWinds Orion platform API. You can use it to suppress alerts. There is a sample script for suppressing alerts via PowerShell here: https://github.com/solarwinds/OrionSDK/blob/master/Samples/PowerShell/AlertSuppression.ps1 There is also some useful documentation…

A few more questions: * Do you have multiple engines in your environment, where the nodes you are adding might be assigned to a different engine ID? * Have you tried the following troubleshooting steps for ICMP polling? Troubleshoot nodes and interfaces that are Unknown…

The INNER JOIN should work perfectly well as long as you expect all of the nodes you want to find to be present in Orion.ContainerMemberSnapshots.

What version of IPAM are you running? You might want to check with SWIS logs to see if there are any warnings or error messages. For a default installation, they are located at C:\ProgramData\SolarWinds\InformationService\v3.0\Orion.InformationService.log. Execute your script and then look at the most recent entries in the…

There are several ways to limit the number of records that come back to avoid timeouts. You can add use TOP to limit the maximum number of records to return. You can add a WHERE clause to filter the records that come back. An example for Orion.ResponseTime follows. You can also add an ORDER BY DESC clause to ensure that…

In your discoveryProfile, fix the missing 'p' in ReeatIntervalMiliseconds so it is RepeatIntervalMiliseconds.

I created internal issue CORE-13470 to track this request. Until that change is done, I think your only options are to update the database directly or use a web UI automation tool to accomplish this via the user interface. The latter approach is probably even more difficult and fragile, but it would allow you to avoid…

This has not changed yet. It is being tracked with internal issue number CORE-4885.

Unfortunately, it appears that these definitions are not available in a code table in the database. As far as I can tell, they are only defined in code.

Try searching the logs for "Exception occured when parsing job result." That should be correlated with a "Parsing of discovery result failed." message.

It's difficult for me to troubleshoot this without access to your environment. For example, I don't have TechnicalService or Campus custom properties in my environment. I do have a few suggestions: * Try changing the SELECT TOP 5 in the subquery to a different number (i.e., TOP 1000) to determine whether that is the cause…

There are some details about how WPM encrypts and stores those credentials here: https://support.solarwinds.com/SuccessCenter/s/article/Security-protocols-and-encryption-algorithms-used-by-Web-Performance-Monitor-WPM Microsoft provides some guidance on how to work with Microsoft's Data Protection API (DPAPI) here: How to:…

It's possible that this is a bug that has been addressed in some release after IPAM 4.5.1. I'm testing with IPAM 2019.4. I created a new account and did not grant any global administrator rights: I left all the defaults for this account except in the IPAM settings, where I made the user an IPAM admin: Then I ran a very…

I might recommend using the average availability over the last week. Here's a SWQL query (the SQL query is very similar) that helps you see some information about the average, minimum, and maximum availability over the past week. That might help you decide what to use. SELECT TOP 25 rt.NodeID, n.Caption,…

That is correct. API login events are not logged. Create, update, and delete operations are logged in Orion.AuditingEvents: Orion.AuditingEvents | Orion SDK Schemas If you have need of API login event auditing, you may want to submit a feature request.

There is not a publicly-available way to track progress on internal issue numbers. Whenever we release new product versions, we do make an effort to identify the issues that were resolved in that release and update any Thwack threads that referenced those issues. If this is an important issue for you, you could also create…

The steps described by tomas.vrabel above (using the AddNode API) are the only workarounds of which I am aware. Unfortunately, they do require you to know the node's IP address in advance.

Here is a Python sample for updating a custom property on a node: https://github.com/solarwinds/orionsdk-python/blob/master/samples/custom_property_update.py This is very similar to what you're trying to do, except you would like to update custom properties on an interface instead. Here's a PowerShell sample that does…

I'm not entirely sure what the issue is, but it looks like the generated script encountered an error while trying to perform the agent download. You might want to run the script again, then open the log file for the Orion website (at C:\ProgramData\SolarWinds\Logs\Orion\OrionWeb.log). The most recent entries in that log…

That's strange. I've built that sample solution recently. What error are you getting?

You may be interested in this thread: How do you add volumes using the rest api?

Credentials can be added via the API in you script (see https://github.com/solarwinds/OrionSDK/wiki/Credential-Management​). However, it's probably simpler just to add the credentials through the UI and then reference the existing credentials in your script. 

I believe that you'll want to pursue one of the options in step 14 of the migration guide for a new server with a new IP/host name: Migrate SolarWinds Orion products to a new server with a new IP or hostname 14. Redeploy or reconnect to Agents You have multiple options for deploying or reconnecting to existing Agents…

I'm surprised that your NCM module would be working at all if SWIS can't communicate to the NCM plugin on the BusinessLayer. Does NCM seem be behaving normally from the Orion GUI? I would recommend opening a support ticket and uploading full diagnostics so we can take a closer look at this issue. I suspect that the NCM…

I believe all the URL-casing problems have been resolved now. Let me know if you find any remaining problems.