If you clicked a link thinking you were going to end up on SignalWarrant.com, you need not worry… this is not a rogue domain controlled by a nation state, your browser is not downloading some malicious payload (that I know of). You were simply forwarded here to CyberAutomate.io because for the first time in I don’t …

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 previous video walked through the process of using the old Visual Studio Team Services VS Code extension. That extension has now been deprecated. With the latest version or VS Code (I installed v 1.28.1) you should see the Azure Repos extension baked into VS Code. The only other requirement is a local Git repo (I …

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 …