PCs with IPv6 Address

select
    CS.Name0,
    NAC.IPAddress0
from
    dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
    Join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = NAC.ResourceID
Where
    IPAddress0 like ‘%:%’