tdanner ✭✭✭✭✭

There are two ways to run a SWQL query over the REST interface: 1. Put the query in the Url as a query string parameter called "query" and make a GET request. 2. Put the query in the request body as the "query" property of a json object and make a POST request. You are mixing these two - you put the query in the Url, but…

If you are working PowerShell, why not use the PowerShell snapin instead of Invoke-WebRequest? If you install the SDK (from http://downloads.solarwinds.com/solarwinds/Release/Orion/OrionSDK-v1.10.zip or (beta) Releases · solarwinds/OrionSDK · GitHub), then you can delete a node with Remove-SwisObject.

Yes, that is the right URL.

You only need to delete the node. All dependent information (pollers, child objects like interfaces and volumes, historical statistics, etc.) will be deleted automatically. Some of it will be deleted immediately and the rest will get cleaned up when nightly database maintenance runs.

v2 does not support the JSON API - you have to use SOAP if you want to use v2.

The POST query failed because you need a "Content-Type: application/json" request header. The GET query failed because Orion.Alerts does not have a property called "AlertName". I recommend you use SWQL Studio to explore the entity types and their properties.

The Content-Type should be "application/json", and the payload should be this: { "query": "SELECT Caption FROM Orion.Nodes WHERE NodeID=1" } You don't need the cookie, but I suspect that was added by the Chrome extension you are using. What URL are you POSTing to? It should be…

Here's a quick and dirty C# client that does queries. Hopefully that will be enough to get you started.

More info: Alerts · solarwinds/OrionSDK Wiki · GitHub

The NetworkNode property is the NodeID value, so you can join to the Orion.Nodes entity to get other node properties. Like this: SELECT o.TimeLoggedUtc, o.AccountID, o.ActionTypeID, o.AuditEventMessage, o.NetworkNode, n.DisplayName, o.NetObjectID, o.AuditingActionType.ActionTypeDisplayNameFROM Orion.AuditingEvents oLEFT…

Try putting an ORDER BY clause on it.

Orion should fill in the SysObjectID from SNMP data once it runs rediscovery on the new node. To fill in IPAddressGUID, you can use this PowerShell function: function ip2guid($ipString) { $ip = [System.Net.IPAddress]::Parse($ipString) $src = $ip.GetAddressBytes(); $data = new-object byte[] 16 $src.CopyTo($data,…

If Richard's list of properties (earlier in this thread) does not fix it, here's what I would do: 1. Add a node using your script. At this point (per your description) there will problems with this node in the web. 2. Call Read on the resulting uri to get a dump of the properties as the currently are. 3. In the web, click…

There are some other properties you need to include for this to work properly. Please see the "Adding a node for monitoring" section in the Technical Reference (Orion SDK.pdf) document. Please also see the Samples\PowerShell\CRUD.AddNode.ps1 script under the SDK installation directory for sample code that does this.

Could you tell us a bit more about your web setup? Are you using pass through authentication or SSL? Is IIS listening on all IP addresses or just a specific one? What port?

The entities available in SWQL expose data from multiple sources. Most are backed by SQL tables or views, but some come from other sources.

Sorry - VNQM roadmap stuff is not something I can help you with. Just keep asking ding​.

This page has instructions for setting up Install-Module on various versions of PowerShell: https://docs.microsoft.com/en-us/powershell/gallery/installing-psget

This may save you some guesswork in the future: SWQL Functions · solarwinds/OrionSDK Wiki · GitHub

I can't give you an ETA, but I can tell you that we are looking at options to get that sorted out sooner rather than later. I will be sure to post in this forum when we have something for you.

Yes, version 2.5 of the SDK will take care of installing the module for you. You can either install that beta (maybe you already have) or use the method at the top of https://github.com/solarwinds/OrionSDK/wiki/PowerShell > To install this module from the PowerShell Gallery, use Install-Module -Name SwisPowerShell. You'll…

That query should do it. What error are you getting?

I'm glad you found your answer. Your question motivated me to promote this to a wiki page: https://github.com/solarwinds/OrionSDK/wiki/Uris#system-identifier

The only required headers are: 1. "Content-Type: application/json" (if this is missing you will get a 500 response with a message about "unexpected message format 'Raw'") 2. "Authorization: Basic XXXXXX" If this is missing you will get 401 Unauthorized. If the credentials are wrong, you will get 403 Forbidden. We had a…

In a trap action, you can use variables via the ${variablename} syntax. The values of the trap OIDs are available as ${vbData1}, ${vbData2}, ${vbData3}, etc., according to the order these OIDs appear in the trap. ("vb" stands for "var bind" which is what the OIDs in a trap are called.)

Not on the grid itself, but if you click on an alert (any column except "network object"), the Nodes field will show up in the popup.

Honza, that is for query parameters, which is separate from entity parameters. I'll ping the NTA team to provide the details Simon needs.

Once it is deleted from there, nightly database maintenance will clean up data connected to deleted nodes in related tables later.

Thanks, Marc. I would also recommend looking through the GitHub wiki: https://github.com/solarwinds/OrionSDK/wiki

This verb is only supported on SNMP nodes.