AnsweredAssumed Answered

Question - Work with IP-Range

Question asked by Stigge on Feb 13, 2017
Latest reply on Feb 14, 2017 by Stigge

Hi all

 

I have 2 tables

1 - Sites

2 - Assets

 

In "sites" i have 2 variables, <Start of IP Range> and <End of IP Range>

example:

Site1 =

IP_Start = 10.10.10.1

IP_End = 10.10.10.255

 

Site2 = 

IP_Start = 10.5.5.1

IP_ENd = 10.5.5.255

 

and in "assets" i have <IP>.

example:

Asset1 =

IP = 10.10.10.141

 

 

Relation:

Asset  -   Sites

<IP>   <  <IP_End>

<IP>   >  <IP_Start>

 

But i cant get it to show correct "Site" in my assets. Fields are text, tryed to do a calculated field GetAsNumber( <Field> ). and remade the relation to the number field instead. but i think it has problem to convert it to a number. not sure. But am guessing its some trick to use here.

 

Anyone have any idea ?  =)

 

 

Thank you

/Stigge

Outcomes