Reports

Only 1 DNS Server Audit

Network

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 one DNS server specified

Only 1 DNS Server Audit Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblNetwork.DNSServerSearchOrder As [DNS server],
  tblNetwork.IPAddress,
  tblNetwork.IPSubnet,
  tblNetwork.Lastchanged
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 <> '0.0.0.0'
  And tblNetwork.IPAddress <> '' And tblNetwork.IPEnabled = 1 And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName

Show

Hide

Other reports in this category

Ready to get started?

Explore the full platform, free for 14 days.
No credit card required.

Start free Book a demo
Need help evaluating?
Get guidance on pricing at scale and enterprise requirements.
Talk to sales
Clear pricing as you grow
Transparent plans that scale with your environment.
View plans & pricing