Audit and Remediation: Creating New Query Fails With "Query is not valid SQL. Syntax error found near Identifier (SELECT Results Clause)"
book
Article ID: 289320
calendar_today
Updated On:
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
Feedback
thumb_up
Yes
thumb_down
No