Windows: Only one DNS server specified (Built-in)

[Daniel_B]

Old name: Network: Only one DNS server specified (Built-in)

The report below lists all Windows computers having only one DNS server specified

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a Windows computer.
  
• The asset has TCP/IP enabled.
  
• The asset has only one DNS server specified.
  

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblNetwork.DNSServerSearchOrder As DNSserver,
  tblNetwork.IPAddress,
  tblNetwork.IPSubnet,
  tblNetwork.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where Not (tblNetwork.DNSServerSearchOrder Like '%,%') And
  tblNetwork.DNSServerSearchOrder <> '' And tblNetwork.IPAddress <> '0.0.0.0'
  And tblNetwork.IPAddress <> '' And tblState.Statename = 'Active' And
  tblNetwork.IPEnabled = 'True'
Order By tblAssets.AssetName,
  tblAssets.Domain,
  DNSserver