SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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

Published Dec 05 2008, 06:39 PM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems