Computer IP Address List

Network

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,
  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

Show

Hide