Skip to content

Instantly share code, notes, and snippets.

Colby Bouma Colby-PDQ

Block or report user

Report or block Colby-PDQ

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@Colby-PDQ
Colby-PDQ / Service Control.ps1
Last active Sep 20, 2017
A sanitized version of a service control script I wrote at a previous company. It was one of the first scripts I wrote, so please forgive some of the egregious sins like Write-Host ;)
View Service Control.ps1
# Created by Colby Bouma
# This script shuts down or starts up services in a specific order
#
# Usage: & '.\Service Control.ps1' [-Environment] {PROD, DEV, TEST} [[-Target_Name] <server short name>] [-Start]
# You must always specify an environment that exists in "Service Control.xml"
# The default is to shut down the specified environment.
# The [-Start] parameter will cause it to start up the specified environment.
# The [-Target_Name] parameter may be used to run this script against 1 specified server, using the <Server> name from "Service Control.xml"
# Example of shutting down DEV: & '.\Service Control.ps1' DEV
# Example of starting up PROD: & '.\Service Control.ps1' PROD -Start
View Abort Queued Deployments.ps1
# Written by Colby Bouma
# This is a script for Mmuni: https://support.pdq.com/hc/en-us/community/posts/211677967/comments/115000826331
# https://gist.github.com/Colby-PDQ/38d033889303e42faf0648aa7d2ec2fe
#
# v 003
$Deploy_DB_File = "$env:SYSTEMDRIVE\ProgramData\Admin Arsenal\PDQ Deploy\Database.db"
$Error_Message = "<Error><Message>Aborted</Message><Type>AdminArsenal.Remote.Agent.AbortedException</Type><StackTrace></StackTrace></Error>"
# This is a stripped down version of a function from a blog post I am writing
@Colby-PDQ
Colby-PDQ / Abort All Deployments.ps1
Last active Nov 22, 2017
Aborts all Running, Connecting, and Queued deployments.
View Abort All Deployments.ps1
# Written by Colby Bouma
# Aborts all runnings deployments. Based off of this script: https://gist.github.com/Colby-PDQ/38d033889303e42faf0648aa7d2ec2fe
# https://gist.github.com/Colby-PDQ/f148a630293270149a7d4b2369b60682
#
# v 003
$Deploy_DB_File = "$env:SYSTEMDRIVE\ProgramData\Admin Arsenal\PDQ Deploy\Database.db"
$Error_Message = "<Error><Message>Aborted</Message><Type>AdminArsenal.Remote.Agent.AbortedException</Type><StackTrace></StackTrace></Error>"
# This is a stripped down version of a function from a blog post I am writing
@Colby-PDQ
Colby-PDQ / IBM Model F.sc
Created Oct 15, 2018
IBM Model F Soarer's Converter config file
View IBM Model F.sc
layerblock
FN1 1
endblock
remapblock
layer 0
LALT LCTRL
LCTRL CAPS_LOCK
BACK_QUOTE ENTER
ENTER BACKSLASH
@Colby-PDQ
Colby-PDQ / Remove-Computer-From-Agent-Tables.ps1
Created Oct 18, 2018
Removes Agent records from your Inventory Server's database.
View Remove-Computer-From-Agent-Tables.ps1
# Written by Colby Bouma
# This script removes all Agent records associated with the computer name you specify
#
# v 011
[CmdletBinding()]
param (
[string]$Name,
[string]$InventoryDBFile = "$env:SYSTEMDRIVE\ProgramData\Admin Arsenal\PDQ Inventory\Database.db"
)
@Colby-PDQ
Colby-PDQ / Uninstall OpenOffice.xml
Created Oct 18, 2018
PDQ Deploy package for uninstalling OpenOffice.
View Uninstall OpenOffice.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQDeploy" Name="PDQ Deploy" Version="17.1.0.0" MinimumVersion="15.0">
<Package>
<CurrentLibraryPackageVersionId value="null" />
<PackageDefinition name="Definition">
<Conditions type="list">
<PackageStepCondition>
<Architecture>Both</Architecture>
<Version>All</Version>
<TypeName>OperatingSystem</TypeName>
@Colby-PDQ
Colby-PDQ / Universal Uninstall.ps1
Created Oct 18, 2018
Uninstalls MSI-based applications by name.
View Universal Uninstall.ps1
# Written by Colby Bouma
# This script attempts to search the registry for the GUID of the specified application and uninstall it with MsiExec
#
# v 010
param (
[Parameter(Mandatory=$true)]
[ValidateNotNullOrEmpty()]
[string]
@Colby-PDQ
Colby-PDQ / Application Comparison with Version.sql
Last active Oct 25, 2018
Select 2 computers, then run this report. It will show you if an application only exists on one of them, or if each of them has a different version.
View Application Comparison with Version.sql
-- https://gist.github.com/Colby-PDQ/133fdcc7596d8908d6f43a195b9e02f2
SELECT
Computers.Name AS "Computer Name"
, Applications.Name AS "Application Name"
, Applications.Version AS "Application Version"
FROM
(
SELECT
Applications.ApplicationId
@Colby-PDQ
Colby-PDQ / Application Comparison.sql
Last active Oct 25, 2018
Select 2 computers, then run this report. It will show you which applications only exist on one of them.
View Application Comparison.sql
-- https://gist.github.com/Colby-PDQ/c03e7eee22a73c9b1dcbe81aaa9b18e6
SELECT
Computers.Name AS "Computer Name"
, Applications.Name AS "Application Name"
FROM
(
SELECT
Applications.ApplicationId
, COUNT(Applications.Name) AS "ApplicationCount"
@Colby-PDQ
Colby-PDQ / Deploy Client mode.xml
Created Dec 4, 2018
PDQ Deploy packages for installing PDQ Deploy and Inventory in Client mode
View Deploy Client mode.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQDeploy" Name="PDQ Deploy" Version="17.1.0.0" MinimumVersion="17.0">
<Package>
<CurrentLibraryPackageVersionId value="null" />
<PackageDefinition name="Definition">
<Conditions type="list">
<PackageStepCondition>
<Architecture>Both</Architecture>
<Version>All</Version>
<TypeName>OperatingSystem</TypeName>
You can’t perform that action at this time.