PC, OS, SP1 and IP Address

SELECT
    CS.Name0,
    OS.Caption0,
    OS.CSDVersion0,
    NAC.IPAddress0
FROM
    dbo.v_GS_Computer_System CS
    JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceID = NAC.ResourceID 
    JOIN dbo.v_GS_OPERATING_SYSTEM OS on CS.ResourceID = OS.ResourceID 
WHERE    
    (NOT (NAC.IPAddress0 = ‘NULL’))
    And NAC.IPAddress0 != ‘0.0.0.0’
ORDER BY
    CS.Name0

Leave a Reply

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