the RSD inbuilt function converts the IPV4 int value to string (as noted in reply to your other post)
Thanks for helping. But This function RSDFN_ConvertIntToIPString is not there in my funtions->scalar-valued-functions->..
I tried running the command but it says 'RSDFN_ConvertIntToIPString' is not a recognized built-in function name.
Which Epo version are u using and can u send me this functions location and definition..
thanks a lot,
If you are using ePO 4.0, you will need to install Rogue System Detection to get this function.
Thanks to the information from Greg's post, I was able to find a way to do this without installing Rogue System detection -- which I don't have approval to do in my environment (at least not yet). I was able to extract the code from the RSD installation files that creates the function and use that to create a new stand-alone function. I would recommend changing the name of the function (RSDFN_ConvertIntToIPString) so that any future installs/upgrades of RSD will not be impacted. I just changed the RSDFN prefix on mine.CREATE FUNCTION [dbo].[RSDFN_ConvertIntToIPString]
declare @o1 bigint, @o2 bigint, @o3 bigint, @o4 bigint;
declare @ip bigint;-- This is the magic epo conversion size...
set @ip = (CAST(@ipin as bigint) + 2147483647) + 1;SET @o1 = @ip / 16777216;
SET @ip = @ip % 16777216;
SET @o2 = @ip / 65536;
SET @ip = @ip % 65536;
SET @o3 = @ip / 256;
SET @ip = @ip % 256;
SET @o4 = @ip;RETURN
CONVERT(VARCHAR(4), @o1) + '.' +
CONVERT(VARCHAR(4), @o2) + '.' +
CONVERT(VARCHAR(4), @o3) + '.' +