So I have successfully used the executeQuery command to extract all sorts of other data sets but when I am attempting to query Policy Auditor data I run into a issue. Has anyone else seen this?
mc = mcafee.client(address, port, username, password)
target = 'PAAuditRuleResultView'
select = '(PAAuditRuleResultView.BenchmarkID PAAuditRuleResultView.RuleID PAXRuleTextView.Title)'
where = '( where ( and ( eq PAAuditRuleResultView.ActualResult "fail" ) ( eq PAAuditRuleResultView.IsCurrentResult t ) ( eq PAAuditRuleResultView.SystemName "%s" ) ) )' % (systemname)
order = '(order(asc PAAuditRuleResultView.BenchmarkID))'
data = mc.core.executeQuery(target=target, select=select, where=where, order=order)
When I run this code I get this error
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "mcafee.py", line 454, in __call__
mcafee.CommandInvokerError: Invalid S-expression in 'select' clause: PAAuditRuleResultView.BenchmarkID
Go to Solution.
I don't use python on a regular basis... but did you forget the 'select' part of the command?
select = '(select PAAuditRuleResultView.BenchmarkID PAAuditRuleResultView.RuleID PAXRuleTextView.Title)'
Yep that is exactly what it was apparently I had been looking at code too long yesterday and totally overlooked that. Found it this morning upon coming in. Thankks for the help
Download the new ePolicy Orchestrator (ePO) Support Center Extension which simplifies ePO management and provides support resources directly in the console. Learn more about ePO Support Center
2821 Mission College Blvd.
Santa Clara, CA 95054 USA
Consumer Support | Enterprise Support | McAfee.com
Legal | Privacy | Copyright © 2019 McAfee, LLC