tdanner ✭✭✭✭✭

An ICMP node does not have SNMP credentials assigned, so those other pollers won't work. You might see some errors in the logs. I generally recommend using the Discovery API (Discovery · solarwinds/OrionSDK Wiki · GitHub) to let the system figure out which pollers apply for a given node.

How about something like this? select AgentIP from Cirrus.Nodes where NodeId not in (select NodeId from Cirrus.ConfigArchive)

Can you post the query that is not returning the expected results?

I bet this is a 32-bit vs. 64-bit issue. You can run powershell as a 32-bit process or a 64-bit process, but the snapin registries for these two modes are separate. If you registered SwisPowerShell.dll using the 32-bit version of installutil.exe, it will only be accessible in a 32-bit PowerShell process. Did you register…

It is possible to import an alert through the SDK. This can be used to copy alert definitions from one Orion system to another programmatically. But there is no friendly API for creating new alert definitions. What are you trying to accomplish?

The problem is that "/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:$NodeID" is not a SWIS Uri. That's a relative web address. A SWIS Uri looks like this: "swis://server/Orion/Orion.Nodes/NodeID=123". You can get the correct uri for a node like this: $NodeUri = Get-SwisData $swis "SELECT Uri FROM Orion.Nodes WHERE…

SWQL Studio needs complex argument values in XML format. In XML, the & character must be encoded as & or the XML is malformed. In this case, I would expect SWQL Studio to give a decent error message, but what you actually got was an ugly unhandled exception. I opened https://github.com/solarwinds/OrionSDK/issues/107 to…

Get-SwisData returns the data to PowerShell differently depending on whether there is one column or more than one column in the result set. If there is a single column, then it returns the values in that column "naked". This works well if you want to treat them as a simple list of values. It also works well for the case…

Looking at the code, I can see two possible causes for this error: 1. No node with that NodeID value exists. You already indicated that one does exist. 2. The node is not an SNMP node in Orion. Could this be the problem in your case?

Do you have a Corporate_Routers_Switches custom property for nodes? You have a node tree resource that is configured to group by this property, but it appears that it isn't in your database. I would try either creating a property with that name or edit the view and remove that node tree. You could then add a replacement…

You are hitting this bug: 400 Client Error: Specified cast is not valid · Issue #9 · solarwinds/orionsdk-python · GitHub . Unfortunately there is no workaround for this operation in the REST API. If PowerShell is an option for you, it works there. This bug is fixed in NPM 12.2, currently in beta.

The API documentation is here: Home · solarwinds/OrionSDK Wiki · GitHub and here: SolarWinds Information Service v3.0 Schema Documentation Index. What are you looking for? I might be able to point you to the right place.

Could you post a query that demonstrates the problem? The first couple of things I tried worked. Granted, the SAM database I have handy to test with is pretty basic.

Will the LastSystemUpTimePollUtc property work for you? This is the time of the last successful poll of the device. That would make for a simpler query than finding the most recent event.

What Zone does IE report for Orion? It should be on the right side of the browser status bar.

Here's some discussion of how to handle this on Stack Overflow: pip - Python Packages Offline Installation - Stack Overflow The orionsdk package for python is here: orionsdk 0.0.6 : Python Package Index It depends on 'requests' and 'six', which are here: requests 2.18.4 : Python Package Index and here: six 1.11.0 : Python…

These tables are not available through the API at this time. I entered a feature request to have them added. It's #248180 if you want to check on it.

You have several options: * Just link to a standalone web page. Using "Customize Menu Bars" in the admin section, you can just put any arbitrary link on a menu bar. * You can use the "External Websites" feature to link to your visio map. This will also create a link on the menu bar, but the visio map will be loaded below…

Because of a technical issue with the WSDL, Visual Studio's "Add Service Reference" process generates a client that won't actually work for creating a node. This issue has been addressed for the release in development now. Until then, I recommend you use PowerShell for creating nodes. If you'd like, you can drive…

The Custom SWQL Resource adds a "WITH ROWS" clause to queries to do paging of the result set. The problem is that in SWQL this clause is only valid after an ORDER BY clause, since paging only makes sense when the order of the result set has been specified. Try adding an ORDER BY clause (like "ORDER BY EntityUri") to the…

You can use pretty much anything and your choice should be informed by considerations of the larger system you are trying to build. But if you just want a recommendation and you are working on Windows, I'd start with PowerShell.

Here's the query used to feed that resource. Some additional work would be needed to make the formatting close to what that resource uses. SELECT VirtualServerID, LTMPool.Name as PoolName, LTMPool.ShortName as PoolShortName, LTMPool.DetailsUrl AS PoolDetailsUrl, VServer.Name, VServer.ShortName, VServer.NodeID,…

You'll probably have to use an Advanced SQL Report to get this done. Look at the Pollers table. Interfaces that have Poller_IT have traffic monitoring. Interfaces that have Poller_IE have errors&discards monitoring.

How about this? SELECT top 10 NodeID, IPAddress, DNS, LastBoot, DAYDIFF('1970-1-1',AddSecond(SystemUpTime, '1970-1-1')) AS Days, HOUR(AddSecond(SystemUpTime, '1970-1-1')) AS Hours, MINUTE(AddSecond(SystemUpTime, '1970-1-1')) AS Mins, SECOND(AddSecond(SystemUpTime, '1970-1-1')) AS SecsFROM Orion.Nodes

Have you tried https://github.com/solarwinds/OrionSDK/wiki/NTA-4.0-Entity-Model​ ?

I believe the ssl_opts thing is from libwww-perl, which probably comes with Perl. Version 5.10 is kind of old (2007, I think). I also know that libwww-perl used to not validate hostnames by default, which is probably why commenting out that line works for you. Unless you are planning to update your perl setup, I would just…

This API does not support setting custom properties at the time of node creation. You need to create the node without custom properties, then set the custom properties by taking the node Uri returned from .../Create/Orion.Nodes and appending "/CustomProperties" and POSTing your custom property values to that url.

This verb is primarily intended for the custom property management UI to provide feedback to users. It checks to see whether a given name is suitable for creating a custom property. It does not actually create a custom property or make any changes to the system. The parameters for the verb are: string PropertyName - name…

Maybe someone else will jump in and correct me, but I don't think it's possible to build this suppression. Suppression works by letting you specify a query; if that query matches any nodes, then the alert is suppressed (i.e., not triggered). But what you need for this purpose is a query that checks the state of two nodes.

You can find out the NCM role defined for all users with this query: SELECT AccountID, SettingValue FROM Orion.WebUserSettings WHERE SettingName='NCM.NCMAccountRole'