Endpoint Protection

Hi,

We're planning to migrate more than 6500 POS from SEP 11.x to SEP12.

The migration will take place overs 7 weeks at a rythm of ~200 pos per day.

For this i need to be able to search clients finishing with 2 numbers.

For example for the first migration i need to search every clients finishing with 01.

I'm using LIKE comparison operator and % but it just display every clients containing 01 and not finishing with 01.

Do you know how i can do this ?

Thanks,

Regards,

Thats what LIKE will do

• LIKE ( from help file)

  Places a wildcard "%"character at both the beginning or the end of the string you typed. The query then locates any strings that begin with, end with, or contain the value you typed.

• use LIKE operator ,  export the result,  then use excel.

Use "%"

For example, if looking for a machines ending with test1, using the following:

%test1

This will show what you need.

Hi guys, i had a problem with the other account.

I already tried % but for example when i type 001 in the value field display field the search also display elements containing 001 :

This is expected behaviour

Thats what it does, when you select LIKE, it would put % at the beginning and end automatically, with that you would be searching for %Machinename%

it would pickup 01machine and machine01, best bet would be to use excel.

=================================== from help file========================

• Places a wildcard "%"character at both the beginning or the end of the string you typed. The query then locates any strings that begin with, end with, or contain the value you typed.

• use LIKE operator ,  export the result,  then use excel.

• =================================================================

Ok thanks so basically i can't do what i want and i will have to manually filter the computers when i'll move them from the search to the update group.

You can try 001% as well but it probably return the same result.