smalleggo ✭✭✭✭✭

Program Files (x86)\SolarWinds\Orion\SEUM\Player SolarWinds.SEUM.AgentDomainConfigurationTool.exe

This would be nice to have due to our Agency requesting this over WMI.

Is there any update to this request? I know the request has been out there for a while. Thank you

The issue appears to be needing to change the ${nodeID} to the ${N=SwisEntity;M=NodeID} Good catch @"Lofstrand" For whatever reason this seems to have resolve the issue. I'll need to dig into it and determine why that is the case. Good catch and much appreciated. Thank you everyone for looking into this. Plan is to post…

Sure thing. I always appreciate someone taking their time to look over things. It's my first dive into custom SWQL alerting so took me ages to get this far. Firewall Connections over 90% on ${N=SwisEntity;M=Caption} at ${N=Alerting;M=AlertTriggerTime;F=DateTime} Firewall Connections over 90% on ${N=SwisEntity;M=Caption}…

Sorry, I have attempted both ways as shown below. This same query works without issue on the dashboard or going against the DB itself. The issue is specifically the email body which has other variables working. The NodeID is the ${NodeID} variable so you can see that SolarWinds is reading the text, just not the script…

I've made it super simple in the attempt to get it to display. Doing the SELECT into a widget displays the single number I am expecting however the email using SQL/SWQL and <p> </p> provides the result below. Interesting that the ${NodeID} adjusts the right NodeID but the rest does not run. Looking at SDK, CP, and pulling…

That makes sense to me. I figured it was something like that. What you provided helps however one of the interfaces is a trunk with no IP address so I need to figure out a different table in this instance as there is not InterfaceIndex related to it. Might need to add at least two JOIN statements to get this working.

Everything works if I remove the IPAddress and SubnetMask SELECT statements which correctly shows the two interfaces I am filtering against. Once I add either of those SELECT statements I get the 70-90 results. For reference the Interface Details page for each shows either the single IP address or an Unknown. I can get the…

Thank you.. For some reason I was not getting the result I was looking for. I found the correct information from what you provided.

Looks to be a fault in our system that day as it now provides the roughly 920 actions as I expected. Our system says it has 924 actions related to Email however your script provides 918 while my script shows 930. I believe using both I have validated we 'should' be good.

For some reason this truncates the results in either a widget or report. I'll need to look into the PropertyValue as it looks like the location of what I am trying to collect.

Running into the same issue (Environment - 9.8k Nodes) with 13 additonal pollers. Came across this thread after searching before the upgrade from 2022.4.1 and once we started having issues. Case # 01685921, 01384905, 01380494, 01383073 all related to the 2023.2 HCO upgrade or bugs after. Our licenses expire on 7/1 so…

You would be correct. It's a DB that is not associated with SW so SWQL would not work in this case. The attempt is to provide data from an application but I believe I'll need to go another way about it. Everything I've read/seen shows that SWQL is the only option. I can create a report using SQL and display the report on a…

That is what I am looking for! Thank you for taking a look at this. I have a few more that I will post here that I am sure will be similar issues. I am so grateful for this ability to get better at SQL because I'll be the first to admit I am taking it line by line. After working this into my Dashboard I did have to add the…

Here is the result from SWQL Studio.

Anyway I can get the filtered SWQL code for this? @"dunky2k" I can get some information from the SWQL but it keeps throwing NULL errors when I attempt to get the Node Name.

I submitted a new ticket based on this. From what Solarwinds and I looked into we believe it has something to do with the site. Thank you for the response!

Is there any update with this issue? We have a website that we are getting the same error on and I'm stuck at the troubleshooting wall. Thank you,

You are correct about that. I have it checked for every minute along with the default for the application monitor put at 60 seconds. Those two alone would put it at two minutes after however this still is 8 minutes+ beyond what it is setup for. Like I said, the application event shows the change right away to critical in…

Share away! The more information about this the better! I am starting down a different path but it's possible that what you've written may be better than my current plan. Thank you,

Sounds like a great idea. I'm in.

Thank you for your help. Is there anyway you could give me an example of the second process, more than you have already. I understand HTML however within Solarwinds I am a bit lost on what you are saying. The "HTML_text" is what I want the link to show, the "HTML_link" is the website I am going to but what are the " "…

That is what I have thought as well. I do not know why the events are showing one thing and the alert does not actually trigger until well after. Regarding the cache, I have had multiple people try to see this when the event occurs, all from different computers/browsers, and they see the same thing related to the timing.…

An update. We moved our Database off the Solarwinds Server, I tweaked the Alert and it works now. Not sure if the Server was just too busy or what but I appreciate your help on this marunderwood. The Alert itself is set for anything above 90% for more than 10 seconds which I'll eventually change to be longer. It is setup…

Thank you, I'll be taking a look at this Alert tomorrow and respond if I have any questions. Understandable about scrubbing it but other then that it should make sense.

Thank you everyone who looked at this. We are still working with the end user and attempting PERL scripting. I will let you know what the outcome is. Charlie

What does the Alert look like? I would say more information and someone will be able to help you solve the issue.