RSA Envision custom report using aggregates in SQL clause gives error

Discussion created by BalajiSastry on Sep 17, 2013
Latest reply on Jan 20, 2014 by raggeler

I would like to create a Windows failed logons report that shows users exceeding 50 failed logons. How can I specify criteria to show me failed logons that exceed a number say 50. When I put in criteria where count(username) > 50, I get an error

Invalid SQL WHERE clause: .
ASA Error -150: Invalid use of an aggregate function.

Thanks for your help.