hebron1212 ✭✭✭✭✭

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…

coha​, I actually just want to export the rules as a backup. The last couple of times I've upgraded, rules went missing. It was bearable in pre-prod because we didn't have a lot. Now we do.

Is it possible to count alerts by a time period (e.g. number of reboots in a day for a certain node)? And from that create a new a alert for that node that says "multiple reboots on node X"?

@"wilder" Thanks!

@"mesverrum" Does this require the use of SWCP? I am not familiar with that. Is that the same as the custom properties in the GUI? I am trying to do basically the same thing, joining UnDP data from CustomPollerStatusOnInterface to Orion.NPM.Interfaces.…

Thank you so much, David!