Server DNS Details

[kevinoie]

HI.

Is it possible to amend the folowing to only include Servers?

Select Top 1000000 dbo.tblComputers.Computer, dbo.tblComputers.Username, dbo.tblNetwork.DNSServerSearchOrder As [DNS server], dbo.tblNetwork.IPAddress, dbo.tblNetwork.Lastchanged, dbo.tblNetwork.DefaultIPGateway, dbo.tblNetwork.DHCPserver, dbo.tblNetwork.DHCPenabled, Web40OSName.OSname, Web40OSName.SP, dbo.tblComputers.Description From dbo.tblComputers Inner Join dbo.tblNetwork On dbo.tblComputers.Computername = dbo.tblNetwork.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Where dbo.tblNetwork.DNSServerSearchOrder <> '' And dbo.tblNetwork.IPAddress <> '0.0.0.0' And dbo.tblNetwork.IPEnabled = 1 And dbo.tblNetwork.IPAddress <> '' Order By dbo.tblNetwork.DNSServerSearchOrder

I have tried a few things, But either i get back many multiples of the same record or i get an error when i run the report.

Many Thanks,

Kev

[Hemoco · Accepted solution]

Please try the following query:

Select Top 1000000 tblComputers.Computer, tblComputers.Username,
tblNetwork.DNSServerSearchOrder As [DNS server], tblNetwork.IPAddress,
tblNetwork.Lastchanged, tblNetwork.DefaultIPGateway, tblNetwork.DHCPserver,
tblNetwork.DHCPenabled, Web40OSName.OSname, Web40OSName.SP,
tblComputers.Description
From tblComputers Inner Join
tblNetwork On tblComputers.Computername = tblNetwork.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblNetwork.DNSServerSearchOrder <> '' And tblNetwork.IPAddress <>
'0.0.0.0' And tblNetwork.IPEnabled = 1 And tblNetwork.IPAddress <> '' And
tblComputersystem.Domainrole > 1
Order By tblNetwork.DNSServerSearchOrder