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