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.
How ? works in below query? and how <> restricts particular type of string to get ignored?
Select * from v_GS_NETWORK_ADAPTER_CONFIGUR where TimeStamp > ? AND IPAddress0 IS NOT NULL And IPAddress0 <> '0.0.0.0' ORDER BY TimeStamp
1 of 1 people found this helpful
? will be replaced with the variable. The variable is defined in the step configuration and is passed by the previous step in the transformation.
<> means different then, also known as !=
the "?" is for a variable I had set for delta date.