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 / Disk Usage.sql
Created Jul 30, 2019
A PDQ Inventory SQL Report that calculates used disk space
View Disk Usage.sql
SELECT
Computers.Name AS "Computer Name"
, LogicalDisks.LogicalDeviceId AS "Drive Letter"
, ( (LogicalDisks.Size - LogicalDisks.FreeSpace) / 1024 / 1024 / 1024 ) AS "Used Space GB"
FROM
Computers
INNER JOIN
LogicalDisks USING (ComputerId)
WHERE
<ComputerFilter>
View Nuc BIOS Update Collection.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.1.0.0" MinimumVersion="4.0">
<Collection>
<ReportDefinition name="Definition">
<RootFilter name="Filter">
<Comparison>Any</Comparison>
<Filters type="list">
<GroupFilter>
<Comparison>All</Comparison>
<Filters type="list">
@Colby-PDQ
Colby-PDQ / Current user is a local admin.xml
Last active Jul 11, 2019
PDQ Inventory SQL Report to find computers whose Current User is a local admin
View Current user is a local admin.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="17.1.0.0" MinimumVersion="3.1">
<Report>
<ReportDefinition name="Definition">
<Sql>-- Created by Colby Bouma for: https://old.reddit.com/r/pdq/comments/bty5po/request_wmi_query_check_if_user_is_local/
SELECT
Computers.Name AS "Computer Name"
, Computers.CurrentUser AS "Current User"
, LocalGroupMembers.UserName AS "Local Group Member Username"
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]
You can’t perform that action at this time.