List all non-DHCP NICs

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

Leave a Reply

Your email address will not be published. Required fields are marked *