csharma180
-
Total Posts
:
400
- Scores: -6
-
Reward points
:
34330
- Joined: 12/29/2008
-
Status: offline
|
DNS Server IP Report
Friday, August 17, 2012 3:05 PM
( permalink)
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
|
|
|
|
gjones
-
Total Posts
:
2291
- Scores: 136
-
Reward points
:
97820
- Joined: 6/5/2001
- Location: Ottawa, Ontario, Canada
-
Status: offline
|
Re:DNS Server IP Report
Saturday, August 18, 2012 3:56 PM
( permalink)
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%'
|
|
|
|