joiellis

Did you ever get this working?

Ah ha! This ToLocal() function only works with a SWIS v3 connection. In a V2 connection I get an error, 'The socket connection was aborted...' error, as if the query timed out, but it fails instantly after submitting the query. If I do this in V3 it works okay. Do you think you could add a note to the SDK documentation…

I've run into the problem you mention, dmthames, like some tables/columns available to the SDK and some not... all of those, so far, have been differences between the V2 schema and the V3 schema. IE, all NCM tables are, as I understand, availalble only to V2 connections, but a lot of other stuff isn't available in V2, ie…

Should ToLocal() work in SWQL Studio talking to NPM 10.6? The name of the function seems to be correct (If I tweak the name by adding a character, I get an "invalid function" error back.) but I just keep getting 'socket closed' dialog back when I try it. Can you provide a working example for a query in SWQL Studio that…

It looks like this list failed to migrate into the SDK 1.7 release. Could you please try again for 1.8's documentation?

Yes: All of them that offer a 'Filter:' field in the edit page, fail. Either the filter is ignored completely and we get the whole table being queried, or we get no results at all. If we use blatantly broken S(W)QL syntax, we get an error. I was responding to the previous question of Apr 11 asking for a working example of…

It's now 2018. This issue has come again, with the push to retire port 80 everywhere and move things to port 443. We've updated our IIS certs to a new cert signed by our own CA for port 443, but the REST interface is still using the self-signed Solarwinds original certificate. Is installing a custom, signed/trusted cert…

Thanks for the response! I can't find any references to the 'return xml auot' and 'return xml raw' options on the SWQL query. Could you add that to the PDF file for the next release of the SDK?

We've been struggling with similar questions regarding Custom Resources. We wanted to create some device-specific views and list some specific data about each individual node. So far, the ONLY resource object we've found that will actually use ${NodeID} as documented is the Custom Query that wants SWQL. Here is a working…

Here's an SWQL query I built before we abandoned using Groups. As we don't have any groups defined at all now, I can't test this properly... This returns the same number of rows as nodes in our system, IE everything we monitor is not in a group, so that side seems to be okay. SELECT NodeID FROM Orion.Nodes LEFT OUTER JOIN…

I just left a meeting where we discussed this very issue. We have our MIS group creating some custom SQL reports for us, which we found impossible to create natively with SolarWinds, To create those reports. our SQL admin added a local table to the SOLARWINDS database, containing data imported from other SQL applications…

Thank you for the prompt response. You are correct. I was missing the '/v3/ from the endpoint specification, but I had the correct port#. Amazingly, this had been working for everything else I've attempted to-date. Thank you for the pointer! I fixed the endpoint and the dump is now working. server =>…

Thanks! I've messaged you directly with the details.

Has there been any update in this bug? The same issues still exist after several new releases of the SDK. I've just installed 1.10.16 and find there is no difference between 1.10 and 1.8. It's been over a year since I last had to look at this code and I was really hoping for some improvement here.

Ah, ha! You are correct. When I move SWQL Studio back to a v2 login, it works. Is there a definitive list somewhere of the differences between v2 and v3 and what actions/services/tools demand which version? I keep tripping over these differences. Even better would be to pick a version and stick with it, because having to…

I spent an afternoon re-reading my old SOAP/Perl/LWP books and I've narrowed down the source of the issue. The sample perl library bundled in the SDK is based on the v2 wsdl, and there is nothing there for the v3 wsdl. The v3 version changed the namespaces in use, but the only call that I've seen break, so far, is the…

I can second this. I've followed so many such links to useless or missing content that I no longer bother looking at the SolarWinds online help. Searching thwack.com for discussions is usually more informative. .

You aren't the only one. I had hoped that sorting on IPAddressGUID would work, and it does, but only if the group you're sorting on is all in a .255.255.255.0 subnet. If you have larger groups, they still interleave but now on the third octet rather than the fourth octet, which is even worse. In perl apps we routinely sort…

Thank you! That makes sense. I've found another query which works fine with v2 but fails with v3 'RETURN XML AUTO', but this one tosses a different exception than the first one above. This is code we've been using for months to generate topology data as Graphvis DOT inputs. I switched it from using v2 default, to 'v3…

Try pasting this into your QueryXml call (I used our own 'Sitecode' rather than your 'Serial_Number'.): SELECT TOP 10 NodeID, Nodes.CustomProperties.Sitecode FROM Orion.Nodes

We have an inhouse-developed browser-based map, and we didn't use NPM Groups/Containers, as we find that using Groups causes our large SolarWinds installation to become practically unusable. We planted a few custom properties on all of our nodes, one that links nodes by site/location, and several that tag them with roles…

You said, "...to change how the certificate is selected for the "OrionBasic" (v2 and v3) and "/Json" (v3 only) endpoints. ..." Does this mean the JSON interface is unable to access any NCM tables?