MCP Vertica

SELECT COUNT(*) AS alerts FROM {schema}.opr_event WHERE related_ci_cmdb_id = %s AND lifecycle_state = 'open' AND time_created BETWEEN %s AND %s AND (LOWER(category) LIKE '%%security%%' OR LOWER(title) LIKE '%%security%%' OR LOWER(description) LIKE '%%security%%');