Audit and Remediation: Creating New Query Fails With "Query is not valid SQL. Syntax error found near Identifier (SELECT Results Clause)"

Products

• Carbon Black Cloud Audit and Remediation (formerly Cb Live Ops)

Issue/Introduction

Getting error when trying to save a query "Query is not valid SQL. Syntax error found near Identifier (SELECT Results Clause)"

Environment

• Audit and Remediation (formerly LiveQuery): All Supported Versions

Cause

This can happen if the SQL Query syntax is wrong, like adding extra special characters

Resolution

Make sure that there are no duplicate or extra characters in the query