Explore My Favorite Scripts

I needed a way to pull MS Windows Server and Desktop monthly rollups and place them in a report. I decided to just do a simple web scrape on the Windows Update Catalog website. It simply pulls the page down and parses through the data looking for key values to then parse. Pretty simple output to txt and screen. 

​

Download in TXT Format:

• Annual Patches Web Scrape

• Single Month Web Scrape

• Monthly Results

• Annual Results

We had a multitude of comptuers to patch and we only wanted to do 1/2 of the systems per department. Luckily the system admins before me used a numbering scheme with thier computer names and departments. This script divides the systems into two groups be placing the ones ending in odd #'s in one group and even #'s in another group. 

​

Download in Clean TXT Format:

• Source Sample

• Parse Computer Names Script 

It always seems from time to time someone forgets to register account changes or simply does a typo in the documentation. I always try to have at least two local accounts on ESXi with administrative rights just in case. Here is a way PowerShell and PowerCLI can save the day.

​

Download Clean TxT Files of Scripts

• Create ESXI Local User Account

• Assing Rights to Local User Account

Code signing in PowerShell is the process of digitally signing scripts to verify their authenticity and integrity. It ensures that a script hasn’t been altered or tampered with since it was signed and confirms the identity of the publisher. By using a trusted code-signing certificate, administrators can enforce execution policies that only allow signed scripts to run, helping to prevent malicious or unauthorized code from being executed.

​

Download in Clean TXT Format:

• Code Siging Step by Step Process

The PowerShell Excel module is a powerful tool that allows IT professionals and data analysts to automate Excel-related tasks directly from PowerShell scripts. With this module, users can easily create, read, and modify Excel workbooks without needing Excel installed on the system. One of its most valuable features is the ability to generate pivot tables and charts programmatically, enabling the transformation of raw data into meaningful visual summaries. By defining pivot fields, filters, and chart types, PowerShell can automatically build professional-grade reports that highlight trends, summarize large datasets, and visualize key metrics. This automation not only saves time but also ensures consistency and accuracy in data reporting—making it an excellent solution for recurring tasks such as performance tracking, inventory reporting, or system audits.

​

Download Script in TxT and Excel Output Example

• Excel Module Script

• Excel Output Example

​