zaskem’s gists

zaskem / ExampleManualOSDRename.ps1

Created July 28, 2024 23:14

Basic Windows form to handle manual naming of OSD Task Sequence device, including basic validation.

	$tsenv = New-Object -COMObject Microsoft.SMS.TSEnvironment
	$OSDComputerName = $tsenv.Value("_SMSTSMachineName")

	function Show-OverrideOptionsPrompt_psf {

	#----------------------------------------------
	#region Import the Assemblies
	#----------------------------------------------
	[void][reflection.assembly]::Load('System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089')
	[void][reflection.assembly]::Load('System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089')

zaskem / IdentifyDellDockFirmwareVersion.md

Created April 11, 2023 14:33

One-liner to identify attached Dell dock firmware and model number from WMI when the Dell System Inventory Agent (DSIA) is installed on the host machine.

Get-WmiObject -Namespace root\dell\sysinv dell_softwareidentity -ErrorAction Stop | Select-Object VersionString, ElementName | Where-Object ElementName -like "WD19" | Sort-Object ElementName

zaskem / letsencrypt-ssl-apache.conf

Created March 6, 2022 22:47

An example conf file to include for Apache on Windows where Certbot/letsencrypt certificates are generated and used.

	#
	# LET'S ENCRYPT SSL EXAMPLE SETTINGS
	#
	# This include was copied from a functioning Certbot installation on Linux.
	# Its presence makes the SSL certs issued by Certbot behave on <Windows>
	#
	SSLEngine on
	# Intermediate configuration, tweak to your needs
	SSLProtocol all -SSLv2 -SSLv3 -TLSv1 -TLSv1.1
	SSLCipherSuite ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384

zaskem / ExportEmailToPDF.gs

Last active January 18, 2021 01:13

A basic Google Apps Script that, when triggered from a Google Sheet, will export Gmail messages by label to PDF in the drive folder specified and log the basic information to she calling spreadsheet.

	function exportEmailToPDF() {
	// Script Variables to Set
	var drivePath = DriveApp.getFolderById("LongStringOfTheDestinationFolderIdentifier");
	var plaintextPath = DriveApp.getFolderById("LongStringOfTheIntermediateFolderIdentifier");
	var label = GmailApp.getUserLabelByName("YourLabelNameGoesHere");
	// End of Script Variables to Set

	var sheet = SpreadsheetApp.getActiveSpreadsheet();
	//Logger.log(label.getName()); // Write to log the name of the label (can help identify label typos)
	var threads = label.getThreads();

zaskem / certbot-multi-superdomain.sh

Created October 4, 2020 18:33

Basic Certbot bash automation script to bolt together key commands in manually-requesting a certificate for multiple variations (TLDs) of a domain, as outlined in https://mzonline.com/blog/2020-10/improving-manual-certbot-domain-validation

	#!/bin/bash
	certbot certonly --manual --manual-public-ip-logging-ok -d superdomain.net -d www.superdomain.net
	read -n1 -r -s -p "Press any key to load certificate...`echo $'\r\n\r\n'`"
	more /etc/letsencrypt/live/superdomain.net/cert.pem
	read -n1 -r -s -p "Press any key to load private key...`echo $'\r\n\r\n'`"
	more /etc/letsencrypt/live/superdomain.net/privkey.pem
	read -n1 -r -s -p "Press any key to begin renewal process for superdomain.com...`echo $'\r\n\r\n'`"
	certbot certonly --manual --manual-public-ip-logging-ok -d superdomain.com -d www.superdomain.com
	read -n1 -r -s -p "Press any key to load certificate...`echo $'\r\n\r\n'`"
	more /etc/letsencrypt/live/superdomain.com/cert.pem

zaskem / certbot-superdomain.sh

Created October 4, 2020 18:31

Basic Certbot bash automation script to bolt together key commands in manually-requesting a certificate, as outlined in https://mzonline.com/blog/2020-10/improving-manual-certbot-domain-validation

	#!/bin/bash
	certbot certonly --manual --manual-public-ip-logging-ok -d superdomain.net -d www.superdomain.net
	read -n1 -r -s -p "Press any key to load certificate...`echo $'\r\n\r\n'`"
	more /etc/letsencrypt/live/superdomain.net/cert.pem
	read -n1 -r -s -p "Press any key to load private key...`echo $'\r\n\r\n'`"
	more /etc/letsencrypt/live/superdomain.net/privkey.pem
	read -n1 -r -s -p "Press any key to end certificate renewal process...`echo $'\r\n\r\n'`"

zaskem / Certbot-Ubuntu-Quickstart.sh

Last active October 4, 2020 18:10

Companion/Quickstart bash script to manually install and use Certbot with key command steps as outlined in the post https://mzonline.com/blog/2020-10/moving-certbot-lets-encrypt

	# Update Ubuntu and obtain/install/update Certbot
	sudo apt-get update
	sudo apt-get install software-properties-common
	sudo add-apt-repository universe
	sudo add-apt-repository ppa:certbot/certbot
	sudo apt-get update

	# Make a manual certificate request
	sudo certbot certonly --manual -d superdomain.net

zaskem / CSVDataWithEmbeddedFormulas.csv

Last active February 19, 2025 10:22

Column A	Column B	Column C	Formula
1	2	5	=SUM(A2:C2)
5	3	10	=A3*C3+B3
2	2	4	=COUNTIF(A:C,2)
0	0	No	=IF(and(A5=0,B5=0,C5="Yes"),1,0)
0	0	Yes	=IF(and(A6=0,B6=0,C6="Yes"),1,0)
1	0	1	=IF(AND(A7=1,B7=0),"UPDATE",IF(AND(A7=0,B7=1),"CHECK","No Change"))
0	1	1	=IF(AND(A8=1,B8=0),"UPDATE",IF(AND(A8=0,B8=1),"CHECK","No Change"))
0	0	0	=IF(AND(A9=1,B9=0),"UPDATE",IF(AND(A9=0,B9=1),"CHECK","No Change"))

zaskem / Certbot-ManualMode.sh

Created July 5, 2020 17:41

Invoke certbot (new issue or renewal) in manual mode for two variations of a domain name

sudo certbot certonly --manual --manual-public-ip-logging-ok -d domainnamehere.com -d www.domainnamenere.com

zaskem / Get-ADGroupsSortedByName.ps1

Created April 15, 2020 22:00

	$groups = Get-ADGroup -Filter 'Name -like "PATTERNGOESHERE*"' \| Select-Object Name, SamAccountName;
	"There are "+ $groups.Count +" matching groups.";
	$groupDetails = ForEach ($grp in $groups) {
	New-Object PSObject -Property @{'Group Name'=$grp.Name;Count=(Get-ADGroupMember $grp.SamAccountName -Recursive).Count};
	}
	$groupDetails \| Sort-Object -Property Count -Descending \| Select-Object 'Group Name', Count;

Matt Zaske zaskem