Mailing List Archive: Searching for ip-numbers in RT

Searching for ip-numbers in RT

Nov 19, 2016, 1:13 AM

Post #1 of 3 (875 views)

Hi,

I have some trouble to get the free text (content I believe) search for
IP-numbers in RT correct. I/we have got about 24k tickets in our system.
When I search for a number it seems to be truncated in some way. Unclear
how.

Ex. (Edit Query mode)

( Content LIKE '127.0.0.2' )
Found 311 tickets

( Content LIKE '127.' )
Found 311 tickets

( Content LIKE '194.22.77.33' )
Found 2,944 tickets

( Content LIKE '194.' )
Found 2,944 tickets

I'm quite certain we have got a lot of tickets that has "127" in them.
We've probably no one with "194.22.77.33".
I've tried a number of ways to escape the characters but no luck. Double
quotes turn into single quotes so normal distinction between them is
off. Equal sign or LIKE is the same here. How do I construct a search
for IP-numbers in RT to get tickets with one explicit IP number?

PS. Search in Subject works as expected. DS

regards,

--

Bengt Gördén
Resilans AB

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: Searching for ip-numbers in RT [ In reply to ]

ktm at rice

Nov 19, 2016, 11:28 AM

Post #2 of 3 (861 views)

Permalink

Quoting Bengt GÃ¶rdÃ©n <bengan@resilans.se>:

> Hi,
>
>
> I have some trouble to get the free text (content I believe) search for
> IP-numbers in RT correct. I/we have got about 24k tickets in our system.
> When I search for a number it seems to be truncated in some way. Unclear
> how.
>
> Ex. (Edit Query mode)
>
> ( Content LIKE '127.0.0.2' )
> Found 311 tickets
>
> ( Content LIKE '127.' )
> Found 311 tickets
>
> ( Content LIKE '194.22.77.33' )
> Found 2,944 tickets
>
> ( Content LIKE '194.' )
> Found 2,944 tickets
>
>
> I'm quite certain we have got a lot of tickets that has "127" in them.
> We've probably no one with "194.22.77.33".
> I've tried a number of ways to escape the characters but no luck. Double
> quotes turn into single quotes so normal distinction between them is
> off. Equal sign or LIKE is the same here. How do I construct a search
> for IP-numbers in RT to get tickets with one explicit IP number?
>
> PS. Search in Subject works as expected. DS
>
> regards,
>
>
> --
>
> Bengt GÃ¶rdÃ©n

Hi,
What db and text search are you using? Postgresql definitely works for
this. Maybe there are some adjustments that you need to make.

Regards,
Ken

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017

Re: Searching for ip-numbers in RT [ In reply to ]

bengan at resilans

Nov 21, 2016, 5:13 AM

Post #3 of 3 (852 views)

Permalink

Den 2016-11-19 kl. 20:28, skrev ktm@rice.edu:
> Quoting Bengt GÃ¶rdÃ©n <bengan@resilans.se>:
>
>> Hi,
>>
>>
>> I have some trouble to get the free text (content I believe) search for
>> IP-numbers in RT correct. I/we have got about 24k tickets in our system.
>> When I search for a number it seems to be truncated in some way. Unclear
>> how.
>>
>> Ex. (Edit Query mode)
>>
>> ( Content LIKE '127.0.0.2' )
>> Found 311 tickets
>>
>> ( Content LIKE '127.' )
>> Found 311 tickets
>>
>> ( Content LIKE '194.22.77.33' )
>> Found 2,944 tickets
>>
>> ( Content LIKE '194.' )
>> Found 2,944 tickets
>>
>>
>> I'm quite certain we have got a lot of tickets that has "127" in them.
>> We've probably no one with "194.22.77.33".
>> I've tried a number of ways to escape the characters but no luck. Double
>> quotes turn into single quotes so normal distinction between them is
>> off. Equal sign or LIKE is the same here. How do I construct a search
>> for IP-numbers in RT to get tickets with one explicit IP number?
>>
>> PS. Search in Subject works as expected. DS
>>
>> regards,
>>
>>
>> --
>>
>> Bengt GÃ¶rdÃ©n
>
> Hi,

Hi,

Sorry for the late reply.

> What db and text search are you using? Postgresql definitely works for
> this. Maybe there are some adjustments that you need to make.
>

mysql and sphinx. It might be some adjustments for sphinx that we
haven't figured out yet. Normal search seems to be no problem.

regards,

--

Bengt GÃ¶rdÃ©n
Resilans AB

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017