Colby Bouma Colby-PDQ
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 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
/ Basic Report - Failed Updates.xml
Created
August 7, 2019 22:47
A PDQ Inventory Scan Profile and Basic Report that look for failed Windows Updates.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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
/ Network Adapter IP Addresses.sql
Created
August 1, 2019 22:10
A PDQ Inventory SQL Report that shows the contents of the NetworkAdapterIPAddresses table
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ 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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ Disk Usage.sql
Created
July 30, 2019 22:46
A PDQ Inventory SQL Report that calculates used disk space
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ Nuc BIOS Update Collection.xml
Created
July 16, 2019 21:25
The collections for Alex's NUC blog: https://www.pdq.com/blog/intel-nuc-firmware-advisory/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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
/ 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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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
/ Enter-PSSession (Console User).xml
Last active
April 29, 2019 16:41
2019-04-18 Webcast Tools
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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
/ BitLocker.xml
Created
December 13, 2018 16:04
A PDQ Inventory Basic Report with all available BitLocker fields as of 17.0.2.0
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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
/ Collections - PSWindowsUpdate Module.xml
Created
December 12, 2018 20:46
A PDQ Inventory Scan Profile to look for PowerShell modules and a set of Collections to look for the PSWindowsUpdate module.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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 & Directories</TableTitle> |