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