Create a custom report

[itdpt]

Hello

I was wondering if there is a way to get a report of this tipe

i have several machines, some with dns x.x.x.1 and some x.x.x.2

I need a report which can tellme which are the ones with x.x.x.1 and the x.x.x.2

Is this possible ?

Cheers 😄

It dp

[itdpt]

Worked like a charm !

Thank You very Much 😄

[Hemoco]

Try this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblNetwork.DNSServerSearchOrder
From tblComputers Inner Join
  tblNetwork On tblComputers.Computername = tblNetwork.Computername
Where tblNetwork.DNSServerSearchOrder Like '%x.x.x.1%'