Files for https://help.pdq.com/hc/en-us/community/posts/211685947

Report-DHCP-Static IP Address.xml

<?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')
AND &lt;ComputerFilter&gt;
UNION ALL
SELECT Computers.Name, Computers.IPAddress, 'DHCP' 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 = 'DhcpIPAddress')
AND &lt;ComputerFilter&gt;</Sql>
      <ReportDefinitionTypeName>SqlReportDefinition</ReportDefinitionTypeName>
    </ReportDefinition>
    <Description>Grab TCP/IP config data from Registry tables</Description>
    <Name>DHCP / Static IP Address</Name>
    <ReportFolderId value="76" />
    <ReportType>SqlReport</ReportType>
  </Report>
</AdminArsenal.Export>

ScanProfile-DHCP-Static-Registry.xml

<?xml version="1.0" encoding="utf-8"?>
<AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="12.2.0.0" MinimumVersion="9.0">
  <ScanProfile>
    <Description>Determine whether IP Address is dynamic or static</Description>
    <ScanProfileId value="118" />
    <IsDefault value="false" />
    <Name>DHCP / Static</Name>
    <Scanners type="list">
      <Scanner>
        <ExcludePattern></ExcludePattern>
        <Hive>HKEY_LOCAL_MACHINE</Hive>
        <IncludePattern>SYSTEM\CurrentControlSet\services\Tcpip\Parameters\Interfaces\**\IPAddress
SYSTEM\CurrentControlSet\services\Tcpip\Parameters\Interfaces\**\DhcpIPAddress</IncludePattern>
        <RowLimit value="2500" />
        <TypeName>Registry</TypeName>
        <SourceScannerId value="435" />
      </Scanner>
      <Scanner>
        <TypeName>Computer</TypeName>
        <SourceScannerId value="436" />
      </Scanner>
    </Scanners>
    <ScheduleTriggers type="list" />
  </ScanProfile>
</AdminArsenal.Export>