DNS Server IP Report

Re:DNS Server IP Report (gjones)

Sat, 18 Aug 2012 15:56:32 GMT

Try this

  select CS.Name0 
 
  from dbo.v_GS_COMPUTER_SYSTEM CS
 join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceID = NAC.ResourceID 
 
  Where DNSServerSearchOrder0 like '%192.168.1.5%'

DNS Server IP Report (csharma180)

Fri, 17 Aug 2012 15:05:29 GMT

Hello All,

I have a DNS Server IP for which I wanted to get a report extracted using SCCM Database to see on which all server this IP is configured as the DNS IP