mbutler756 · Operations Services Manager · ✭✭✭✭✭

Thank you so much! I converted it to T-SQL and added a bit of node info. SELECT n.Caption AS NodeCaption, n.IP_Address, s.EntityType, MAX(d.Name) AS ScheduleName, MAX(d.ScheduleType) AS ScheduleType, MAX(d.Reason) AS Reason, MAX(d.AccountID) AS AccountID, a.Name AS ApplicationName, DATEADD(hour,-7, MIN(a.UnmanageFrom)) AS…

That's awesome! Thank you for sharing this - great resource!!

Fools of April

We are the same way - no changes on Friday unless absolutely necessary and you better have a darn good reason

We had some switches labeled "Smith" and "Wesson"

I would love your vote - still missing this feature - even in 2025.2.0

+1. I really need to pass parameters that I get from SolarWinds variables and I can't do this -- we NEED powershell access

@"thiesaj" - your post was crystal clear. I love how much detail you put into your post. I was pointing out that you can use Manage Nodes to assign those maintenance schedules as well. I put in a request to be able to assign scheduled based on group membership / custom objects - you should be able to do this. Your post…

Great post - I put in a feature request to make the recurring maintenance assignments easier. [mention:79cf43a968024d358257e615da8a049e:fb5d84b10a5745448a7a45dafc1faa43] You can also use the "Manage Nodes" to assign maintenance schedules en mass in 2025.2.0

Thanks, Adam - I was looking for it the other day and couldn't find it easily - I posted it there for voting: thwack.solarwinds.com/.../export-functionality-for-syslogs-traps-events

I make use of groups and custom attributes to do the same thing. Here's an example of how we do ours: Custom Property: Patching_Group Values: Blue, Pink, Orange, etc Each node has a value assigned, but you could also have any property name / value system you want to use Then, in Manage Nodes, I change the filter to the…

I found one more KB 5019081 that was just recently installed that may relate to it. Removing that update to do some additional testing. https://support.microsoft.com/en-us/topic/november-8-2022-security-update-kb5019081-d53a4cf1-0987-4ab7-a529-23f7136f4083

I removed the offending KB to see if that would resolve the issue - sadly, it has not. I will continue to troubleshoot the issue and update here if I find out more

I know this is old - but I was able to locate these tables recently based on some work that I was doing with IP SLA. The below query, will give you the last 30 days of your IPSLA operations - you can introduce any logic you like to meet your requirements. SELECT i.OperationName, d.RoundTripTime, RecordTimeUtc FROM…

You were correct - I had it under SYSTEM thinking that would do the trick. However, I changed it and defined the permissions and the script ran perfectly! Thank you very much! Gotta love getting some automation within the environment!

I forgot to mention that I did try to take the exact command and put it in a command prompt and that functioned properly - started the services with no issues, just doesn't seem to do it from within solarwinds

This is a great solution to my problem, but unfortunately, my script is still failing - here some info from the logs: 2021-05-05 13:38:31,928 [114] ERROR AlertingLogger - (null) Action [Action: ID: 893, ActionType: ExecuteExternalProgram, Title: Try the Swiss Army Knife, Description: Execute a program when the Alert is…

The best thing to do would probably be to convert the date to a numeric number. Using today's date as an example, the value could be converted to 20200825. Any config after that, would have a higher number. Get-Date -UFormat "%Y%m%d" Produces: 20200825 What do you think?

Unfortunately, the file age monitor won't work for this application. I'll give you a bit of background: We have deployed SysMon to many of our servers. We are going through several rounds of config changes. Each time the config gets updated, the last write time should change. My goal isn't to see how old a file is, it's to…

Okay, after some work - I finally figured out how to make this work. First off, there's a cool little checkbox that you have to change to make the script run on the remote machine vs the local machine. When you do that, you will also need to choose your transport method (HTTP or HTTPS). Once I figured out that I had goofed…

I was able to resolve this issue. I did confirm that there was no reverse DNS issue and the additional IPs assigned to the node by SolarWinds weren't associated with the node. I ended up removing the two conflicting nodes. I then added the nodes back in without an issue.

Thank you - this is excellent info!

Either way would be excellent! They could both be in the same, but I think it would probably be most beneficial to the community if they were separated out as separate thwack templates. I am looking for specific files, but if the file path was passed in as an arg or could be set within the script, either would be a good…

I modified the variables and added the .ToString() before the write-host, unfortunately no change in character when running them from the SolarWinds box. [reflection.assembly]::LoadWithPartialName("System.Version") $os = Get-WmiObject -class Win32_OperatingSystem $osName = $os.Caption $s = "%systemroot%\sysmon64.exe" $v =…

I'm going to open that ticket. Thanks for confirming the agent is using WMI locally