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