PCs with more than IP Address.

select
    NAC.DNSHostName0,
    count(NAC.ResourceID)
from
    dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
Where
    IPAddress0 is NOT NULL
Group by
    NAC.ResourceID,
    NAC.DNSHostName0
Having
    count(NAC.ResourceID)>1
Order by
    NAC.DNSHostName0

Leave a Reply

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