tdanner ✭✭✭✭✭

Not really. If a device is already managed as a node and you just want to check its status immediately instead of waiting for the next polling cycle, you can invoke the Orion.Nodes.PollNow verb. But there is no facility for doing ping or snmp to arbitrary IPs.

Your code for adding pollers looks ok. Can you post your code for adding the node? "null" is the expected response from PollNow. It returns immediately - it doesn't wait for the polling to complete.

This is not something that is supported by the API at this time. If you wanted to hack it in, you could probably come up with a table insert statement that would work. That method may break in a future version - those table schemas may change in the future.

While there is nothing stopping you from creating additional tables in the Orion database, there is no way to add them to SWIS. If you need to access SQL data from your PowerShell scripts (whether in the Orion SQL database or any other SQL database), you can use Microsoft's "Invoke-Sqlcmd" cmdlet.

The only way you can have an icon on a map represent more than one node is if it links to another map. That submap doesn't have to be fancy - you could just throw the nodes onto it with no background and call it good. You would still see the table of nodes below the map when you click through. Maybe this will get to what…

You are SELECTing the timestamp truncated to the hour, but you are GROUPing BY the raw timestamp. Change the GROUP BY clause to this: GROUP BY N.Caption , CP.City, DateTrunc('hour', CPS.DateTime), CPA.AssignmentName

You should be able to add the chart to the view by editing the view. There's a little edit link in the upper right of the interface details page.

There's a preference for this in Web Console Settings on the admin page in the website. It's called "Status Rollup Mode" and the options are "Show Worst Status" (the new 9.1 default) and "Mixed Status shows Warning" (the old behavior). It affects both maps and the node tree.

Could you give a little more information on what you are trying to do?

The Orion website uses a regular HTML form for authentication. If you send a POST with the right values as form data, the response will provide you with a valid session cookie. Could I ask why you want to do this?

The current release of the Orion SDK is not 1.9; it's 2.1 - Releases · solarwinds/OrionSDK · GitHub The information from that PDF has been moved to the GitHub wiki and expanded. I recommend you rely on that instead of the pdf. Home · solarwinds/OrionSDK Wiki · GitHub

This is not supported. Also, this code: var client = new InformationServiceClient("BasicHttpBinding_InformationService", string.Format("https://{0}:17778/SolarWinds/InformationService/v3/OrionBasic", hostname)); Will connect you to the SOAP API, not the REST one.

In a typical production environment, the amount of data you are talking about can be extremely large. A GUI tool like SWQL Studio would choke on that data just loading it into the grid even if the query itself didn't timeout. If you want to export all of your flow data, I recommend trying a different approach: iterate…

There's something strange going on. Normally a custom property update should be quick, but the previous log line reports that an update operation took 23 seconds. I can't tell if that is the same operation or not, since the "error executing update operation" line is 8 minutes later. Is there a stack trace for that error in…

Orion.Alerts has information about the configuration of your alerts - the criteria to look for. Specifically Basic Alerts. In this context, StartTime and EndTime mean "this alert definition should be active between StartTime and EndTime". And yes, those 1899 dates are placeholders that just mean "any time".…

You should open a support ticket for this one.

Doesn't DATETRUNC('minute', CPULoad.DateTime) do what you need? You said "WHAT I WOULD LIKE IS TO ROUND THE DATETIME TO THE NEAREST MINUTE IN A SWIS QUERY TO PASS THE DATA TO A DISPLAY PACKAGE." - this is exactly what DATETRUNC does.

What you are looking for makes sense, but there is currently no way to configure the system this way, even with custom scripting.

I'm not entirely sure what mean by "proxy device" and "proxy address" in this context. Does the address in question appear anywhere in the Orion UI? If so, I can help you track down where it shows up in the API.

It's the same as creating any other group, just without bothering to add any members. You can see the CreateContainer call with lots of comments in this sample: https://github.com/solarwinds/OrionSDK/blob/master/Samples/PowerShell/Groups.ps1 Here's a one-liner for creating an empty group: Invoke-SwisVerb $swis…

Yes, that's not good. We've seen issues with some other customers using SQL on a SAN. Their SAN was tuned for read performance, not large numbers of writes. But Orion's data access pattern (probably the access pattern for any normal database-backed polling engine) is lots of small writes. I don't know whether that's what's…

Can you show more of your code? How is "arguments2" constructed? Also, it looks like you are using XML, which implies that you are using the SOAP endpoint from C#. You might find it easier to work with the JSON endpoint.

Calling from javascript directly to SWIS on port 17778 is not going to work. SWIS uses a self-signed certificate, so the browser will not like it. SWIS uses HTTP Basic authentication, so you would need the user's password. There's a web service endpoint within the Orion website that you could use instead. It's not…

IPAM does not currently offer a programmatic interface for manipulating DHCP leases, only querying them.

The PIVOT syntax has not been added to SWQL. But if you describe your use case in more detail, we might be able to find something workable.

GroupPriority seems to be missing from the SWIS schema for no good reason. I'll open a bug to get it added.

It's not a buffer overflow in the "security problem" sense, but it does look like we are trying to query the database using a date format it isn't expecting. I'm guessing we're either sending it month/day/year when it expects day/month/year or vice versa.

You should open a support ticket for this one too. Orion.NPM.CustomPollerAssignmentOnNode.CustomPollerAssignmentID is a GUID (uniqueidentifier), not an int. But SolarWinds.Orion.Core.BusinessLayer.DAL.AlertDAL.LoadSwisUris() is trying to compare it to an int for some reason.

No, this is not supported by the SAM API today.

You can use the "WITH ROWS" clause to page through SWQL results. Like this: SELECT NodeID, Status, Caption FROM Orion.Nodes ORDER BY NodeID WITH ROWS 1 TO 1000