hebron1212 ✭✭✭✭✭

I'm doing this under NPM.

The custom property (just one) already exists. I just need to apply it to each node. I've devised a SQL query to do the work, but a little hesitant to run that in a production environment. So then I thought, maybe I can use a group, but then run into the same issue with the group. I did find a CSV import script in another…

@"sum_giais" Thanks for that suggestion. I realized that after I posted this, which is very helpful. I like that you can get to it via SWQL, also.

Hi, Rich. I'm missing how this is creating a group. This may be a separate question, but I have a similar situation in NPM. I have a list of 100 devices that need to be in a group or custom property added. There is nothing common from them to match on so I need to use their individual names. Group configuration nor custom…

Perhaps this is a support issue, but these sysobjectid's are oddly inconsistent in 2023.1.1. Some have the machine type correct but all other information, including Vendor, blank or unknown. Alternately, they will have all that information except the machine type is generic. 1.3.6.1.4.1.9.1.3079 = Cisco C9200X…

Even Thwack lists are out of order.

That will work, I think. The above pic comes from the bell icon and View all.

Thanks for your quick response. I'll see if I can use groups for this. The following works for counting alerts by node, so if a single node has 5 different alerts, it creates another alert. SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes LEFT JOIN (SELECT COUNT(*) as AlertsPer, AlertActive.TriggeredMessage AS…

Thanks!

My answers as follows: * Orion Platform, NAM, LA: 2020.2.4 * Windows Server 2016 * SWQL Studio 3.1.0.343 (or previously v2.6.0.238-beta) * Windows 8.1 * Authenticating with AD * SIS process by itself was not restarted. * Haven't restarted production MPE server, but our dev system was restarted on Tuesday and it is NOT…

It was opened as an issue almost a year ago. https://github.com/solarwinds/OrionSDK/issues/280. It doesn't appear to have been addressed.

Does that work for you? I tried setting it to 0 and the web UI stopped working. I had to reset the value to 5 via Database Manager to regain access. I ended up setting it to the max, 9999 minutes.

Did this feature ever get anywhere? The links are broken and as of this article, the state appears to be the same: support.solarwinds.com/.../Share-a-Perfstack-Performance-Analysis-project

Has there been any update to this issue? I don't see anything for 2020.2.5 or .6 release notes. Can you provide the full link for the bug fix documentation?

How would I determine the members that are a part of a particular port channel?

To list all the alerts contributing to the rolled up alert, I tried using this in the message, which works in SWQL Studio (where I replaced "${NodeID}" with an actual nodeid). ${N=SWQL;M=SELECT AlertActive.TriggeredMessage FROM Orion.AlertObjects INNER JOIN Orion.AlertActive ON…

I was able to get the alert rollup to work with the following SWQL query. Thanks @"KMSigma.SWI" LEFT JOIN (SELECT COUNT(*) as AlertsPer, AlertActive.TriggeredMessage AS Message, AlertObjects.EntityCaption, AlertObjects.RelatedNodeID AS TheNode FROM Orion.AlertObjects INNER JOIN Orion.AlertActive (nolock=true) AlertActive…

That's one of the things I was considering, assuming that the object can be defined, i.e. all alerts related to node X. So, for example, if that node has a power supply issue and also alerting on syslog errors, a summary alert is raised. We could have the NOC tech search on the node name in the alert window to see the…

Anybody? Did I post this in the wrong forum?

Thanks, KMSigma! I was looking for it at the same level as NCM.

I'm interested in this as well.

Glen, Were you able to figure this out? I have the same need. Thanks. Steve

Thanks, @"mrxinu"! Generally speaking, there is a one-to-one relationship between the node and the mac address listed in the message, if that helps. The node is a wireless controller, and the mac is an AP associated with it, so we could have hundreds of AP's associated with that one controller. So, if the message is for a…

Thanks so much! That really helps. Looks like it's counting all %Max% messages per device, however I do need to narrow it down to a count of unique messages, as is counted in the original query. Is that possible? SELECT COUNT(*) as NumberOfDeauthentications, Message FROM Orion.AlertHistory Where Message like '%Maximum…

How do you enable advanced alerts? I don't have Custom SQL Query listed.

Thanks, @"wluther"! That did the trick!

@"aLTeReGo" This link requires a login. My support login doesn't work. Any way to make it public? Steve

I actually figured out what you meant after I posted. Unfortunately, the OID I'm looking at doesn't have many options for labeling based on column headings, and thus still didn't make sense in the alert. Instead of "unknown" I got a "4" with no context. It would be nice if you could use a different OID for labeling as is…

Can you share how you did this? Thanks.

Thanks! We would rather wait for the general release rather than install the release candidate, which is why we're going with 2019.4. We have a project that is in need of the real-time poller widgets sooner than later. Right now, I just need to understand the necessary steps for doing the staged upgrade, if that is…