List PCs with Static IP Addresses

select 
    CS.Name0,
    NAC.IPAddress0
from
    dbo.v_GS_COMPUTER_SYSTEM cs
    JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceId = NAC.ResourceId
Where
    NAC.IPAddress0 !=”
    and DHCPEnabled0 = 0