Skip to content

Instantly share code, notes, and snippets.

View Colby-PDQ's full-sized avatar

Colby Bouma Colby-PDQ

34 followers · 0 following
View GitHub Profile
@Colby-PDQ
Colby-PDQ / Deploy Client mode.xml
Last active August 22, 2023 13:46
PDQ Deploy packages for installing PDQ Deploy and Inventory in Client mode
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQDeploy" Name="PDQ Deploy" Version="18.4.0.0" MinimumVersion="18.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 / Application Comparison with Version.sql
Last active June 16, 2020 17:51
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.
-- 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 / PDQ Inventory Agent with Config.xml
Created October 22, 2018 21:40
A PDQ Deploy package for installing the PDQ Inventory Agent.
<?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
Last active June 30, 2020 14:17
Uninstalls MSI-based applications by name.
Moved to: https://github.com/Colby-PDQ/Uninstall-Packages/blob/master/Scripts/Uninstall-MSI-By-Name.ps1
@Colby-PDQ
Colby-PDQ / Uninstall OpenOffice.xml
Created October 18, 2018 18:22
PDQ Deploy package for uninstalling OpenOffice.
<?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 / Remove-Computer-From-Agent-Tables.ps1
Created October 18, 2018 17:22
Removes Agent records from your Inventory Server's database.
# 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 / IBM Model F.sc
Created October 15, 2018 20:14
IBM Model F Soarer's Converter config file
layerblock
FN1 1
endblock
remapblock
layer 0
LALT LCTRL
LCTRL CAPS_LOCK
BACK_QUOTE ENTER
ENTER BACKSLASH
@Colby-PDQ
Colby-PDQ / Application Comparison.sql
Last active June 16, 2020 17:51
Select 2 computers, then run this report. It will show you which applications only exist on one of them.
-- 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 / Abort All Deployments.ps1
Last active November 22, 2017 23:29
Aborts all Running, Connecting, and Queued deployments.
# 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 / Abort Queued Deployments.ps1
Last active November 3, 2017 22:24
# 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