Computer IP Address List

Get a List of All Ip Addresses of the Computers in Your Network

Having an overview if which device has which IP address can be a challenging task, especially in bigger environments where there is a mix of fixed assigned IP addresses and DHCP ranges. This report provides a list of the IP addresses and the Windows workstation or server that uses it.

Computer IP Address List Query

Select Top 1000000 tblAssets.IPAddress As IP,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
    tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssets.IPAddress <> '' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting