SELECT
CS.Name0,
NA.Name0,
NAC.IPAddress0,
NAC.DefaultIPGateway0,
NAC.IPSubnet0,
NAC.DNSHostName0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_NETWORK_ADAPTER NA,
dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
WHERE
NAC.ResourceID = CS.ResourceID
AND NA.ResourceID = CS.ResourceID
AND NA.ServiceName0 = NAC.ServiceName0
AND NAC.DHCPEnabled0<>1
AND NAC.IPAddress0<>’NULL’
ORDER BY
CS.Name0,
NA.Name0,
NAC.IPAddress0