tdanner ✭✭✭✭✭

Yes, his AD account needs to be authorized in Orion. Go to Manage Accounts (/Orion/Admin/Accounts/Accounts.aspx) and either add him as an individual Windows user or add a Windows Group that he is a member of.

This fix shipped in Orion Platform 2018.4/NPM 12.4.

Your function is correct for IPv4 addresses. The extra noise in the powershell version is there to correctly handle IPv6 addresses as well.

I got this tracked down. For some reason, that specific verb has a hard-coded timeout of 60 seconds. There's no setting you can change to adjust this - a code change will be needed. At this point, your best bet is to go through support and request a hotfix. Tell them Tim Danner sent you and reference bug 157728.

Ah, I misread the log. It wasn't a couple of minutes into executing the query - it was a couple of minutes into what comes after that query: setting up the chart axes. The algorithm for auto-scaling the chart is getting confused and going into an infinite loop. I have scheduled this bug for SP1. As a workaround you could…

I was about to suggest that you open a feature request, but I see that you just did! Maybe some other dwellers of this forum will bump it.

We have sample code in both of those languages, but much more in PowerShell: OrionSDK/Samples/PowerShell at master · solarwinds/OrionSDK · GitHub

It's a small file. What are they looking for? Incomplete in what sense?

deswhite, Could you open a ticket with support and attach the zip file you get by running Solarwinds Diagnostics (from the "Orion/Advanced Features" section of the start menu)? That will help us figure out how your install got broken. Thanks,

The fix for this issue did not make it into hotfix 2, but it will be fixed in 8.5.1.

It occurs to me that the ProgramData directory is only writable by admins. Are you running SWQL Studio as an admin?

Use "Orion.NodesCustomProperties", not just "NodesCustomProperties".

The Java sample code we had up was pretty anemic, so I reworked it. (Warning - this code is only very lightly tested so far.) I added sample code for several different account management operations. No, you cannot assign the Active Directory groups to Orion accounts. I don't even know what that would mean. You can use the…

The Uri is not the same as the WebUri. Use a query like this: SELECT I.InterfaceID, I.Uri, N.IP_Address FROM Orion.NPM.Interfaces I Join Orion.Nodes N ON N.NodeID=I.NodeID I don't know what environment you are using, but in PowerShell you can delete an object like this: $uri = ... get the uri from somewhere ... $swis =…

Sure. Interface traffic history is in the Orion.NPM.InterfaceTraffic entity. You can query it like this: SELECT DateTime, InAveragebps, InMinbps, InMaxbps, InTotalBytes, InTotalPkts, InAvgUniCastPkts, InMinUniCastPkts, InMaxUniCastPkts, InAvgMultiCastPkts, InMinMultiCastPkts, InMaxMultiCastPkts, OutAveragebps, OutMinbps,…

Here's one that works: SELECT ObjectName, AlertMessage, TriggerTimeStamp, Hour(TriggerTimeStamp) AS UtcHour, Hour(ToLocal(TriggerTimeStamp)) AS LocalHour FROM Orion.AlertStatus

When we introduced the world map feature in 2013, we leveraged a free service from MapQuest that included map tiles and geocoding based on the OpenStreetMap data. At this time, no API key was required for this service. We contacted MapQuest to confirm our understanding of their terms of service: that the Orion world map…

That is really weird. So even after it returns something like "swis://server/Orion/Orion.Pollers/PollerID=526064" when you look in the Pollers table in the database there is no row with that value for PollerID?

We now have an issue in the tracker for API support for unmanaging databases. Better SQL cluster awareness would be a separate topic - you should bring that up in the SAM area (Server & Application Monitor ).

Try this: in System Manager, pick one of the problem interfaces and open the Interface Details window. Clear the Name field and hit Apply. It should automatically fill in the name with the current interface description. Does it? If so, a SQL query like UPDATE Interfaces SET Caption='' will take care of all of your…

I'm sorry this is causing inconvenience for you. It's a consequence of our decision to switch to ASP.NET and it use its user authentication system rather than the home-grown one the old ASP-based website used. It's more secure this way (in the old system, every page had to include some boilerplate "check the login" code or…

The web console does not yet support editing alerts. You still have to go to System Manager for that. I'm curious about how you have your alerts set up. Why do you need to change them every time you add or edit a node?

It is implemented, but the release that has it won't be this year.

What version of Orion are you running?

NPM and NCM are integrated, right? If you run SWQL Studio and connect to your server, do you see the Cirrus.* entries in the tree on the right?

Gob, You can get to custom node properties, but it requires a slightly different syntax. Instead of node.Access, you'll need to write node.CustomProperties["Access"].

Here's a version that gets the node caption instead of just the NodeID: SELECT f.Router.Nodes.Caption, f.RouteDestination, f.CIDR, f.DateTime, f.Ip_Address_Type, f.Ip_Version, f.RouteNextHop FROM Orion.Routing.RoutingTableFlap f This data is unsorted. If you want it sorted, you need to add some ORDER BY clause to the end.…

Bryan, could you post a screenshot of what you mean?

What resources (widgets) do you have on your report? Is it just a table or are there other things?

You can truncate TrapVarBinds (at the expense of losing all of your accumulated trap data). But I would do some investigation and try to see what's sending some many traps. You can either tune that at the source or write some rules in Orion's Trap Viewer to discard traps you don't care about.