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 verify that IIS was functioning, and the Database …

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 using a Group Managed Service Account (gMSA). Spoiler alert it’s …

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 …

This is the successor to the first inventory script I put together in 2016 https://www.cyberautomate.io/posts/2016/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 …

In my experience splatting is one of those often overlooked and underutilized features of PowerShell. Full disclosure, I don’t use it regularly myself. Most times I just forget it’s a thing. For those that are new to PowerShell, splatting looks more difficult than it really is. The whole idea of this video is to …

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 the CSV files difficult to use from a data analysis perspective. There …

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 give you the ability to view the results …

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 facilitate PowerShelling. I was going to go …

Greetings interweb. It’s been a while but I’m back with a new video finally. This video focuses on Desired State Configuration Manager (DSC) and how to configure Advanced Auditing using DSC. You can certainly configure DSC using a group policy object (GPO). My use case for this is if you have a public facing web …

To demonstrate this process, I will show you how I export all the PowerShell help and convert it to PDF files that I use instead of looking at the help files in the PowerShell Console. I realize you can view the PowerShell help files in the console and online. The purpose of this script is to demonstrate how I solved …