Have you ever needed to add two lines of text together, over and over, like a list of server names and the fully qualified domain name? This can have an endless number of uses for the lazy admin. I never liked writing scripts that read a list of variables from a text file. Its much faster and easier to use a bunch of one-liners in a batch file.
An easy way to do this is with Excel. Take two strings and cat, or concatenate, them together. Here is a diagram so that the Network Engineers reading this can keep up:
Using Excel, it would look like this:
This simple method can be used incredibly complex commands, and are an ideal springboard for Powershell. Not only is this a powerful tool for automating deployments- you can keep the spreadsheet and label it “Documentation”.
I will be following up with some examples of how to automate VMware and VDI deployments using this method.