The WHERE section of your SQL must contain
WHERE @filter so Open-AudIT knows to restrict your query to the appropriate Orgs.
SQL not containing this condition will result in the widget failing to be executed.
The SQL cannot contain WHERE @filter
WHERE @filter OR. That SQL will not be executed, however
WHERE @filter AND queries queries are allowed.
An example widget SQL showing devices counted per location.