Only 1 DNS Server Audit

Discover Workstations or Server with Only 1 DNS

Discover all machines within your network that only have one DNS server specified. Usually, workstations and servers have a primary and secondary DNS server for redundancy in case one DNS server goes down. When a computer only has one DNS server, and that DNS server goes down, browsing and other network related tasks that rely on name resolution will not work. It is, therefore, it is important that a secondary DNS server is set so that users or servers never have issues.

By performing the audit you can quickly identify assets that need a secondary DNS server and take action.

Only 1 DNS Server Audit Query

Select Top 1000000 tblAssets.AssetID,
  tsysOS.Image As icon,
  tblNetwork.DNSServerSearchOrder As [DNS server],
From tblAssets
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where Not (tblNetwork.DNSServerSearchOrder Like '%,%') And
  tblNetwork.DNSServerSearchOrder <> '' And tblNetwork.IPAddress <> ''
  And tblNetwork.IPAddress <> '' And tblNetwork.IPEnabled = 1 And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName

Audit and Take Action in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting