Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
<?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>
<?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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment