Audit and Remediation: Query Fails With Error "Constraint failed"

Products

• Carbon Black Cloud Enterprise EDR (formerly Cb Threathunter)

Issue/Introduction

Running a live query fails with error "Constraint failed"

Environment

• Carbon Black Cloud Console: All Supported Versions

Cause

This happens if one of the SELECT commands requires a WHERE clause to go with it

Resolution

Add a WHERE clause which references the SELECT statement

Additional Information

One example of this is the hash table which requires a path or directory WHERE statement