7 Replies Latest reply on Jul 14, 2017 2:58 PM 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