1 Reply Latest reply on Apr 17, 2017 10:26 AM by Guramandeep Dhillon

    Spoon SCCMIntegration_IPEndpoint  transformation

    Guramandeep Dhillon

      Hi Everyone,

       

      I was testing the Spoon SCCMIntegration_IPEndpoint and noticed 2 issues

      1.it loads 0.0.0.0

      2. It brings in IPv4 and IPv6 address for some Computers. Any idea how I can just limit it to IPv4 addresses?

       

      for the 1st issue:

      I updated the Table Source step from:

       

      Select * from v_GS_NETWORK_ADAPTER_CONFIGUR where TimeStamp > ? AND IPAddress0 IS NOT NULL ORDER BY TimeStamp.

       

      to

       

      Select * from v_GS_NETWORK_ADAPTER_CONFIGUR where TimeStamp > ? AND IPAddress0 IS NOT NULL And IPAddress0 <> '0.0.0.0' ORDER BY TimeStamp

       

       

       

      but when I load data I notice 0.0.0.0 address were still being loaded into SCCM dataset.

       

      I am on Atrium 9.

      Thanks

      SCCMIntegration_IPEndpoint

        • 1. Re: Spoon SCCMIntegration_IPEndpoint  transformation
          Guramandeep Dhillon

          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?