A PDQ Inventory SQL Report that shows the contents of the NetworkAdapterIPAddresses table

Network Adapter IP Addresses.sql

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"
FROM
	Computers
INNER JOIN
	NetworkAdapters USING (ComputerId)
INNER JOIN
	NetworkAdapterIPAddresses ON
			NetworkAdapters.ComputerId = NetworkAdapterIPAddresses.ComputerId
		AND
			NetworkAdapters.DeviceId      = NetworkAdapterIPAddresses.DeviceId
WHERE
	<ComputerFilter>
ORDER BY
	  "Computer Name" COLLATE NOCASE
	, "IP Address"

Network Adapter IP Addresses.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>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"
FROM
	Computers
INNER JOIN
	NetworkAdapters USING (ComputerId)
INNER JOIN
	NetworkAdapterIPAddresses ON
			NetworkAdapters.ComputerId = NetworkAdapterIPAddresses.ComputerId
		AND
			NetworkAdapters.DeviceId      = NetworkAdapterIPAddresses.DeviceId
WHERE
	&lt;ComputerFilter&gt;
ORDER BY
	  "Computer Name" COLLATE NOCASE
	, "IP Address"</Sql>
      <ReportDefinitionTypeName>SqlReportDefinition</ReportDefinitionTypeName>
    </ReportDefinition>
    <Created>2019-05-21T09:02:51.0000000-06:00</Created>
    <Description></Description>
    <IsNew value="false" />
    <Modified>2019-07-23T15:47:09.0000000-06:00</Modified>
    <Name>Network Adapter IP Addresses</Name>
    <Path>Reports\Network Adapter IP Addresses</Path>
    <ReportFolderId value="1" />
    <TypeName>SqlReport</TypeName>
    <ReportType>SqlReport</ReportType>
  </Report>
</AdminArsenal.Export>