tdanner ✭✭✭✭✭

This was the other thread: python orionsdk.SwisClient.(invoke, update) method examples

Serdar, could you repost that error message? All I got was "thank you".

Just a tip - in SWQL you have a shortcut to use instead of joins. Your query is equivalent to this shorter one: SELECT V.Caption, V.VolumeSpaceAvailable, V.Node.Vendor FROM Orion.Volumes V WHERE V.Node.Vendor = 'Windows'

It's the same in 9.0, except that you can also add ICMP-only nodes from the website now.

Good point! I forgot about that method.

The other way to do it is to use the discovery API to add the node. That method can add the interfaces for WMI nodes.

I recommend you start with an SDK training video. Unfortunately I can't link directly to it, but you can go to https://customerportal.solarwinds.com/VirtualClassrooms/#0 and search for "Expert Series: Create Custom SLA reports with SWQL".

Examples in VB.NET and Java using this WSDL are installed at C:\Program Files (x86)\SolarWinds\Orion SDK\Samples. Hope that helps.

What does the "provider fault" look like?

mulder85gr‌ - what version of NPM? And what kind of device are you querying?

The certificate errors you are getting are because the certificate SWIS uses for HTTPS is intentionally not a valid certificate. It is self-signed rather than issued from a proper certificate authority like Verisign, and its common name is CN=SolarWinds-Orion instead of whatever the FQDN of your server is. In this mode,…

Added this information to PowerShell · solarwinds/OrionSDK Wiki · GitHub

Thanks for bumping this thread. Looks like we missed answering it the first time around. This information is in Orion.NodePortInterfaceMap. This entity tracks the association between interfaces and VLANs, including trunk/access mode. You can either query it directly or access it through the "InterfacePortMaps" navigation…

Here's the list. Most of these are also properties of Orion.Accounts. AccountEnabled DisableSessionTimeout AllowAdmin AllowNodeManagement AllowMapManagement AllowCustomize AllowReportManagement AllowAlertManagement AllowUnmanage AllowDisableAction AllowDisableAlert AllowDisableAllActions AlertSound LastLogin SummaryViewID…

SWQL supports the "CASE" expression from SQL. Like this: CASE (Transact-SQL). You can use that to compare UnDP values to your thresholds and select an image that way.

A minor note - the upgrade installer will take care of stopping the services for you.

In Orion Platform 2018.2/NPM 12.3 (currently in beta), SWQL gains the CHARINDEX function. With that and the existing SUBSTRING function, you can remove a trailing %65536. Like this: SELECT SUBSTRING(IPAddress, 1, CHARINDEX('%', IPAddress)-1) AS TrimmedIPAddress FROM Orion.F5.LTM.VirtualIPAddress

It looks like we don't have an icon for POS interfaces. I can't figure out how the Interface Details resource is showing one! If we did have one, it should be called 171.gif (171 is the official ifType number for that interface type). Could you check something for me? Right-click on that red lightning bolt and hit…

That's correct. This will be fixed when NCM updates to SWISv3.

It looks like your account's home page is a Node Details view, but you don't have a default Net Object set for your account. You should go into the admin section (http://.../Orion/Admin) and switch your account's home page to a summary view.

Here's a PowerShell script that works. Note that the credentials need to already been in the system since this API refers to them by CredentialID. You can find the IDs by querying Orion.Credential, but there is currently no API for insert/update to Orion.Credential.

I'm looking into this and I'm having trouble getting it to work correctly. I'll keep looking and follow up when I have something for you.

I'm glad you were able to get it figured out. I went back and looked at the documentation page here (Alerts · solarwinds/OrionSDK Wiki · GitHub​). It seems clear to me - the first parameter is listed as "int[] alertObjectIds" using syntax that would be familiar to anyone used to C-family languages. To help future python…

Your code looks fine. I just tested it myself and it worked for me. Are you on NPM 11.5?

I'm not clear on what you are trying to do. Could you give more details about your goal?

From https://github.com/solarwinds/OrionSDK/wiki/Alerts#verb-getalertsuppressionstate: enum EntityAlertSuppressionMode { NotSuppressed = 0, SuppressedByItself = 1, SuppressedByParent = 2, SuppressionScheduledForItself = 3, SuppressionScheduledForParent = 4 }

Get-SwisData has a -TimeOut parameter (in seconds; default is 30). Like this: $swis = Connect-Swis blah blah Get-SwisData $swis "SELECT sluggish FROM superslow" -timeout 120

I believe this "Distance" property has to do with how the IPAM management tree (groups/supernets/subnets) is structured and nothing to do with distance in the network topology sense. I have asked the IPAM team to confirm that and weigh in on the multiple records thing. Matt, what version of IPAM are you running?

Sorry for the late reply; I was out for a few days. The extra math you are seeing relates to two things SWIS is doing: providing the illusion that all timestamps in the database are in UTC when in fact not all of them are, and synthesizing in/out percent utilization values out of bps and bandwidth settings. In our…

Try changing GETDATE() to GETUTCDATE(). SWIS operates in UTC.