In video number 45. Secure (HTTPS) DSC Pull Server with SQL Database using a Group Managed Service Account (gMSA), I setup an HTTPS DSC Pull server with a SQL backend using a gMSA to authenticate to SQL. We tested the Pull server simply by accessing the IIS website to...
Automation
How to build a Secure (HTTPS) DSC Pull Server with a SQL Database using a Group Managed Service Account (gMSA)
You have seen on the interwebs many blog posts and videos about setting up a Secure DSC pull server with SQL authentication with a local SQL service account. What I have not seen is a tutorial for how to setup a secure DSC Pull Server with a SQL Database...
How to use Chocolatey to Install Software remotely on multiple computers.
In a previous video I used just PowerShell to install software remotely. In this video I show you how to use the Chocolatey packager manager to install packages (software) from the chocolatey repository on multiple computers simultaneously using a single function. Be careful what packages you’re downloading, there are...
Remote Computer Inventory with PowerShell vNext, 2020 Edition
This is the successor to the first inventory script I put together in 2016 (https://www.signalwarrant.com/remote-computer-inventory-powershell/) This version uses the Get-CIMInstance CMDlet to get all the information from the WMI classes as opposed to the WMI CMDlets. I have also added some additional information that I thought was relevant. If...
Format and Combine Merch by Amazon Sales reports in seconds with PowerShell
I dabble a bit in Merch by Amazon and have grown to hate the monthly sales reports they give you. For whatever reason, Amazon dumps a bunch of useless information in the first column of the CSV file. Why they do that, I have no idea, but it makes...
How to get the local Administrators of one or many computers remotely with PowerShell.
This is a request that was made by someone a few months ago. It’s been a while so I apologize for not remembering who requested it. We’re using the Win32_GroupUser class to get the local administrators of a computer or many computers remotely. The function is modular enough to...
Quickly deploy LAB Virtual Machines with the AutomatedLab PowerShell Framework
My Requirements: Use PowerShell to minimize the time spent on creating VMs. Install ADDS along with the VM creation. Use a differencing disk for all the VMs to save disk space. In the spirit of kickstarting this channel again, I needed to spin up a few Virtual Machines to...