1 Reply Latest reply on Dec 3, 2009 6:16 PM by GWIRT

    How to convert IPV4 address in Int to standard format???

      IN the sql database - EPOEvents table this field AnalyzerIPV4 is in a non standard format like -1973099182 instead of  xxx.xxx.xxx.xxx.

       

      Any thoughts on converting this ???

        • 1. Re: How to convert IPV4 address in Int to standard format???
          GWIRT

          The steps I usually take to convert this are probably more complicated than needed by here's what I do:

           

          1. Convert the decimal value to binary. In this case you get:

           

               1973099182 --> 1110101100110110001101010101110

           

          2. Count out your octets from the right most bit:

           

               1110101.10011011.00011010.10101110

           

          3. Convert the octets back to decimal:

           

               117.155.26.174

           

           

          There you go...