Scripts

This Telegram bot allows you to retrieve information about CPU and memory usage from nodes in a SolarWinds production environment and generate graphs with the collected data. ## Features - Query node information from SolarWinds. - Get the top 5 nodes with the highest CPU or memory usage. - Generate bar charts from the data. - Conversational interface on Telegram. ## Requirements - Python 3.8+ - A registered Telegram bot with a valid token. - SolarWinds access credentials. DEMO.mp4 GIT REPO...

Introduction Managing SSL certificate settings in large SolarWinds Orion environments can be challenging, especially when the SWIS REST endpoint settings do not load in the web console due to the system’s scale. This PowerShell script simplifies the process by providing an interactive interface to view, modify, and reset certificate settings directly through the SolarWinds Information Service (SWIS) API. What This Script Does This script is designed to help Orion administrators: Retrieve...

This builds on the sample scripts available in the Orion SDK Github called ImportListResources.ps1 ; ImportSelectedLIstResources_CPUMemory.ps1 ; and ImportSelectedListResources_Routing.ps1. I posted about this on thwack seeking help, took a coffee break and then saw my typos and my issue was SOLVED! After 24 hours of hard work I bring this script to you! Now, this will need to be modified for your environment as you will need to pass in your username and password. Also, if you do not run your scripts...

Problem When running SolarWinds Deployment Health or Active Diagnostics , you may encounter the warning: "Check if TLS 1.0 is disabled" "Check if TLS 1.1 is disabled" The official Knowledge Base article provides a manual resolution: How to disable TLS 1.0 or 1.1 by updating the Windows registry or using IIS Crypto for the SolarWinds Platform Why Do This Manually? Instead of manually modifying registry settings or installing IIS Crypto, this PowerShell script automates the process...

Hi all, Hope you are all doing well. In our environment, I came across a situation to add 100+ DHCP servers into SolarWinds and i couldn't find any way to add multiple DHCP servers at a time from console. I can see only way to add them one by one from SolarWinds web console. Finally, I am able to add multiple DHCP servers to SolarWinds using SolarWinds SDK and posting this here thinking this might help my peers who come across the similar situation. Below is the article that can give you...

When a Windows node is moved from SNMP to WMI monitoring, not all of the WMI Pollers are brought over. This script finds nodes with missing CPU and Memory pollers and then runs a discovery (List Resources) via the API for each node to scan and add the appropriate pollers in. Script will prompt for hostname/IP of main SolarWinds server and credentials. Before running this script, this report will show what nodes are missing CPU/Memory pollers. https://thwack.solarwinds.com/content-exchange/the...

Sometimes rebooting is the only way for fast service recovery. This script will use installed agent to send request for reboot. You can use below parameters for Alert Trigger Action. The best way would be to use Execution Escalation to create a bit of delay (such as 30 minutes). Example assumes that you will save the script in C:\Scripts directory of your main SolarWinds server/poller. Name of action: Reboot Node using Agent Network path: powershell.exe c:\Scripts\RebootNode.ps1 -node_id...

Script will find all interfaces using WHERE filters or by added date and will remove all of them. Please note that this cannot be undo and to go back, you would need to use database backup. Such script can be very useful if you made a mistake in Network Discovery filters and many interfaces were added. Use with caution.

Hi all, this script will be helpful to configure an automation to start the service when any service is stopped using execute external program as the alert action. Please note below points: 1. Under Trigger condition - Please choose "I want to alert on Component " Define your scope and actual trigger condition of the alert as example: Configure rest all the tabs as required. sample refer below for configuring trigger aciton: Copy the attached script to SolarWinds main polling engine....

Hi all, this script will be helpful if we enter into a situation where we need to reprovision multiple agents at a time due to Orion certificate issue. Below is the script format to use and call the attached script to reprovision multiple agents at a time. *************************************************************************************************************** $RemoteComputers= get-content “D:\xx\xx\xx(path to the text file where list of servers to run” ForEach ($RemoteComputer in...

Hi all, this script will be useful if we enter into a situation that we need to reprovision multiple agents at a time. Required data to be fed into the script based on the type of agent communication, polling engine etc..

Since we're migrating to a new HCO installation and starting with a clean database I needed a way of getting all the Alerts, SAM Templates and Reports across to the new install. Scripts to export and import all of those are available, with a little hacking, apart from Reports. I've created a script based on (I think) KMSigma's 'import alerts' script and changed the SWIS command based on the fields from orion.report.createreport in SWQL Studio. On the old poller, use exportReports.ps1 found on these...

As seen at SQL Saturday Denver Problem Statement: One of the most common relational database query performance problems stems from reading too much data in order to obtain a relatively small query result set. DBAs and Developers are often unaware of the excessive reads that cause queries to run slow. Excessive reads is often solved by proper indexing , index maintenance and query tuning . Determining proper indexing is not an exact science , as it requires an understanding of a variety...

Referring to the recent use case, I decided to create a very easy way to export Modern Dashboards using HTTPS POST requests to API. This approach does not require any additional installations or configuration and can be run locally on SolarWinds server or remotely from any location with access to SolarWinds REST API. How-To and walkthrough of the script is published on my YouTube Channel. I appreciate subscribing

Referring to the recent use case, I decided to create a very easy way to import Modern Dashboards using HTTPS POST requests to API. This approach does not require any additional installations or configuration and can be run locally on SolarWinds server or remotely from any location with access to SolarWinds REST API. How-To and walkthrough of the script is published on my YouTube Channel. I appreciate subscribing

This script is used to automatically change the polling interval of a busy interface, triggered by the alert found here: Automatically Change Interface Polling Interval (Automation) Have a look at Dynamically change interface polling interval using alerts and PowerShell for a detailed explanation how it works and the drivers behind this automation.

I had a need to test a port on a remote machine, but the internal TCP Port Monitor only works for the machine where it is assigned. I wrote this powershell script to test the port on the remote machine and thought I would share it here. In it's current form, you can invoke the script with parameters from the command line. Let's run a test against Google's port 443. .\TestRemotePort.ps1 -RemoteHost 142.250.68.238 -Port 443 Statistic: 1 Message: Port 443 on 142.250.68.238 is open. If you are...

Ever wondered which of your Classic Dashboards are actually being used? Who visited the page? How many times? These are the questions this script aims to answer. I wrote this because we have an internal audit process where we evaluate the use of dashboards. Anything that doesn't get used yearly we look at reworking/updating/removing. This used to involve reaching out to customers individually to ask them if they still used certain dashboards... well now that we're storing the output of this script...

This script will call into the Orion API and move a group of agent nodes from one engine to another. You will need to update the SWQL ($query) to only capture the nodes you wish to migrate. You will also need to know the EngineID of the Polling engine you wish to migrate nodes to.

A script that allows you to delete multiple nodes from a spreadsheet. Read to notes in the script.