tdanner ✭✭✭✭✭

I should have included more detail in my previous reply. The Custom Query resource always adds a "WITH ROWS x TO y" clause to the end of your query to support paging through the resultset. In SWQL, the WITH ROWS clause can only be used in combination with "ORDER BY", since paging doesn't make any sense when there isn't a…

I looked into this. There are two problems at work here. The first one prevents macros from working with Groups on Network Atlas maps at all. Even generic ones like ${Caption} don't work. The second one prevents custom properties from being part of the macro set for Groups even if I work around the first bug.

Shoot - that's exactly the scenario I thought we had fixed. Can you open a GitHub issue for this? Issues · solarwinds/OrionSDK · GitHub . It would help to attach the SWQL Studio log, or at least the part showing the problem. You can find it at C:\ProgramData\Application Data\SolarWinds\Logs\SwqlStudio.log

What version(s) of Orion are you using? You might be able to work around the missing "Events" navigation property by using a LEFT JOIN instead. Like this: Select N.Caption, N.CustomProperties.Base as Location, N.CustomProperties.Tower, N.CustomProperties.Comments, ToString(DayDiff(0,GETUTCDATE() - MAX(NEvents.EventTime)))…

Here's an option that doesn't require logging in as the new user: when you create the view for the new user, click the Preview button to open that view. Then (still logged in as the admin) click Edit on the map resource and select the map you want the user to see.

CPU and memory are in Orion.CPULoad Network traffic is in Orion.NPM.InterfaceTraffic Storage is in Orion.VolumePerformanceHistory

In a custom query resource on a Node Details view, you can use the ${NodeID} macro to filter. Try adding this to the WHERE clause: AND NodeID=${NodeID}

We feel your pain. Searching in web node management, edit node (and unmanage) directly from the Node Details page, and improved web node management performance are all coming in the next release.

No, it happens in the background.

A curious omission that I have now fixed. SWQL Functions · solarwinds/OrionSDK Wiki · GitHub Please let me know if the descriptions need enhancing or examples added.

Yossarian​ was fast on the draw with a pull request, so I published v2.3.33-beta if you want to try a SWQL Studio with tab close buttons. https://github.com/solarwinds/OrionSDK/releases/tag/v2.3.33-beta

You probably want to watch the KeepAlive column in the Engines table. The poller updates that regularly when the database connection is ok.

No, it is not.

You are correct about the correspondence of the DefinitionId->AlertDefID, ObjectType->ObjectType, and ObjectId->ActiveObject, but it doesn't look like your code really reflects that. You have hard-coded "APM: Application" as the ObjectType, but put $NodeID as the ObjectId. If the ObjectType is "APM: Application", the…

Can you use the "+0" method to convert your "03"-style numbers into integers so they can be directly compared with the return value of MINUTE()?

NPM 9.1 did not have node groups. In those versions users generally used custom properties for ad hoc node grouping. I don't think using the SDK to do the initial import would really buy you anything. Better to just copy the IP address list and let discovery handle the initial import. By default, discovery will import all…

Documentation for the new alerting entities has been posted at https://github.com/solarwinds/OrionSDK/wiki/Alerts. (The SDK is moving to Github - see Orion SDK moving to Github.)

Yes, these things are configurable. I recommend you check out the Advanced Alerts section in the Administrator Guide: http://www.solarwinds.com/documentation/en/flarehelp/orionplatform/#orioncoreagusingorionadvancedalerts.htm%3FTocPath%3D…

Thanks for sharing!

curl -v -k -u admin: -X POST -H "Content-Type: application/json" -d @postdata.json https://localhost:17778/SolarWinds/InformationService/v3/Json/Query Where the file postdata.json contains something like this: { "query": "SELECT TOP 1 DisplayName, DetailsUrl FROM Orion.Nodes" }

The ToLocal function is in NPM 10.5. It doesn't matter what version of the SDK you use.

NPM has an API for pulling information out. You can download the documentation for this API right from this page. What you do with the data after you have extracted it is up to you.

Here's a minor enhancement to that query: SELECT Nodes.NodeID, Nodes.Caption FROM Orion.Nodes LEFT JOIN Orion.ContainerMembers ON ContainerMembers.MemberPrimaryID=Nodes.NodeID AND MemberEntityType='Orion.Nodes' WHERE ContainerMembers.ContainerID IS NULL You need to check MemberEntityType. If MemberEntityType is not…

To set a custom property: $uri = Get-SwisData $swis "SELECT Uri FROM Orion.NodesCustomProperties WHERE NodeID=@nodeid" @{nodeid=$nodeid} Set-SwisObject $swis $uri @{MonitoringState="Silenced"}

For SNMPv3 with a saved credential set, I recommend using the discovery API to add a node. Here's a sample: https://github.com/solarwinds/orionsdk-python/blob/master/samples/discover_one_node.py

Oops - I just noticed two things: first, that I asked you to look in the SWISv3 log file when I should have specified the SWISv2 log file. The path should be C:\ProgramData\Solarwinds\InformationService\v2.0. Second, that you did find the error in the SWISv3 log file showing that you used this URL for your request:…

Strange. Could you tell me more about your NCM deployment? What version of NCM, how many servers, which components on each server, etc.

I think I have a possible workaround for this issue. Check the default language for the SQL login used by Orion. In SQL 2005, you can do this using SQL Management Studio. Expand Security/Logins and open the Properties for the login Orion uses: Set the language to one whose short date format (US English uses month/day/year,…

It is supposed to auto-update interface captions. The caption is generated by a slightly complicated set of precedence rules involving the interface description, interface alias, and (for CatOS) the port name. And of course you are free to set the interface caption in Orion to whatever you want. When we detect a change to…

In SWQL Studio, are you connected to the "Orion (v3)" endpoint?