In September I wrote a few things about how I use SAM Script Templates – specifically with PowerShell. One of the more powerful things in the SAM arsenal is the ability to return multiple components in a single script. I’ve used this in any number of ways, but the one that gives me the most satisfaction is a PowerShell script that I wrote for Linux.
PowerShell
Scripting SQL Server Installation
This is where I show that I’m really not a DBA. I’m an Accidental DBA at best, and a nuisance at worst. SQL Server already has the capability to be installed via command line parameters or a configuration file. If I setup the machine the same way every single time, this would be fine, but since I need to change the placement of certain file types, I need to have the ability to change on the fly.
Setup SQL Disks
Yesterday, I wrote about how I setup SQL Servers Virtual Machines using PowerShell and PowerCLI. Now that I’ve got the SQL Server imaged, it’s time to format the disks and prep the Page File. Let’s dig in.
Simple Automation Example using Orion SDK
A few months ago, I really stated digging into the Orion SDK and I wanted to know more about ways to automate adding nodes to Orion. Sure, I can wait for the Network Discovery to kick off, but I’m impatient. I’ve gotten many of the parts together over time, but this is my first post where I put everything together. For this version, I use the PowerShell Snap-In. I will add an additional post later using the PowerOrion Module.
Building My Orion Server Step 3 [Updated]
A few months ago, I wrote about the third step in setting up an Orion server from scratch. After using this script for a few months, I realized there was an eventuality that I missed.
SAM PowerShell Scripting Template
I write a lot of PowerShell scripts. Like a lot, a lot. I write them for any manner of things, but recently I’ve been tasked to help out with a few Server & Application Monitor templates. These are some of the most interesting things that SAM has to offer.
Looking at each of the scripts, I decided it was worth revisiting based on some of my newly acquired PowerShell superpowers (cape not included).
SAM script templates (Windows Scripting, PowerShell, Perl, Python, whatever) require two things – a statistic and an exit code.
Mass Export of NCM Device Templates
Do you run a bunch of Orion servers? Do you hate exporting your custom NCM Device Templates one at a time?
No? Only me?
Well, if you are ever like me, I’ve got something to help you out.
It basically checks for all the device templates in your database for those that aren’t out of the box and exports them in the proper format.
Automating the Configuration Wizard
In a previous post I said how to run multiple Orion installations without running the Configuration Wizard. This is great if you have a new big installation planned. So the last step is to actually run the configuration wizard.
Speeding up multiple SolarWinds Orion Products Installations
I stumbled across an article called Install Orion products in unattended or silent mode that made me so happy because I install new Orion servers about 4 times a month. There are only so many time I want to click “Next,” “Next”, “Finish” in any given day. So, since I do this so often, I wanted to script this out. The big two takeaways from this article are that you run the installer silently and can skip the Configuration Wizard from running after installation.
Building my Orion Server [VMware Scripting Edition] – Step 1
This is part 1 of a multi-part post on updates that I’ve made to How I Build an Orion Server. Primarily, it will be three parts. If you need this for a Hyper-V environment, I’ve got that script as well.
- Building my Orion Servers in VMware
- Configuring the disks on the VM after OS install
- Configuring the VM with the new disks