MrSlithy
asked on
Help with Boolean Search
I am creating a default query to base a scope on and I need some help. LAN
As part of the query, I have about 8 or 9 specific machine names I want to exclude, and several others that have similar, but not exact name.
So when I get to this grouping in the query
AND ("Computer"."Device Name" NOT LIKE "Specificmachine1"
OR "Computer"."Device Name" NOT LIKE "Specificmachine2"
OR "Computer"."Device Name" NOT LIKE "Specificmachine3"
OR "Computer"."Device Name" NOT LIKE "Specificmachine4"
OR "Computer"."Device Name" NOT LIKE "ABDR")
The first 4 in the example are specific names of computer, the last on is PART of a name that appears in several computers. But when I run the query, that last line is ignored and I see computers with ABDR in the results.
What I want for that like is any computer with ADBR anywhere in the device name.
Me and Boolean searches only cooperate so far and then I go nuts.
Thanks
As part of the query, I have about 8 or 9 specific machine names I want to exclude, and several others that have similar, but not exact name.
So when I get to this grouping in the query
AND ("Computer"."Device Name" NOT LIKE "Specificmachine1"
OR "Computer"."Device Name" NOT LIKE "Specificmachine2"
OR "Computer"."Device Name" NOT LIKE "Specificmachine3"
OR "Computer"."Device Name" NOT LIKE "Specificmachine4"
OR "Computer"."Device Name" NOT LIKE "ABDR")
The first 4 in the example are specific names of computer, the last on is PART of a name that appears in several computers. But when I run the query, that last line is ignored and I see computers with ABDR in the results.
What I want for that like is any computer with ADBR anywhere in the device name.
Me and Boolean searches only cooperate so far and then I go nuts.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So maybe I'' try creating a group of two operators and see what happens
*ABDR or ABDR*
Will only return results that start or end with ABDR.
ASKER
That's it! CONAINS. Duh!
This is a Landesk query builder and I only have the following options
+, <>, <=,>=,<,>,Exist, not exist. like, not like.
So that explains it. There are, indeed, several variations.
This is a Landesk query builder and I only have the following options
+, <>, <=,>=,<,>,Exist, not exist. like, not like.
So that explains it. There are, indeed, several variations.
ASKER
But now that I look more closely at Landesk help on this I see that it does allow for"*ABDR" and also for "ABRD*"
but I was trying *ABDR* and couldn't get it to work.
So maybe I'' try creating a group of two operators and see what happens
*ABDR or ABDR*
Thanks.