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 / Current user is a local admin.xml
Last active March 1, 2024 15:27
PDQ Inventory SQL Report to find computers whose Current User is a local admin
<?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"
@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 / BitLocker.xml
Created December 13, 2018 16:04
A PDQ Inventory Basic Report with all available BitLocker fields as of 17.0.2.0
<?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 / AutoPackageUpdate.ps1
Last active May 6, 2021 13:50
2019-09-19 Webcast Bonus Content
# 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 / PDQ Inventory Scan Request Client.ps1
Created October 17, 2019 22:19
Example code for invoking a PDQ Inventory scan from a target machine.
Invoke-RestMethod "http://$YourPDQServer:$Port/ScanRequest/$env:COMPUTERNAME
@Colby-PDQ
Colby-PDQ / Grouped Displays - Fancy.sql
Created July 30, 2019 23:37
A couple of PDQ Inventory SQL Reports that group the Display Model and Display Serial Number fields so each computer only has 1 line.
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 / Firewall Status - Scan Profile.xml
Created October 14, 2019 16:25
A Scan Profile, Dynamic Collection, and Basic Report for firewall status. Built for https://help.pdq.com/hc/en-us/community/posts/360054465291-Firewall-Status-on-all-PC-s-
<?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" />
@Colby-PDQ
Colby-PDQ / Latitude 5580, 5590, 7380, 7390.xml
Last active July 16, 2020 17:41
Collections for https://help.pdq.com/hc/en-us/community/posts/360071535211-Filtering-inventory-based-on-computer-model
<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="19.1.38.0" MinimumVersion="4.0">
<Collection>
<ReportDefinition name="Definition">
<RootFilter name="Filter">
<Comparison>All</Comparison>
<Filters type="list">
<ValueFilter>
<Table>Computer</Table>
<Column>Manufacturer</Column>
@Colby-PDQ
Colby-PDQ / Duplicate MAC Addresses.sql
Last active July 2, 2020 16:44
PDQ Inventory Report for finding duplicate MAC Addresses
SELECT
Computers.Name AS "Computer Name"
, MACDuplicates.MacAddress AS "MAC Address"
FROM
-- https://stackoverflow.com/a/21980136
(
SELECT
Computers.MacAddress
, COUNT(*) AS "Count"
FROM
@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