mjperkins ✭✭✭✭✭

goodzhere​, you took the words right out of my mouth. It's kludgey, but so long as you are going between two states, setting 'down' as a trigger action on an alert, and 'up' as a reset action works.

mesverrum​ You were correct that the query ran in a Custom Query resource with no modification, just as it did in SWQL Studio. Unfortunately, a resource is not the way to deliver this to the customer asking for it. The customer works with nearly every SolarWinds report he uses by exporting the data to Excel and…

Thanks for helping, dgsmith80​. I am not seeing the inheritances you describe. I don't see an indication of them looking in SWQL Studio. How should I be able to see them? They do not show when expanding the tree in SWQL Studio's left panel or when using the "Generate Select Statement (with Inherited Properties)" command.…

Actually, I tried the query in both SWQL Studio and Database Manager. It errored out in SWQL Studio and returned no records in Database Manager. I should note that expanding the entire tree in Database Manager reveals nothing named LIKE sys.'%whatever%'

Database Manager or SWQL Studio? The query was written for SWQL Studio.

In SQL, the basic NCM information is in NCM_NodesProperties. In SWQL, Cirrus.Nodes and NCM.Nodes both seem to have some data.

ctlswadmin​, I don't think that query can work. The tables "NCM_..." in my system do not appear in SWQL Studio, but only in the (SQL) Database Manager, and there is no "NCM_Nodes" table in either place. Thanks for the suggestion though. As I replied to another comment, I'm currently running NCM 7.3.1. I don't know whether…

I'll just leave this right here ... https://www.si.com/extra-mustard/2015/05/04/batting-stances-craig-counsell-kevin-youkilis-jeff-bagwell-tony-batista

This form of the query fails in both Report Writer ("Query is not valid," like other queries I've tried) and in SWQL Studio. Upon executing this query, SWQL Studio returns errors in the form, "Source entity [NCM_Nodes | NCM_ConfigArchive | StatusInfo] not found in catalog." After correcting the source entity (to [NCM.Nodes…

The objective is to get all live IP addresses in the SolarWinds database, so I am not interested in narrowing the results. I am only trying to get node and interface information to accompany as many of the IP addresses as I can. Said differently, I am only joining other tables to Orion.NodeIPAddresses to add node and…

Thanks for the reply, mesverrum​. The tables you found had information of the right type, but not for each node in the network. While that did not provide the answer, it did steer me toward it. I actually found what I needed in the NodesData table: SELECT Caption, IP_Address, Vendor, MachineType, ObjectSubType,…

NCM 7.3.1

I tried pulling the quotes when I tried replacing the quotes with brackets (suggested earlier in this discussion). It did not work.

I tried both suggestions. Unfortunately, neither worked. Thanks for trying!

It looks like you will need two things: 1. an INNER JOIN section added to the end of the existing FROM clause. It would need to be something like: INNER JOIN Orion.NodesCustomProperties AS OrionNodesCustomProperties ON OrionNodes.NodeID = OrionNodesCustomProperties.NodeID This will add the table with the custom properties…

I'd suggest checking for a couple of things. 1. Are you running SNMPWalk from the polling engine you are using to poll the device? I've seen networks where SNMP traffic was blocked from some boxes but not others. 2. There are a few very basic OIDs that SolarWinds looks for in the Orion Web Console Check: * 1.3.6.1.2.1.1.1…

I would be curious how many of those 'more than a year' nodes are in maintenance until (if memory serves) 12/31/9999. I recall that, when a node is 'permanently' unmanaged or muted, Orion inserts that date as the expiration date. Do you want to be able, or allow customers to permanently mark something as unmanaged/muted?…

Is that one of the F5 products for which Orion can use iControl polling? That might be rather helpful.

@"jblankjblank", I saw the one-line mention in the release notes. Nothing was said about how we are to take advantage of the feature. I have the downloaded .iso, which I presume should be mounted as a drive on the main Orion server. Once the installer is launched from there, is everything just automatically distributed to…

Very happy to give the first kudo to this idea.

This reminded me of a ping-related issue I encountered. My case had some devices showing as unpingable (and therefore down) though pings were successful from a Windows command prompt. It turned out that the default PING / ICMP data size from the command prompt was 32 bytes, but from NPM was only 23 bytes. As from my old…

MIBs and devices can change over time. I would suggest contacting Liebert and confirming that the specific model you are polling uses the OIDs you want to poll. You may need to poll different OIDs.

Do you control group policy objects applied to your servers? It might be worth checking whether GPOs are not allowing the permission fixes or changing them back. It's possible you may need to work with GPOs (and whoever in your organization controls them) to make sure your servers will accept the necessary Windows…

The last polled date-time can be polled. I'm at home without access to the Orion installation(s) I usually work on, so cannot look up the exact table/field. If memory serves, it was in NodesData a/k/a Orion.Nodes. That said, however, I'd still encourage you to create a custom property for Decommissioned on your system.For…

I usually work in a nice padded armchair in my living room with my laptop living up to its name. The camera view is below. Thankfully, there isn't much behind me. I'm not going to show what's behind the laptop's camera.

@"jason.carrier"How do the new MIB processes for checking whether the local MIB needs updating and for updating the local MIB file affect Orion installations not connected to the Internet? Will there still be a place at solarwinds.com to check the most up-to-date MIB and compare it wpith the local one manually? Where will…

If a network is completely cut off -- no internet access -- so we must use offline installers, will one still use this process to upgrade from 2019.x to the full release version of 2020.2? If some manual prestaging will be needed, what will be the details?

@"jblankjblank"It looks like 2020.2 went GA this morning. How is the work going on how to update systems without an Internet connection from 2019.2 to 2020.2?

Did you assign the Universal Device Pollers (UnDPs) to the nodes you want polled? You can do that in the UnDP application on the server or from the Orion Web Console.

Y'all forgot to list the obvious answer: I have taken SolarWinds Academy virtual classes in previous years and this year.