William Guilherme
11/18/2020, 11:28 PMSELECT * FROM processes WHERE name='com.crowdstrike.falcon.Agent' OR 'falcond' AND (state='R' OR '82');
The process name com.crowdstrike.falcon.Agent is only present in BigSur but not in previous OS versions. Previous OSs, the process is called falcond. In other words, I need to be able to evaluate which one is true, but the above query is only working in BigSur. Any ideas on how to improve this query? Thank youzwass
11/18/2020, 11:30 PMSELECT * FROM processes WHERE name IN ('com.crowdstrike.falcon.Agent', 'falcond') AND state IN ('R', '82');
William Guilherme
11/18/2020, 11:40 PMfritz
11/19/2020, 1:03 AMOR
condition.
So where you have AND (state='R' OR '82')
if you wanted to use OR
instead of IN
you would need to write: AND (state='R' OR state ='82')
William Guilherme
11/19/2020, 1:08 AM