I was able to remove 0.0.0.0 and IPv6 address with the updates below:
Select * from v_GS_NETWORK_ADAPTER_CONFIGUR where TimeStamp > ? AND IPAddress0 IS NOT NULL And IPAddress0 <> '0.0.0.0' And IPAddress0 <> '0.0.0.0, 0.0.0.0' And IPAddress0 <> 'fe80%' ORDER BY TimeStamp
But I noticed that SCCM IPAddress0 table has some entries with both IPv4 and IPv6 address for example :10.20.44.127, fe80::e933:3b8:1c5b:412b.
Is there a vary to only import the IPv4 address into the CMDB?