Convert IP Address format from ForeFront Firewall logs with SQL
- by TrevJen
I am trying to query IP addresses from Forefront Firewall logs, and I am a little stuck on the IP formatting
C0A8E008-FFFF-0000-0000-000000000000
Can anyone give me the MSSQL command to turn this into standard human redable?
UPDATE, I now see that I kust need to convert the first 8 charecters from hex to decimal....which I can then convert to IP. the trick is to parse those first charecters from the field with SQL