cancel
Showing results for 
Search instead for 
Did you mean: 

Function to Convert Int to Ip address std format??

In the EPO database, the ip address fields are stored in int format. IS there a function I can use in my query that can convert the int format to IP address in Standard format

for eg:-

-1973099206 to xxx.xxx.xxx.xxx

I know this can be done manully but I am looking for a function in a query that can do this???

3 Replies
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: Function to Convert Int to Ip address std format??

Try dbo.ePOConvertIPStringToIPv4(IPAddress)

Re: Function to Convert Int to Ip address std format??

dbo.ePOConvertIPStringToIPv4, doesn't work..

I used this to convert it to binary but not able to convert this to std format???

dbo.epoConvertIntToIPV4Binary(E1.SourceIPV4)

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: Function to Convert Int to Ip address std format??

This one works on my test machine:

SELECT ComputerName, dbo.RSDFN_ConvertIntToIpString(IPV4x) from ePOComputerProperties