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

Click to Open - Computer IP Address List Query
Select Top 1000000 tblAssets.IPAddress As IP,
  tsysIPLocations.IPLocation,
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  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

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting