Skip to content

Instantly share code, notes, and snippets.

Colby Bouma Colby-PDQ

View GitHub Profile
View Enter-PSSession (Console User).xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="16.6.0.8" MinimumVersion="15.0">
<CustomTool>
<CredentialsId value="null" />
<ScanAfter>DoNotScan</ScanAfter>
<ScanProfileId value="null" />
<SuccessCodesText>0</SuccessCodesText>
<Timeout>00:03:00</Timeout>
<WakeOnLan value="false" />
<CustomToolType>Local</CustomToolType>
@Colby-PDQ
Colby-PDQ / BitLocker.xml
Created Dec 13, 2018
A PDQ Inventory Basic Report with all available BitLocker fields as of 17.0.2.0
View BitLocker.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.0.2.0" MinimumVersion="3.1">
<Report>
<ReportDefinition name="Definition">
<RootFilter name="Filter">
<Comparison>All</Comparison>
<Filters type="list" />
</RootFilter>
<ReportDefinitionTypeName>BasicReportDefinition</ReportDefinitionTypeName>
<Columns type="list">
@Colby-PDQ
Colby-PDQ / Collections - PSWindowsUpdate Module.xml
Created Dec 12, 2018
A PDQ Inventory Scan Profile to look for PowerShell modules and a set of Collections to look for the PSWindowsUpdate module.
View Collections - PSWindowsUpdate Module.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.0.3.0" MinimumVersion="4.0">
<Collection>
<ReportDefinition name="Definition">
<RootFilter name="Filter">
<Comparison>All</Comparison>
<Filters type="list">
<ValueFilter>
<Table>File</Table>
<TableTitle>Files &amp; Directories</TableTitle>
@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>
@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 / PDQ Inventory Agent with Config.xml
Created Oct 22, 2018
A PDQ Deploy package for installing the PDQ Inventory Agent.
View PDQ Inventory Agent with Config.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 / 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 / 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 / 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
You can’t perform that action at this time.