DNS Settings for All Computers

Find DNS Settings for All Computers in Your Network

Report on the DNS settings for all the computers in your environment or domain. The DNS information is scanned along with other Windows information during the scan of a Windows asset. Using the custom report below, you can report of exactly which DNS settings a workstation or server is using for troubleshooting purposes or simply to have a comprehensive overview.

DNS Settings for All Computers

DNS Settings for All Computers Query

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress As [Asset IPAddress],
  tblNetwork.Description As Adapter,
  tblNetwork.IPAddress As [NIC IPAddress],
  tblNetwork.IPSubnet,
  tblNetwork.DNSServerSearchOrder,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric And tsysIPLocations.EndIP >= tblAssets.IPNumeric
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblAssetCustom.State = 1 And tblNetwork.IPEnabled = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Adapter

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