Colby Bouma Colby-PDQ

## 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>

## 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">

## 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"

## 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>

## 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">

## 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>

## 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>

## 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

## 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>

## 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]