sum_giais

EDIT: The queries below only look at manual transfer results and NOT results run from a job. Try giving this query a shot. I'd recommend building a custom SWQL alert for this condition. Hope this help sir! Below are 2 similar queries. The 1st is the query in a format that you could leverage within SWQL studio and/or…

Thia is a great idea, and I like the thought of classes. I'm in SWQL studio daily, always building queries so it'd be fun to see how SolarWinds, the community, and/or Thwack MVP's could all contribute. I'd like to help in some fashion if possible. I've put a bunch of queries of my own out in the Content…

I would check a few things myself: - Review the Transaction Log sizes of your database https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-sqlperf-transact-sql?view=sql-server-ver15 - Check Activity Monitor in SSMS, it can give some insight into long running / hung / dead-locked processes and queries…

Any change if you restart the agent on those nodes?

Interesting. If you edit the agents that are out of date, are they configured to be allowed to auto-update? If they show out of date and aren't showing as update needed, I'd think that's a bug of some sort. What version of SolarWinds Orion are you on, and have you considered opening a Support Case on that issue?

I've seen this issue before when migrating agent managed nodes between engines in bulk as well. I believe it's a bug in the code to be honest but haven't had to time to replicate and reproduce for a support case. I could only get the issue to occur when doing the change in bulk and I wasn't doing that frequently. The issue…

Don't believe so, think they're still global settings within SolarWinds Orion.

You could use SWQL Studio to run the following query that should get that data for you. The query assumes the alert configurations contain the text "F5" within the names. Adjust accordingly. SELECT ac.Name ,ac.AlertMessage ,ac.ObjectType ,ac.AlertID ,ac.AlertRefID ,ac.Enabled FROM Orion.AlertConfigurations AS ac WHERE…

I'm not aware of a work around and I wouldn't doubt that there's a feature request somewhere out here on Thwack for just this... that said you COULD (while not ideal) create a group and add any UnDPs you may have to that group, then add that group to the orion map.

Case submitted sent you the case #. Also was able to use your workaround in my template, nice!

Thanks for the workaround @"KMSigma.SWI". I'll happily put a ticket in for SolarWinds on this if nobody has yet. I just noticed this last week when building a team dashboard template based off @"jm_sysadmin"'s template.

Hi @"jon.b", note that article linked above is for your web console certificate which is unrelated to the code signing certificate revocation that occurred last year. As @"jm_sysadmin" mentioned you don't need to gut the environment, you've got options. I myself would stand up a new set of servers (1 for the database, 1…

Hello @"lesher_tim", GitHub is a great place to start. I'd refer you to other documentation and perhaps videos as well however I'm unsure of which OS / scripting language you're seeking to utilize. There's example scripts already up on GitHub and plenty of documentation, as well as many supporting articles within this…

Sounds to me like a scheduled report with an email action would work. There's other ways to do it for sure but this I think would be the simplest and most effective. Doesn't seem like it should be categorized as an 'alert'. That said you mention 'for a server that is up'... so are you expecting this would ONLY be sent if…

Was planning on sharing this already and thought it'd be worth mentioning this query here. Essentially the same thing you put together, slightly different and with an additional query to update the email subject as well but I also had to run through this in bulk and directly in the database is the only way (sadly.)…

I think for the intended result since one would always show down, you may want the group rollup type of show best status. That way as long as one IP of the device is responding the group would show up.

I'm not very familiar with the VMware CLI in powershell but are you looking to script out simply shutting down the servers and then starting them back up?

I'm not aware of any official documentation that speaks to this however I do know that there's some documentation that speaks to pieces of it. You're on the right track though. Shutdown: (Note: Startup is exact opposite) * Pause all Orion alerts if desired * Disable HA (High Availability) * Stop services and/or shutdown…

Hey there, I see the frustration with the 'setup' SELECT statements... I have had sometimes found ways to better the query without that restriction. That said when you think about it and take the time to revise your query its not all that difficult to join in what you need. If I had to hazard a guess... the preexisting and…

Hey I have used this functionality ... I'll pull up and provide real quick what I did for this. I think you're just using the wrong variable. Should be ${N=Alerting;M=AlertID} and not ${N=Alerting;M=AlertActiveID}. Also note I'm not adding single quotes around that variable as it's an integer. Additionally though keep in…

If you want the status to reflect the actual child status (e.g. an application goes critical and the node should show critical) then you need to use enhanced node status calculation. Are you using classic or enhanced for node status? Check this in Settings -> All Settings -> Polling Settings. Note you should carefully…

So here's a query that should do just that for you. I'd recommend using SWQL if you can, mainly SolarWinds makes every attempt to keep the SWQL structure consistent, but SQL can change and is not guaranteed to remain the same. Never the less - I provided an option for both should you not decide to go with SWQL. SWQL Method…

So I took a stab at this, and admittedly I may have taken it to the extreme. Give this query a go and see if it meets your needs here. There's actually two different areas you could pull in downtime data. If you have downtime history tracking enabled in polling settings you can pull in Orion.NetObjectDownTime as well which…

Hey there @"swright", please see the following documentation to get you going on the right path. The first link is the top level set of documentation for deploying the agent and the multiple different methods. The second is more along the lines of what you need to install the agent, however you would just need to append…

Hello @"daham_bm" - that's documentation unrelated to the SolarWinds Orion Agent. N-Central is not SolarWinds Orion.

If you list resources (from within the GUI) on that same node within production and attempt to import do you run into any issues?

Here's something that should work to show the current component message and statistic with status icons and clickable links to the detail url's for both on a node details view. There may be a better way to pull in the status icons but that's what transpires at all hours of the night. Hope this helps. This query has also…

Tacking on that, with enhanced you can change the child objects that contribute to node status overall globally and if you edit the nodes you can change them individually as well so they show best status and the interfaces won't affect them.

Ahh - K.I.S.S.

If the only time you see this inconsistency is when you test (via editing the email action and select simulate / execute -- there's the simple fact that the alert trigger time is just that.. an alert trigger time. The issue really comes down to the fact that it's an alert variable (alert trigger time) and when you test…