Colby-PDQ

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

Colby-PDQ

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

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

# 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

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

<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="14.1.0.0" MinimumVersion="4.0">
  <Collection>
    <ReportDefinition name="Definition">
      <RootFilter name="Filter">
        <Comparison>All</Comparison>
        <Filters type="list">
          <ValueFilter>
            <Table>Computer</Table>
            <Column>Name</Column>

Colby-PDQ

<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="18.3.32.0" MinimumVersion="15.0">
  <CustomTool>
    <CredentialsId value="null" />
    <RunAs>Admin</RunAs>
    <ScanAfter>DoNotScan</ScanAfter>
    <ScanProfileId value="null" />
    <SuccessCodesText>0</SuccessCodesText>
    <Timeout>00:00:30</Timeout>
    <WakeOnLan value="false" />

Colby-PDQ

<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="12.2.0.0" MinimumVersion="3.1">
  <Report>
    <ReportDefinition name="Definition">
      <Sql>SELECT Computers.Name AS 'Computer Name', Computers.IPAddress AS 'IP Address', 'STATIC' AS 'Type' FROM Computers
 WHERE Computers.IPAddress IN 
  (SELECT value FROM RegistryEntries
    WHERE RegistryPathId IN (SELECT RegistryPathId FROM RegistryPaths 
     WHERE lower(PathName) LIKE 'system\currentcontrolset\services\tcpip\parameters%')
    AND Name = 'IPAddress')

Colby-PDQ

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

-- https://gist.github.com/Colby-PDQ/c03e7eee22a73c9b1dcbe81aaa9b18e6

SELECT
	  Computers.Name AS "Computer Name"
	, Applications.Name AS "Application Name"
FROM
	(
		SELECT
			  Applications.ApplicationId
			, COUNT(Applications.Name) AS "ApplicationCount"