About banzen

banzen · ‎03-22-2018

And if my list continues to grow, just keep adding OR statements? OR " " OR "" OR "" ? I can do do this, just thought there was a cleaner way, like anything LIKE or IN ("bob*,"tube*", "next*")

banzen · ‎03-21-2018

Hi, I am trying to omit search results for a field that might have a couple of different values. any ideas how to best do this? Is EVAL or LIKE the way to go? Here's some sample data: computerdisconnected="[bob sbr] [tube tue]" computerdisconnected="[tube tue]" condition- If the computerdisconnected contains any values like "bob or "Tube" then don't return any results. In other words I am getting regular reminders that these machines are disconnected, I only want NEW results so I want to keep a list of repeat offenders and ignore them. Thanks in advance

banzen · ‎02-14-2018

Hi, I have troubles with a search. I want results ONLY when my "disconnected=" has a value besides blov6 berg Unfiltered result: Disconnected="[blov6 berg ] [dj7 berger]" , I would want to know about this.. Could look like this too Disconnected="[blov6 berg ] [ejb7 rger] [rf34 reef]", Disconnected="[blov6 berg ] [dj7 berger] [l42 loop][ddd door]" Would also want to know.... This I don't care about Disconnected="[blov6 berg ]" Here's what I am trying in my search host=* Disconnected | where disconnected !="" | where NOT like(_raw, "%blov6%") Suggestions?

Posts	3
Solutions	0
Karma Given	1
Karma Received	0
Member Since	‎02-14-2018

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

Search for multiple values in field

Search with like / only when more than one value

Re: Search for multiple values in field

Search for multiple values in field

Search with like / only when more than one value