SMSUG.ca

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

Garth Jones

IP History

SELECT
    CS.Name0,
    HNAC.TimeStamp,
    HNAC.DefaultIPGateway0,
    HNAC.DHCPServer0,
    HNAC.DNSDomain0,
    HNAC.DNSHostName0,
    HNAC.IPAddress0,
    HNAC.IPSubnet0,
    HNAC.MACAddress0,
    HNAC.ServiceName0
FROM
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_HS_NETWORK_ADAPTER_CONFIGUR HNAC
WHERE
    HNAC.ResourceID = CS.ResourceID
    and HNAC.DHCPEnabled0 = 1
    and HNAC.IPAddress0 != 'NULL'
    and HNAC.IPAddress0 != '0.0.0.0'
Order by
    CS.Name0,
    HNAC.TimeStamp

Published Sep 24 2008, 03:04 PM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

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