Testing the DSC Pull Server, apply localhost.mof to a client node that disables Windows Firewall
SignalWarrant.com - PowerShell scripting
by David Hall
2y ago
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 was built correctly. In this video I will use this same infrastructure to configure the Windows Firewall on a client node. I will use the FirewallProfile resource from the NetworkingDSC Module on the PowerShell Gallery to accomplish the task. The video has all the step-by-step ins ..read more
Visit website
How to build a Secure (HTTPS) DSC Pull Server with a SQL Database using a Group Managed Service Account (gMSA)
SignalWarrant.com - PowerShell scripting
by David Hall
2y ago
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 not as easy as I thought it was going to be. Check out the video below for details. This is the Pull Server build code ..read more
Visit website
How to use Chocolatey to Install Software remotely on multiple computers.
SignalWarrant.com - PowerShell scripting
by David Hall
2y ago
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 some security features built-in the chocolatey repo, but this may not be the solution for an enterprise environment. I use this to overlay software on top of lab VMs that I build and rebuild on a regular basis. In that case I’m not so concerned about the security aspect as I mig ..read more
Visit website
Remote Computer Inventory with PowerShell vNext, 2020 Edition
SignalWarrant.com - PowerShell scripting
by David Hall
2y ago
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 you can think of anything else that may be good to add let me know, or submit a Pull Request on Github. My Github: https://github.com/signalwarrant/PowerShell ..read more
Visit website
PowerShell Splatting How-To: I should use it more and so should you!
SignalWarrant.com - PowerShell scripting
by David Hall
3y ago
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 demonstrate how easy splatting is, explain the syntax, and encourage its use. Mark Kraus has already put together a more concise and detailed explanation on the subject here (https://get-powershellblog.blogspot.com/2019/11/teach-splating-or-die.html), I suggest you take a look. I part ..read more
Visit website
Format and Combine Merch by Amazon Sales reports in seconds with PowerShell
SignalWarrant.com - PowerShell scripting
by David Hall
3y ago
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 are some tools, most of which you need to pay for, out on the market where you can get your sales information. Since I’m only dabbling with Merch by Amazon, I wasn’t willing to pay for anything, so I decided to solve the problem with PowerShell. You can use this script on pretty m ..read more
Visit website
How to get the local Administrators of one or many computers remotely with PowerShell.
SignalWarrant.com - PowerShell scripting
by David Hall
3y ago
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 in the console, export to a CSV, or a text file if you really wanted to I guess. If you know of an easier method of doing this please let me know. Code Download: https://github.com/signalwarrant/Powershell/blob/a7d748da09e13cc463d842252b46ec8352165e64/Get-LocalAdmins.ps1 ..read more
Visit website

Follow SignalWarrant.com - PowerShell scripting on Feedspot

Continue with Google
OR