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 / Remove PreForm Registry Keys.ps1
Created Nov 7, 2019
Removes Registry keys that PreForm leaves behind
View Remove PreForm Registry Keys.ps1
# Check both Uninstall keys just to be sure
$RegistryPaths = @(
"HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall"
"HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall"
)
ForEach ( $RegistryPath in $RegistryPaths ) {
$RegistryKeys = Get-ChildItem "$RegistryPath" | Where-Object Name -match "PreForm"
@Colby-PDQ
Colby-PDQ / Display Drivers (GPUs).xml
Created Nov 5, 2019
A PDQ Inventory report that shows the model number, driver version, and driver date for AMD, ATI, Intel, and NVIDIA GPUs
View Display Drivers (GPUs).xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="18.1.38.0" MinimumVersion="3.1">
<Report>
<ReportDefinition name="Definition">
<RootFilter name="Filter">
<Comparison>All</Comparison>
<Filters type="list">
<ValueFilter>
<Table>HardwareDevice</Table>
<TableTitle>Hardware Device</TableTitle>
@Colby-PDQ
Colby-PDQ / PDQ Inventory Scan Request Client.ps1
Created Oct 17, 2019
Example code for invoking a PDQ Inventory scan from a target machine.
View PDQ Inventory Scan Request Client.ps1
Invoke-RestMethod "http://$YourPDQServer:$Port/ScanRequest/$env:COMPUTERNAME
View Firewall Status - Scan Profile.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="18.1.0.0" MinimumVersion="14.0">
<ScanProfile>
<Collections type="list" />
<Scanners type="list">
<Scanner>
<ExcludePattern></ExcludePattern>
<Hive>HKEY_LOCAL_MACHINE</Hive>
<IncludePattern>System\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy\*Profile\</IncludePattern>
<RowLimit value="2500" />
View Deployment Error - 1603.xml
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="18.1.0.0" MinimumVersion="3.1">
<Report>
<ReportDefinition name="Definition">
<RootFilter name="Filter">
<Comparison>All</Comparison>
<Filters type="list">
<ValueFilter>
<Table>PDQDeployment</Table>
<TableTitle>Deployment</TableTitle>
@Colby-PDQ
Colby-PDQ / AutoPackageUpdate.ps1
Last active Sep 25, 2019
2019-09-19 Webcast Bonus Content
View AutoPackageUpdate.ps1
# Written by Jordan Hammond
###Define Variables
$autopath = "C:\Users\Public\Documents\Admin Arsenal\PDQ Deploy\Repository"
$autopackages = @()
$DBPath = "C:\programdata\Admin Arsenal\PDQ Deploy\Database.db"
###Build Package Objects
$test = New-Object psobject -Property @{
Path = "\test"
ScheduleID = "12"
@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>
@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 / 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 / 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>
You can’t perform that action at this time.