Jetzt Ausprobieren

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