 Rank: Premium user Groups: Member, Premium Users
Posts: 13
Location: italy
|
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 :D
It dp
|
|
|
|
|
|
 Rank: Administration Groups: Administration, Premium Users
Posts: 10,379
|
Try this: Code: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%'
|
|
|
|
|
|
Rank: Premium user Groups: Member, Premium Users
Posts: 13
Location: italy
|
Worked like a charm !
Thank You very Much :D
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
