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 / 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 / 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 / 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">
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 / 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 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 / 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>
@Colby-PDQ
Colby-PDQ / Grouped Displays - Fancy.sql
Created Jul 30, 2019
A couple of PDQ Inventory SQL Reports that group the Display Model and Display Serial Number fields so each computer only has 1 line.
View Grouped Displays - Fancy.sql
SELECT
Computers.Name AS "Computer Name"
, Computers.Model AS "Computer Model"
, Computers.Manufacturer AS "Computer Manufacturer"
, Computers.SerialNumber AS "Computer Serial Number"
, Computers.Memory AS "Computer Memory"
, CPUs.ProcessorSummary AS "CPU Processor"
, Computers.OS AS "Computer O/S"
, Computers.OSVersion AS "Computer O/S Version"
, Computers.OSServicePack AS "Computer SP / Release"
@Colby-PDQ
Colby-PDQ / Network Adapter IP Addresses.sql
Created Aug 1, 2019
A PDQ Inventory SQL Report that shows the contents of the NetworkAdapterIPAddresses table
View Network Adapter IP Addresses.sql
SELECT
Computers.Name AS "Computer Name"
, NetworkAdapterIPAddresses.Address AS "IP Address"
, NetworkAdapterIPAddresses.Subnet AS "Subnet Mask"
, NetworkAdapters.Name AS "Adapter Name"
, NetworkAdapters.NetConnectionId AS "Connection Name"
, NetworkAdapters.AdapterType AS "Adapter Type"
, NetworkAdapters.MacAddress AS "MAC Address"
, NetworkAdapters.NetConnectionStatus AS "Connection Status"
, NetworkAdapters.ConnectionSpeed AS "Connection Speed"
@Colby-PDQ
Colby-PDQ / Basic Report - Failed Updates.xml
Created Aug 7, 2019
A PDQ Inventory Scan Profile and Basic Report that look for failed Windows Updates.
View Basic Report - Failed Updates.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">
<RootFilter name="Filter">
<Comparison>All</Comparison>
<Filters type="list">
<ValueFilter>
<Table>WMIScanner_55_View</Table>
<TableTitle>WMI (Failed Updates)</TableTitle>
You can’t perform that action at this time.