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