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?
In cases like 10.20.44.127, fe80::e933:3b8:1c5b:412b you will have to parse this list, and then make a decision based on the parsing.
You can use split with a separator of , to get all the IP addresses.
Then iterate through the list of addresses.
Discard the ones that contain : in them.
After this is done you may need to rejoin the final list to a single string.
Yes, that means each different IP Address will be an IPEndpoint CI. I thought I remembered that step in there.