tdanner ✭✭✭✭✭

The "Credentials" field should be a list of objects with two properties: CredentialID and Order. Like this: CredIDs = [ {'CredentialID': 41, 'Order': 1}, {'CredentialID': 42, 'Order': 2} ] etc.

I figured out what's going on. Through a somewhat complicated chain of indirect effects, deleting an interface through the API leads to that interface's NodeID getting added to the DeletedNodes table, which database maintenance uses to delete child objects of that node, including interfaces. To work around this issue,…

I got some more details from Caroline Toomey that change the picture somewhat. According to her summary, what you are seeing is that immediately after the script runs, things are in the expected state. But then after database maintenance runs, more interfaces get deleted. In light of that, let's hold off on gathering a…

If the problem can't be reproduced with a subset of the data, this is going to be tricky. To investigate this further, I need an Information Service log file at DEBUG level the covers the time period the script ran. Since this is processing thousands of interfaces, that file is going to be enormous, though highly…

I think your problem is on parameter 5. "null" is a valid Dictionary and it is a valid string, but it is not a valid boolean. Try passing false instead. If that doesn't work, please post whatever error response you get.

It looks like you have a stray } character on line 79 of Add-CustomProperty.ps1. Does it still work with that there?

Oh! I didn't catch that it was only returning a single row. That's very strange. It should return one row for each node. What do you get with other queries? Like "SELECT NodeID FROM Orion.Nodes". What do you get when you do "SELECT Uri FROM Orion.Nodes" in SWQL Studio instead?

I see what's going on. The "Service Pack" line right below "Operating System" actually refers to the Windows SP level, not the Orion SP level. And the "Package" line is referring specifically to the display name of the SolarWinds license key installed on that server. We only normally only change the license keys for major…

Looks like we didn't get all the details. You may have set the log level for "Information Service 3.0 - SQL" instead of "Information Service 3.0". When it works, there will be a lot of logging - hundreds of lines.

When you use the "Log the Alert to the NetPerfMon Event Log" action, a message will be written to the database. You can query for it through SWIS using the Orion.Events entity.

This is not currently planned. You could raise the visibility with a feature request here: Network Performance Monitor Feature Requests

The CRUD API for adding nodes works best when you are adding consistent node types. With this API you are responsible for knowing what poller types to assign (there are a lot - see Poller Types · solarwinds/OrionSDK Wiki · GitHub). With the Discovery API (Discovery · solarwinds/OrionSDK Wiki · GitHub) Orion will take care…

Yes.

A 500 error with no details in the log is unexpected. Your URL looks fine. Authentication is regular HTTP Basic auth. You do need to send a "Content-Type: application/json" header, but if you miss that I think you get a different error. What tool are you using to send the request?

No, this API does not cover passwords in NCM connection profiles.

Ok, it looks like the city is also the name of the group. Here's query that will get all of the IP addresses, their status, and the name of the subnet's group's group: SELECT DISTINCT TOP 1000 I.IPAddress, I.Status, G2.FriendlyName FROM IPAM.IPNode I LEFT JOIN IPAM.GroupNode G1 ON I.Subnet.ParentId=G1.GroupId LEFT JOIN…

Now, wit that said.... why did moving the function _jason_serial(obj) out of the class SwisClient fix the issue (for Python 2.x)? I'm not sure. I'm not an everyday Python programmer and my understanding of the differences in the scoping rules between 2 and 3 is a little hazy. The error suggested some scope confusion, so I…

That should still work. Are you getting any errors from these commands? It would be very strange for "New-SwisObject Orion.Volumes" to "succeed" but not have actually created the record.

I'm glad you find it helpful. But I do need to caution you that this does not mean we can support whatever-you-use-this-for in general. It's undocumented for a reason - our database schema may change from version to version. I recommend you plan on removing this workaround once we publish a proper fix for this custom…

Those steps sound right to me.

IPAM's API is read-only. You can query things, but not make any changes. Including marking an IP address as in-use. Outside of IP address management, many features of the product can be automated through the API. You can see some of these at https://github.com/solarwinds/OrionSDK/wiki.

You should be able to copy CirrusCoreSchema.xml and CirrusReportSchema.xml from C:\Program Files (x86)\SolarWinds\Orion\Information Service\2.0\Schemas on the main server to the same directory on the Additional Web Server to get NCM SWISv2 queries working on the AWS. Verbs will not work, just queries. NCM SWISv2 is…

Is <polling_engine_hostname> reachable by that name from this system? If you do "ping <polling_engine_hostname>" from the command line, does it work?

1. You can reset the admin password to blank by going to the Accounts table in the database and deleting the encrypted Password for that account. 2. We leave that out to reduce the download size. You can download it separately directly from Microsoft. We do ship a simple database tool that you can find on the Start menu…

I'm glad it worked! However, that extra step really shouldn't have been necessary. Could you send me all of the ConfigurationWizard.log* files in your Program Files\SolarWinds\Orion directory? I'd like to see what went wrong.

On the Edit page for that Custom Query resource, check the "Enable search" box and provide a modified query that incorporates the ${SEARCH_STRING} macro. Like this:

¿Es ese el primer error en la salida?

SWQL Studio gives me an error ("SolarWinds.Data.Query.EntityNotFoundException: Source entity [IPAM.IPNode] not found in catalog") and shows none of the tables (or entities) listed in the aforementioned document Is SWQL Studio connected to SWISv3 or SWISv2?

"The $credentialIId variable above has a value of an array of numbers" That would be a problem. There should be just one number. Try printing it out from the script and see what it looks like. If there's more than one credential with the same name, you would need to add "TOP 1" to the "SELECT ID FROM Orion.Credential ..."…

I don't know of any publicly available DLL wrapper for the service reference. However, Michael Halpin published a PowerShell module with some higher-level functionality. See PowerShell Module based on the SDK for details.